Is there a simplier way to backfill box 7 on existing AP bills once a vendor becomes 1099-eligible? AP Bills that were created before vendor became 1099-eligible shows blank, while the AP bills created after vendor became 1099-eligible shows box 7. Currently i have to open every bill and add box 7 manually, which is a huge waste of time.
Solved
backfill box 7 for all yearly bills after vendor was deemed 1099-eligible
Best answer by mikedavidson07
Depending on your version of Acumatica, (Requires the GI for Bills and Adjustment for steps 1 and 2)
you could:
- Go to the Payables, Billes and Adjustments.
- Filter the grid to show the vendor in question and filter on an invoice date range. This will show your bills and adjustments for the period.
- Open one of the existing invoices in question (an invoice that may have the wrong 1099 coding).
- As long as the Vendor is marked 1099, you should be able to edit the Document Details line and change the 1099 Box by clicking in it and getting the dropdown list choosing 7-NEC. This change can be made for “Closed” (paid) documents.
Steps 1 and 2 are not necessary but make the process a little easier.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.