NAV018 that comes with Jet Reports
I want to update the report so that it calculates the days based on the posting date rather than the due date. I need a report that shows days past posting rather than days past due.
I tried updating the field in the report to 4 Posting Date which works EXCEPT that the payments do not offset the original balance. For example, an original balance of $10,000 will show in 91+ however there is a $5,000 payment in 31-60. The $5,000 should offset the $10,000 to only show $5,000 due in the 91+ column.
Why is it doing this and how can I fix it?