4Reports and Inquiry
Option 7Unpaid Invoices Report
Use this function to print a report of Unpaid Invoices for each vendor. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Unpaid Invoices information, this step provides you with a default sequencing of data records by Vendor, Apply To and Invoice Type, with the option to change modifiable parameters at run time. Selection of data records is provided by Vendor, Apply To, Invoice Type, Invoice Due Date, Pay Status and Balance Due, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all lists of master file information.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Unpaid Invoices Report, this step formats the Unpaid Invoices information. The following data items are shown: Invoice Amount, Calculated Discount, Payment?, Pay Status Description, Invoice date, Take Discount, Pay date, Invoice Due Date, Discount Due Date, Dr Liability, PO Number, Take Retention, Balance Due, Liability Account and Description. As appropriate, group headings appear whenever a change occurs in Vendor Apply To or Invoice Type.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 10:00 LGG Page: 1
Unpaid Invoices Report
=================================================================================================================================
00000010 Miscellaneous Supplier
Apply To 221 New lobby plants
Northwest Interiors
Invoice
Invoice Amount 305.00 Calculated Discount .00 Payment Status N Normal
Invoice Date 08/14/90 Take Discount .00 Pay Date 08/31/90
Invoice Due Date 08/31/90 Discount Due Date Dr Liability 305.00
PO Number Take Retention .00 Balance 305.00
Account 2010001001 Accounts Payable, Sales
-----------------------------------------------------------------------------------------------------------------------
Apply To 89071001 CUSTOMER REFUNDS
Master Sellers Company
Invoice
Invoice Amount 100.00 Calculated Discount .00 Payment Status N Normal
Invoice Date 08/31/89 Take Discount .00 Pay Date 08/31/89
Invoice Due Date 08/31/89 Discount Due Date 08/31/89 Dr Liability 100.00
PO Number Take Retention .00 Balance 100.00
Account 2010001001 Accounts Payable, Sales
-----------------------------------------------------------------------------------------------------------------------
Apply To DEP6/89 deposit on convention room
Westin Hotel
Invoice
Invoice Amount 1012.25 Calculated Discount .00 Payment Status N Normal
Invoice Date 06/20/89 Take Discount .00 Pay Date 06/20/89
Invoice Due Date 06/20/89 Discount Due Date Dr Liability 1200.00-
PO Number DEP6/89 Take Retention .00 Balance 1200.00-
Account 1061001000 Prepaids & Deposits
-----------------------------------------------------------------------------------------------------------------------
Apply To L9980 Office landscaping
Evergreen Landscaping
Invoice
Invoice Amount 620.00 Calculated Discount .00 Payment Status N Normal
Invoice Date 08/14/89 Take Discount .00 Pay Date 08/31/89
Invoice Due Date 08/31/89 Discount Due Date Dr Liability 620.00
PO Number Take Retention .00 Balance 620.00
Account 2010001001 Accounts Payable, Sales
-----------------------------------------------------------------------------------------------------------------------
Apply To P09844 Yellow page ad
Neighborhood Directory
Invoice
Invoice Amount 250.00 Calculated Discount .00 Payment Status N Normal
Invoice Date 08/14/89 Take Discount .00 Pay Date 08/31/89
Invoice Due Date 08/31/89 Discount Due Date Dr Liability 250.00
PO Number Take Retention .00 Balance 250.00