<< Click to Display Table of Contents >> Navigation:  Report Dashboard > Open Invoice List (Vendor Balances) - Report Writer > Description and Usage

The Open Invoice List may be printed by Transaction Date, Invoice Date, Due Date and Vendor Class. This report provides a listing of all outstanding invoices in vendor number sequence. This report is useful in helping to determine cash flow requirements for Accounts Payable and which vendors should be paid. A total will print for each vendor for Gross, Discount, No Pay and Net. Grand totals will print at the end of this report for total gross, total discount, total No Pays and total net. If this report is run by transaction for the last day of a month and includes no-pay invoices, it should have the same balance as the Accounts Payable Control account.

 

The Report Writer application allows the user to filter, sort and manipulate this report so that they may customize the data extracted out of the system. See the additional documentation on Report Writer for more information on these options.

 

 

Open Invoice List (Vendor Balances) - Report Writer

 

 

 

Listed below is an explanation of each column:

 

•Vendor #: Pulls the Vendor Number from Page 1 of the Vendor Master.

 

•Vendor Name: Pulls the Vendor Name from Page 1 of the Vendor Master.

 

•Class: Pulls the Vendor Class from Page 3 of the Vendor Master.

 

•Pay Code: Pulls the default Pay Code from Page 2 of the Vendor Master.

 

•Invoice #: Pulls from Invoice Entry.

 

•Comment: Pulls the AP Memo from Invoice Entry.

 

•Tran Dt: Pulls the Transaction Date, that affects General Ledger, from Invoice Entry.

 

•Inv Dt: Pulls the Invoice Date that was loaded in Invoice Entry.

 

•Due Dt: Pulls Due Date that was loaded in Invoice Entry.

 

•Check Dt: Pulls the Check Date of the check that paid the invoice.

 

•Pay: Pulls the Pay Code on the invoice. The possible options are blank for the invoice to be paid, N for No Pay, M for Multi-Pay, or P for Paid status.

 

•Gross: Pulls the total dollar amount of each invoice.

 

•Discount: Pulls the invoice discount amount from Invoice Entry.

 

•No-Pay: Pulls the Gross minus the discount for all invoices that are marked with a Pay Code of N.

 

•Net: Pulls the Gross minus the discount for all invoices that are not marked with a Pay Code of N.

 

•Vendor Totals: Pulls the gross, discount, no-pay, adjustment, and net totals per vendor.

 

•Grand Totals: Pull the gross, discount, no-pay, adjustment, and net totals for all vendors.