AR and AP Aged Past Due reports based on doc date
Has anyone modified the standard Acumatica standard AP and AR Aged Past due reports to age the amounts based on Doc (i.e. invoice) date instead of due date?
If so I would very much like to get a copy.
I added the Invoice Doc date next to the Due Date. Just added the field ARInvoice.DocDate.
Also, we added a filter to exclude any documents that are due past the aging date so reconciliation activities are more accurate to the supporting ledgers.
We can change it in Myob Advanced on the statement cycle to age by Doc date and that flows to this report, so check if u have the same. Guess it means statement is aged the same
Attached is a generic inquiry though that you can use to make a report with