Went live with Acumatica this year. Unfortunately default 1099 box for many vendors was set up incorrectly and there are now 4000 AP Bill lines that need to be updated. This is a SaaS environment so don’t have direct access to database. If I knew the correct tables to update (APTran, others) I could write a SQL update customization to update to correct 1099 box. Second option that I’ve been struggling with is an Import Scenario to update the AP lines. It seemed this should be easy. Pass the AP Type, Ref Nbr and then the Line Nbr and update the box to ‘7’. It seems to only work on lines that are line nbr 1. But even single line AP Bills don’t always have line number 1. Might have single line AP Bill and the line nbr is 4. Doesn’t update in that case. Am I missing something obvious?
Best answer by vkumarView original