Skip to main content
Solved

AP Import Scenario - Document out Of Balance


Forum|alt.badge.img

Good day,

I know it is probably something simple.  I am reusing the ACU AP import scenarios.  The error is the Document Out of Balance.  It is not.  I have used this before but this issue is new to me.  Attached is the XML.  Is there a new Balance Check box that needs to be unchecked?  The more try things the more confused I get.

Any suggestions.  Thank you.  

@grillevan 

Best answer by Laura02

Hi Evan,

I was able to import your sample. In the Import scenario I de-activated 2 lines: Hold action, and Remove Hold action.

In the Excel, I made the two changes recommended in my post above, plus changed your vendor ids to be a Vendor ID that is in my test tenant.

Laura

View original
Did this topic help you find an answer to your question?

5 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • August 26, 2024

Hello Evan,

I suggest the following changes:

  1. Bill lines should not post to the AP Control Account: consider an Expense account in place of account 2000 in Column AC.
  2.  Do the Reference Numbers in Column B of your Excel match AP Bill Reference numbers that already exist in your tenant?  Add 9 in front of the reference numbers in the Excel, to ensure they are unique so that Acumatica won’t try to add your Excel lines to any existing AP Bills. If your AP Bill Numbers are automatic, Acumatica will assign the next numbers in the sequence upon import, using column B of the spreadsheet to identify where one Bill ends and the next begins.

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 20 replies
  • August 26, 2024

Hi @Laura02 

I made the changes.  Still getting the same error.  It must be the scenario.

Thank you.

@grillevan 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • August 27, 2024

Hi Evan,

I was able to import your sample. In the Import scenario I de-activated 2 lines: Hold action, and Remove Hold action.

In the Excel, I made the two changes recommended in my post above, plus changed your vendor ids to be a Vendor ID that is in my test tenant.

Laura


meganfriesen37
Captain II
Forum|alt.badge.img+11

Do you have lines that are taxable that are automatically calculating?  I have encountered that as an error when importing AP documents since there are sometimes manual adjustments that the clerks have made to match up with the printed documents when tax is off by a few cents and then the total of the document is out.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 20 replies
  • August 27, 2024

@Laura02 

Thank you.  That worked.

@grillevan 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings