26 July 2011

Payables HATB With Aging Interesting Findings & Knowledge Sharing

Sivakumar follows up his AR HATB series with a series of SQL code to generate Payables Historical Aged Trial Balance reports. We’ve had some other folks who generated similar code but I love having options.

Payables HATB With Aging By Due Date (using GL Posting Date)

Payables HATB With Aging By Due Date (using Document Date)

Payables HATB With Aging By Payment Terms (using GL Posting Date)

Payables HATB With Aging By Payment Terms (using Document Date)