Import open balances in AR

  • 4 July 2023
  • 1 reply

Userlevel 2

I need help importing overdue AR balances into the system. I have the template to use but for some reason i cannot get the balance to link to the details total without adding any inventory.

we are switching from Quickbooks to the System and the export from QB only gave me the balance and not the line is there a better way to import this information?


Best answer by Laura02 4 July 2023, 02:41

View original

1 reply

Badge +18

Hello @garcimig09 ,

When migrating open AR, with Migration Mode turned on in AR Preferences, you want to import the Line Total to the Amount field and the open/unpaid balance of the invoice in the Balance field:

Sometimes the Balance matches the Amount and sometimes the Balance is less than the amount.

If this doesn’t answer your question, please provide:

  • What messages appear when you try to import? 
  • Screen shot or XML of your Import Scenario.

Thank you,



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved