35
Certain Vendors are showing $0 in the 1099 amounts - 1099 box was checked and invoices were paid. This appears to be random as others are calculating correctly. Any ideas? Thanks in advance.
The default box in each Vendor record is only a default value, users can override at the time of entering an invoice, or the vendor may have had 1099 tracking turned on after their first invoices were processed. In any case, using initialize mode will allow updating the incorrect 1099 totals for those vendors.
Were the AP Transaction 1099 Box selections correct when they were entered? (i.e. the correct box was selected when entered into the voucher and adj entry screen?)
I have attached a SQL script that you can use as a starting point to help identify differences between what was paid and what is currently reported on the 1099 box. There are some variables at the top you can change to get different results. I'm not guaranteeing this file, it's up to you to verify that results are pulling correctly :)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
