Mark Nelson 4/21/2016 3:44:12 PM

Trying to create a HATB payables report

I am attempting to create a HATB ( Accounts Payable Historical Aged Trial Balance)

With the following columns:


Vendor Number

Vendor Name

Invoice Date

Payment Terms

Payment Type (Check, ACH, etc)

Amount Due

A column for the different aging buckets (Current Period, 31-60 days, 61-90 days, 91 and Over)

I have SQL and Anyview at my disposal, would anyone mind helping me out with this, at least with the proper tables.


Thank you




Version: GP 2010
Section: Dynamics GP, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables