AP-I003T Accounts Payable Aged Unpaid Invoice Register Report Summary Total Report

Report Name
Aged Unpaid Invoice Register Report Summary Total

RMDS Report Group
MM122-8 AP DOCUMENT ENTRY

Frequency
Every production run

Records/Retention Requirements
ITEM 43027.  Aged Unpaid Invoice Register Summary Total (AP-I003T).  Material management production activity.

DISPOSITION INSTRUCTIONS:  Destroy in office after 30 days.

Use
This report can be used as part of the daily balancing procedures. It provides the current ending liability balance for the day and identifies future cash requirements. It can also be used to obtain a total view of cash outstanding for the organization.

Content
The system excludes documents with any of the following status:

• Model
• Incomplete
• Fully paid
• Out-of-balance
• Matching Exception
• Pending Multiple Payments

The report shows activity by final payment due date for up to four due dates. Under each due date, the document amount that must be paid is listed.

Totals
Report totals include total paying entity, total due beyond the 3 months, total amount this paying entity, total invoices for paying entity, total for advances, total for expenses, total for vendors, total paying entity. Totals for the report include total amount per period, total due beyond 3 months, total unpaid amount, total invoices, total for advances, total for expenses, total for vendors, and grand total.

Column Headings

• VENDOR NUMBER
• SHORT NAME
• INVOICE NUMBER
• PAY NBR
• PRT PYT
• INV TYP
• INVOICE DATE
• FINAL PAYMENT DATE
• FINAL AMOUNT DUE (for next 3 months)