Receivables HATB Report–SQL Script


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.

7 Replies to “Receivables HATB Report–SQL Script”

    1. It’s certainly worth a try. I haven’t had good luck with any of the HATBs that aren’t based on Microsoft’s Stored Proc code. The non-MS ones always seem to have limitations that show up later or for different companies.

      1. Does this product work when the Customers are set to Balance Forward instead of Open Item? Client cannot use Open Item. Thanks

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.