APPX Software Library

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.

  1. 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.
  2. Step 2This disposition type is used for all lists of master file information.
  3. Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. 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