daily update the field ‘Aging as of Historical’ with TODAY(s) date. Basically this would ensure that the field ‘Aging as of Historical’ is updated every day with today’s date.

 

This script only needs to run for:

 

Transactions line items with to GLA Name = “1200 – Accounts Receivable Control’ or ‘2000 – Accounts Payable Control’. 

 

AND

Transaction line item field ‘Home Outstanding Value’ is not equal to 0 or NULL