Aged debt retrospective balance


I have two official JET templates Nav17 and Nav18 from way back that give me retrospective aged debt at any point in time. I'm trying to rebuild in a manual spreadsheet version of these myself but not getting the desired balances. In the two template reports from Jet, i cannot see the logic so think I'm missing Table Builder that was used to construct them. Has anyone ever attempted this exercise?

It seems a complex linking of Cust Ledger Entry and Detailed Cust Ledger Entry tables.

Thanks Nick



Please sign in to leave a comment.