I am attempting to create a HATB ( Accounts Payable Historical Aged Trial Balance)
With the following columns:
Payment Type (Check, ACH, etc)
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.