I faced a scenario where i had to reverse over 4000 invoices using SO Credit Note because there was stock involved. These invoiced had been posted without VAT and Tax authorities requested that they be redone. I managed to use import scenarios to reverse and repost the invoices.
I am now facing challenge with constructing an import scenario to apply the invoices to the credit memos.
Any help welcome
Best answer by Laura02
View original
+18
Hello,
I recommend exporting the list of Invoices and the list of related credit memos, side-by-side in Excel. Sort the invoices by customer id, date, amount. Sort the credits by customer id, date, amount. Your goal is to line up each invoice with its related credit memo on the same line.
All invoices and memos have been released to AR, correct? If not, please release and post.
Then Import to AR Payments and Applications screen, with the Credit Memos at the top of the screen and the related invoices on the ‘Documents to Apply’ tab. Importing application of Credit Memos to Invoices is just like importing application of Payments to Invoices.
Laura
+18
Hello,
Acumatica provides an Import Scenario for importing AR Payments with Applications. Please compare to Acumatica’s File attachment, to see how to organize your invoice/credit memo list in Excel. Then use Acumatica’s Import scenario to import your credit memo applications.
Laura
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
