Client Requirement:
The report we require is a Payables Historical Aged Trial Balance (HATB) report. Please note the following requirements for the report:
1. The structure of the report and the required fields are as per the attached sample report. Please let me know if any of the fields is not clear to you.
2. Report required as an SQL script
3. Ability to age by the transactions by GL Posting Date or the Document Date
4. Report should cater for all Payables aging buckets defined in the system
5. The criteria to be entered when running the report would be:
§ Date Field to be used to age the transactions (GL Posting Date or Document Date)
§ Age As Of Date (the date on which the transactions are aged)
No comments:
Post a Comment
Your Comments