1099 Report Totals not matching 1099 Form Totals

Kinetic ERP
1

Going through the annual 1099 reporting process. I successfully processed all 1099-MISC forms without issue. However, I’m having a heck of a time with 4 records in the 1099-NEC batch. I ran the 1099 Report with the “Details” and “Include All Records” boxes checked. Data matches info I independently created from a BAQ as a double-check.

When I run the Print 1099 Forms US program, the totals are vastly different. For example, one vendor has totals of ~ $80k but the Form shows ~ $130k. I ran the regenerate calculations process and the 1099 Report actually showed the correct $80k with notes in parenthesis (Changed: Prior Amount 130,373.38), yet the $130,373.38 still prints on the 1099 Form. By the way, there isn’t any detail anywhere on the 1099 Report and in the system to justify the $130k. We have no idea where that number is coming from.

I could create “adjustments” to bring the Form totals down, but then my backup 1099 Report will be incorrect. Is anyone else having this issue? I’m going around in circles and wanted to reach out to you guys before I contact support.

2

Additional information for this Post

Last January, we were on 10.2.300. At that time, we had 3 1099 Form Types available 1099-DIV, 1099-INT, and 1099-MISC. They were all flagged as System codes. We needed to manually create the 1099-NEC form type. I created that form type and processed last year’s 1099-MISCa and 1099-NECs without issue.

Tech Support worked with me on the issue posted above and thought that a possible reason for my data not matching was because I was using a non-System-type form. I thought that was weird since Epicor provides the ability, and provides the instructions, to create a new Form Type and I had no problem with this last year. However, we upgraded to 2022.1.18 in October 2022, which could have affected some things. They had me rerun the 1099 Conversion process, which I thought was something that only ever needed to be run once in order to add the USA tab to the appropriate areas of the system (Company config, Supplier maintenance, Invoice Entry, Posted Invoice Update, etc.). Running this process created 3 additional forms:

1099-K
1099-MISC_20
1099-MISC_22

All these had the System flag as “TRUE” but it did not over-write my 1099-NEC code’s System flag. Tech Support then sent me a “fix”, which just basically changed the System flag from FALSE to TRUE. I reran the Generation again as both Regenerate and Recalculate, but the data still didn’t update correctly. Tech Support is not responding, so we have since manually fixed the 4 problem records on the physical forms and in the electronic file we need to send to the IRS.

I just wanted you all to be aware that if you are missing any Form Types, you may have to rerun the 1099 Conversion process in System Management > Rebuild Processes > Finance > 1099 Conversion US. Run with the “Report and Update” option selected.

Additionally, all the 2022 1099-MISC forms I created were created under the old 1099-MISC Form Type. The reason my data came out okay was because I also manually updated the 1099 Box Number definitions. I thought that this was weird that I had to do that and, as such, took screen shots of what they used to be so that I could have some historical background. Had this information been disseminated properly, this year’s 1099 process would have gone much smoother. :frowning: