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
View originalIf you know the amount they should be 1099 you can use the same method as when you convert mid year. --Quick Check to the vendor for that amount going in and out of the same cash account.
thank you for that. however, it’s required to know the amount, which i don’t usually know until i open old bills. It would be fantastic if Acumatica can introduce a method to backfill box 7 without Quick Check workaround
Depending on your version of Acumatica, (Requires the GI for Bills and Adjustment for steps 1 and 2)
you could:
Steps 1 and 2 are not necessary but make the process a little easier.
I was able to write an import to update the box lines on all the bill that needed updating. I had to update bills for the entire year (2000 records). The import updates in a minute instead of open each bill and changing each line.
That is a much better option when you have many records to update.
I was able to write an import to update the box lines on all the bill that needed updating. I had to update bills for the entire year (2000 records). The import updates in a minute instead of open each bill and changing each line.
the Import scenario is a wonderful option. However, it requires one crucial step: knowing which bills to update the box 7 for. this is a sequence in our year-end procedures
my proposal / idea suggestion is this - why not ask Acumatica to design a code to do #4 and #5 above automatically as part of the Actions menu? this is a necessary step for all 1099 filing, so i feel like this should be a natural timesaver for accountants during year-end.
yes, just had a client that had to do the same thing. I made a GI that showed all vendors that are 1099 vendors with bills (per line) that do not have a 1099 box filed out. Then export the GI results and fill out the box in excel. Still a bit of a pain but way easier than manually doing it.
I agree -- the import scenario is the way to go here. I noticed (in November) that all bills entered prior to our AP department selecting “1099 vendor” and Box 7, were not showing up on my 1099 reports. I provided a list of all vendors who needed the 1099 box updated, and my support team was able to update these with an import scenario.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
