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
View original
Userlevel 5
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
Userlevel 7
+12
Hi
We have few options to correct Invoice and Cancel Invoice,
Userlevel 7
+8
if you want documents in open status either AR Trade or Retainage balance should have a non-zero value.
Hi
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
+18
Hello
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.
- Turn on AR migration mode in AR Preferences
- Revise your import to include Balance field with non-zero amounts representing open balance of invoices
- Include fields necessary to populate the Details tab of your invoices.
- The Balance amount will be equal to the total of the detail lines, less any partial payments made by your customer.
- Include only invoices that are not paid in full, in your import.
- 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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.