1099 Edit List includes Vendors who are not presently flagged as any 1099 Vendor Type, and have never been flagged as anything other than 'Not a 1099 Vendor'
Is ther additional 1099 setup that could cause this?
*This post is locked for comments
1099 Edit List includes Vendors who are not presently flagged as any 1099 Vendor Type, and have never been flagged as anything other than 'Not a 1099 Vendor'
Is ther additional 1099 setup that could cause this?
*This post is locked for comments
Got the answer from Microsoft:
1. Make sure your minimums in the 1099 Setup (Setup>>Payables>>1099's) all have at least a .01 on them.
2. Some of the boxes in the setup are wrong and there is a script to correct. And has to be run against each company.
From Microsoft:
(Go to Tools>Setup>Purchasing>Payables then click the 1099 setup button and ensure the 1099 type does not have any 0 dollar boxes. This year there is also a small issue with boxs being mislabeled in some cases due to the new box that was added. The below script resolved. (against each company)
UPDATE PM40104 SET TEN99BOXTEXT = 13, DOLRAMNT = .01 WHERE TEN99BOXNUMBER = 11 AND TEN99TYPE = 3
UPDATE PM40104 SET TEN99BOXTEXT = 14, DOLRAMNT = .01 WHERE TEN99BOXNUMBER = 12 AND TEN99TYPE = 3
UPDATE PM40104 SET DOLRAMNT = 600.00 WHERE TEN99BOXNUMBER = 15 AND TEN99TYPE = 3
Did you possibly run into the 2020 year-end update known issue, documented here?
community.dynamics.com/.../microsoft-dynamics-gp-fall-2020-update---known-upgrade-issues
If a vendor should never have been set up as a 1099 vendor, you need to zero out their 1099 transaction or period information prior to setting them to "Not a 1099 Vendor". (Changing a vendor's status is Vendor Maintenance window does not impact the way prior transactions were flagged. This is by design to allow for mid-year vendor status changes.)
To get the vendors off the 1099 Edit List, set them to be a 1099 vendor again and then Edit 1099 Transactions or Edit 1099 Vendor Details to clear their amounts. Once the 1099 amounts are zero, go back to Vendor Maintenance and set the Vendor to a "Not a 1099 Vendor."
Now have two different companies with the same issue. It is printing all the Vendors not just 1099 NEC vendors.
Think we can get an answer before January 31. LOL
I have the exact same issue with one of my customers. They have a dozen companies and this is happening in only one company. All companies share the same 1099 reports and none of them are modified. Most vendors in this company (95%) are not 1099 vendors, yet all print on the edit list AND print a form and are all $0.00 except for the few that are real 1099 vendors and have an amount. Every single vendor is printing.
Were you able to find what was happening to your 1099s? Hoping it could help here since they have to print by Friday this week!
Thanks!
André Arnaud de Cal...
293,278
Super User 2025 Season 1
Martin Dráb
231,983
Most Valuable Professional
nmaenpaa
101,156
Moderator