Printing Standard Accounts Payable Reports

The A/P G/L Summary Report shows accounts payable amounts by reverse G/L number. This lets you audit A/P entries that were made in general ledger. This report can be limited by a range of information, including the following: batch numbers, business periods, general ledger control numbers, general ledger reverse number, invoice dates, and vendor numbers.

 

You can specify whether this report is based on AP-BATCH, AP-MASTER, or JOUR-AP files.

 

Note: We recommend that you keep no more than one year of posting information in your JOUR-AP file. To do this, purge by business period and assign the file a unique name such as AP-03 or AP-03.

  1. In the (QR) Accounts Payable Reports screen, select the [Z] Print A/P G/L Summary Report code.

  2. Use the fields in the Accounts Payable G/L Summary Report screen to limit what prints on the report. For example, you can limit this report according to business period, location, and vendor number. To not set limits, press Enter. Go to Step 3. If you do not limit the report, it includes every account in the specified file.

  3. Use the Batch From and To fields to limit by batch number. To skip this limit, press Tab. To limit the report by batch number, enter the beginning batch number in the Batch From field. In the To field, enter the ending batch number.

  4. Use the Period From and To fields to limit by business period. To skip this limit, press Tab. To limit the report by business period, enter the beginning date in the Period From field. In the To field, enter the ending date.

  5. Use the G/L Control From and To fields to limit by G/L control number. To skip this limit, press Tab. To limit the report by control number, enter the beginning number in the G/L Control From field. In the To field, enter the last control number to include.

  6. Use the G/L Reverse From and To fields to limit by G/L reverse number. To skip this limit, press Tab. To limit the report, enter the beginning number in the G/L Reverse From field. In the To field, enter the last number to include.

  7. Use the Invoice Date From and To fields to limit the report by invoice date. To skip this limit, press Tab. To limit the report by invoice date, enter the beginning date in the Invoice Date From field. In the To field, enter the ending date.

  8. Use the Vendor From and To fields to limit by vendor number. To skip this limit, press Tab. To limit by vendor number, enter the beginning vendor number in the Vendor From field. In the To field, enter the ending vendor number.

  1. Use the Printer field to specify the printer to use.

    Note    : You must use wide paper or set your printer for compressed print (17 characters per inch) to print this report. To set your printer for compressed print, change the print setting manually. Refer to your printer manual for instructions.

  2. Use the Copies field to specify the number of copies to print.

  3. Use the File field to specify the file to use. Press Tab to accept the default file, AP-BATCH, or enter another file name (AP-MASTER or JOUR-AP). Press Tab.

  4. In the Vol field, enter the volume serial that contains the file you specified. If you specified the AP-MASTER file in the File field, go to Step 7.

    If you specified AP-BATCH or JOUR-AP in the File field, go to Step 8.

  5. At the Include Completed Invoices prompt, type Y to include the invoices. Type N to exclude them.

  6. The report prints.