I am attempting to create a HATB ( Accounts Payable Historical Aged Trial Balance)
With the following columns:
Company
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
Mark