Sivakumar dropped a huge win on the Dynamics GP community last week with SQL code designed to replicate the Receivables Historical Aged Trial balance.
This is one of the most common requests I see and it’s nice to have a common starting point.
He give a number of versions that I’ve linked to here:
Receivables HATB With Aging By Due Date (using GL Posting Date)
Receivables HATB With Aging By Due Date (using Document Date)
Receivables HATB With Aging By Payment Terms (using Document Date)
Receivables HATB With Aging By Payment Terms (using GL Posting Date)