NAV018 Update Table with New Field

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? 


Please sign in to leave a comment.