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.
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.