AR Aging includes Cancelled Invoices

Evan,

Can you post a screenshot of the invoice you are saying is “Cancelled” as well as a screenshot of the AR report where it appears as well as the screen id of the report?

 

-John

Hello @EvanG ,

How did your invoice come to be “Cancelled” status?  Acumatica AR Invoice statuses include the following choices:

• On Hold
• Pending Print
• Pending Email
• Credit Hold
• Balanced
• Scheduled
• Voided
• Pending Approval
• Rejected
• Open Reserved
• Closed

Is it possible the Custom Status “Cancelled” is part of a customization package such as TrueCommerce ?

I wonder if a Cancelled invoice in your case is like a regular Closed Invoice - I presume the Invoice Balance is $0?  If so, when you look at the Applications tab of the AR invoice, what document paid it?

What is the period of the Invoices in question, what is the period of the paying document (Credit memo)? For what period was the report printed?

For example, suppose an invoice from June 2022 was cancelled/written off in March 2023.  If I print the Aging for December 2022, the June 2022 invoice that looks cancelled today actually SHOULD show open on the Aging I printed for December 2022.  Does this make sense? 

If we have not answered your question, please add examples of your invoice and your report, as previous poster requested.  Thank you!

Laura

@John Masi   Hi John.

Any suggestion?  Accounting gets annoyed that it shows on the Aging.  Somehow we believe that it was cancelled and CR was post it should just go away.  Mistakes are hard to see.

Thank you

@EvanG as @Laura02 pointed out it is not the Acumatica Standard engine that causes this issue. It is a customization or ISV that causes the issue and requires retuning to fix the issue.

As a workaround, you can open the report in Report Designer and filter out documents with Cancelled Status and save it on the server. This will fix this issue but there could be other areas that need to be fixed

I found more information in this forum:  Sales Orders module CAN correct/cancel an invoice and the Cancelled status is Valid -- it’s just missing from the Help. I relied on the Help to produce a list of invoice status options.

We can vote for improvements to the Cancel process; link below. 

https://community.acumatica.com/ideas/make-invoice-cancellation-a-real-cancellation-which-is-to-offset-the-ar-and-add-inventory-back-3947

Invoices are not really “Cancelled” with the Correction process after they have been posted in Acumatica, even if their status says Cancelled.  They are Adjusted off the books with Credit Memos. Here is a screen shot of an Invoice that has been written off the books with a Credit Memo :

I recommend AR Aged Period Sensitive report instead of AR Aging because it will tie to the GL for every month.  When printing AR Aged Period Sensitive for a prior period,  the report includes documents that were open “As Of” the period we are printing, even if they were adjusted off the Aging several months later with a Credit Memo and now show status “cancelled”.

I understand why Reza memntioned filtering out cancelled status invoices, but without the cancelled invoices in the total, the report won’t be correct. The accountants and auditors will be looking for a report that correctly matches the GL.

Evan,

Interesting enough, I did find an Invoice Status of Cancelled (L) in 2023R1.

 

The easiest solution would be to exclude Invoices with the status “L” from the report, however please test as I do not have any invoices in that status on my local instance to check.

@EvanG can you confirm the cancelled invoice has a released credit memo attached to it? I just tested this out on my local instance (22.211.0034) and i ran the AR aging before i cancelled an invoice: 

once i cancel and release the credit memo, the AR aging is updated: 

i would ask accounting to double check the CM is released and not just in the balanced state!

Thanks,

Iqra