Skip to main content
Solved

Import Scenario to Match existing SO Credit Memos to Existing SO Invoices


Forum|alt.badge.img

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

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

View original

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 24, 2024

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


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 25, 2024

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


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