Skip to main content
Solved

AR Import


Forum|alt.badge.img

We imported AR amounts in migration mode but with no balances. and it’s not showing in our aging schedules. The invoices show as closed. How do we correct?

 

Best answer by Laura02

Hello @enriquey ,

Here is a summary of the steps required to correct the imported invoices. If your system is live, perform these steps when users are out, suchas during evening hours or on the weekend.

  1. Turn on AR migration mode in AR Preferences
  2. Revise your import to include Balance field with non-zero amounts representing open balance of invoices
  3. Include fields necessary to populate the Details tab of your invoices.
  4. The Balance amount will be equal to the total of the detail lines, less any partial payments made by your customer.
  5. Include only invoices that are not paid in full, in your import.
  6. There is no need to erase or reverse the invoices that were imported on the first try, as they do not add to the customer balance and did not post to GL. You may like to add a note to the first set of invoices to identify them as mistakes.

Good luck.

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

xkylewrightx
Semi-Pro I
Forum|alt.badge.img

From the screenshot it looks like this invoice is closed; is there a document (in the applications tab?) that is zeroing out this invoice balance?

Also make sure you are blocking out any sensitive info on screenshots

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12

Hi @enriquey 

We have few options to correct Invoice and Cancel Invoice,

 


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • March 22, 2023

@enriquey the closed document means a document with no outstanding balance. As yourself mentioned, you are importing documents with zero outstanding balance meaning document has no open balance and should be closed and this is what platform does when document is released.

if you want documents in open status either AR Trade or Retainage balance should have a non-zero value. 


Forum|alt.badge.img+11
  • Acumatica Support Team
  • March 22, 2023

Hi @enriquey 

If the documents had an open balance, you may have to redo import with Balance field reflecting correct open balance. Here is a past thread which has some useful tips on importing AR documents in migration mode with balance. 

Hope this helps,

Regards

 

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 23, 2023

Hello @enriquey ,

Here is a summary of the steps required to correct the imported invoices. If your system is live, perform these steps when users are out, suchas during evening hours or on the weekend.

  1. Turn on AR migration mode in AR Preferences
  2. Revise your import to include Balance field with non-zero amounts representing open balance of invoices
  3. Include fields necessary to populate the Details tab of your invoices.
  4. The Balance amount will be equal to the total of the detail lines, less any partial payments made by your customer.
  5. Include only invoices that are not paid in full, in your import.
  6. There is no need to erase or reverse the invoices that were imported on the first try, as they do not add to the customer balance and did not post to GL. You may like to add a note to the first set of invoices to identify them as mistakes.

Good luck.


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