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.