AP-I003D Accounts Payable Aged Unpaid Invoice Register Report

Report Name
Aged Unpaid Invoice Register

RMDS Report Group
MM122-8 AP DOCUMENT ENTRY

Frequency
Every production run

Records/Retention Requirements
ITEM 43026.  Aged Unpaid Invoice Register (AP-I003D).  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 months. Under each due date, the document amount that must be paid is listed.

Totals
Report totals include total for vendor, total due beyond next 3 months, total amount this vendor. The report also gives totals for paying entity, total due beyond the next 3 months, total amount this paying entity, and total invoice this paying entity.

Column Headings

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