veeyeskay continues his SQL assault with two scripts, the AR Historical Aged Trial Balance by GL Posting Date and by Document Date.
These are tough reports to get the SQL right for so kudos to veeyeskay.
Receivables HATB Report–SQL Script
Payables & ReceivablesSQL & DataDevelopment & Integration
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.