AP-I0006 Invoice Analysis Register by General Ledger Effective Date Report

Report Name
Invoice Analysis Register by General Ledger Effective Date

RMDS Report Group
MM125-1 BLANKET ORDER SUM

Frequency
Monthly

Records/Retention Requirements
ITEM 43031.  Invoice Analysis Register by General Ledger Effective Date (AP-I0006).  Material management production activity.

DISPOSITION INSTRUCTIONS:  Destroy in office after 30 days.

Use
Use this report to respond to vendor or employee inquiries about the status of an invoice or payment.

Content
This report contains a summary of amounts paid and unpaid to a particular vendor or employee as of the specified general ledger effective date. The report lists the vendor or employee and all associated documents with the individual document, paid, and net due amounts.

The system selects documents with any of the following status: balanced, hold, provisional, partially paid, one-time hold, open, canceled, paid, matching exception.

Totals
The report gives totals by vendor number, paying entity, and report total for invoice amount, amount paid, net amount due, unpaid invoices, and total activity.

Column Headings

• INVOICE NUMBER/PAYMENT REF NBR
• PAY NBR
• PRTL PYMT
• INVOICE/PAYMENT DATE
• GL EFFECTIVE/CLEARANCE DATE
• INVC TYPE
• INVOICE/PAYMENT STATUS
• INVOICE AMOUNT
• AMOUNT PAID
• NET AMOUNT DUE
• VENDOR NUMBER
• SHORT NAME
• VENDOR TYPE