Hi All,
I am trying to figure out what the formula would be in order for me to track invoice balance for the last 30 /60/90/over 90 days. I have modify a report base on AR.63.30.00 AR Balance by Customer MC.
Currently the formula $StCycCurrTot / =$StCycAgeTot00 / =$StCycAgeTot01 / $StCycAgeTot02 / $StCycAgeTot03 are pulling a sum base on the month and not by how many days the invoice is open.
If you look at the above example, you can calculate that Over 30 Days don’t add up properly as Today is April 18, and the transactions that should have been added is between Mar 7 to Mar 15. However if you add all the March transaction together, the value $6863.91 is correct.
The goal is for this report to show balance based on the number of days and not based on the month.
Thank you.
Calvin Law