My Question is actually concerning ACCOUNTS RECEIVABLE.
All of the PeopleSoft standard ATB reports (Aged Trial Balances) and even a few of the customized ATB's created here at Right Management are all by Invoice Date. Meaning that, if an invoice was billed on Tuesday, June 5th, as of today the invoice would be 49 days outstanding. It would reside in the OVER 30 bucket on the ATB. However, if that client had a 60 or 90 day PAYMENT TERM, in reality that particular item should reside in the CURRENT column.
How can i keep my ATB based off of the INVOICE DATE, yet when i run it, if any specific clients have anything other than a NET30 payment term, those items would reside in the current column if they are within their payment term.
0