Answer
How can I resolve the below issue?
Best answer by Laura03
Hello,
Releasing your document with a SQL script may work.
My advice is to copy the tenant to a test tenant, create and run your SQL query in the test copy first. Check very carefully in the test tenant to be sure no other documents were affected by the script, you are able to close out all existing documents for the customer, and you are able to correctly generate the next billing, proforma, invoice cycle before using SQL to update your live tenant.
Laura
+19Hello
Can you show the status of Proforma Invoice 002488 as it appears in Pro Forma Invoices screen, with Financial tab, please?
Can you tell us more details of the problem? The Proforma is listed many times with several different AR Credit Memos. And it may be helpful for us to see all related/connected AR documents with their status, such as from the AR Invoices & Credits preview list, filtered for the project.
Thank you.
Laura
~ Laura Barber, WM Synergy
Hello
Can you show the status of Proforma Invoice 002488 as it appears in Pro Forma Invoices screen, with Financial tab, please?
Can you tell us more details of the problem? The Proforma is listed many times with several different AR Credit Memos. And it may be helpful for us to see all related/connected AR documents with their status, such as from the AR Invoices & Credits preview list, filtered for the project.
Thank you.
Laura
Hey
hey
+19Oh, I see. Where did DM 043246 go? Can you Reverse application to separate Credit memo 039287 from Credit memo 039287?
If not, the next step is to raise a support ticket with your VAR and/or Acumatica.
Laura
~ Laura Barber, WM Synergy
Oh, I see. Where did DM 043246 go? Can you Reverse application to separate Credit memo 039287 from Credit memo 039287?
If not, the next step is to raise a support ticket with your VAR and/or Acumatica.
Laura
Hey
All the invoices listed here are CLOSED. Now when I try to Reverse and Apply to memo, it throws the same error:
+19Hello,
Releasing your document with a SQL script may work.
My advice is to copy the tenant to a test tenant, create and run your SQL query in the test copy first. Check very carefully in the test tenant to be sure no other documents were affected by the script, you are able to close out all existing documents for the customer, and you are able to correctly generate the next billing, proforma, invoice cycle before using SQL to update your live tenant.
Laura
~ Laura Barber, WM Synergy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.