Sage 100

Client contacted us today and said that the 1099 information is missing on almost all vendors. these are vendors that have been getting 1099's for years some are NEC and some are legal. they are on version 2022 pu5 and we upgraded them to that version in early 2023. last year those vendors received 1099's.  Client is asking how this could have happened and why.  I'm at a loss to help give them any sort of explanation. I looked at a couple of vendors and they do have audit tracking turned on. I can see the 1099 information was changed back in January of 2023. 

just wondering if anyone has ever seen this? 

Hi David,

Have you checked to see if there is any data in the AP_Vendor1099Payments.m4t file?
It's possible that the data is there but it has the wrong form type or some other corruption.

David does that mean the 1099 payment info in AP_Vendor1099Payments is missing or that they are not marked in Vendor Maint for 1099? If it turns out all the 1099 data in 2022.5 is there but not generating for 1099 eFile, if you can install PU6 for 2022 that would be compatible with the 2024 IRD according to the Sage Year End document. Just a thought.

I just now checked and there is no data in the AP_Vendor1099Payments file for the 2024 year. prior year's data is there however, and if you look in vendor maintenance they are clearly marked as a 1099 vendor, and the form is correct.  they have vendor audit tracking turned on and the vendors I looked at showed that in January of 2023 they changed from Misc Form to NEC form and that was the last change to those 2 vendors that I checked the audit logs for.  

also I'm looking at the IRD supported versions and it looks like 2022.3 - 2022.6 are all compatible, I am about to put the IRD on for them. do you know something contrary? 

Also , did I mention that I think this client has a server that sits on an Indian Burial Ground? 

------------------------------
David Overholt
DWD Technology Group
------------------------------

I think the mystery on this one is solved!!! . They are importing invoices for these vendors and the import job is expecting the 1099 settings to be included on the import. I am not sure who designed the import job, but I will take the 1099 form and box number lines out of the import job and let the business logic do its magic and assign the 1099 settings from the vendor master file. Or worst-case I can file assign them, but the business logic should do it for me.