Legler Systems Company | AP Reports | Contact Us | Help | Home |

Accounts Payable System Reports:

The Accounts Payable System reports can be requested at any time, sorted and printed on a standard line printer or a laser printer. Most AP reports are 120 characters wide (landscape), while some control reports are 80 characters wide (portrait). Also, the AP reports can be written to a temporary disk file for subsequent viewing in a separate window by using procedure 92V or 92W.

The primary accounts payable reports are Vendor Invoice Report, Vendor Master List, Aged Payables Report, Payables Distribution Report, Vendor History Report, Cash Requirements Report and Accounts Payable Register. Each of these standard reports have several variations based on selection parameters entered online by the user. Preprinted forms are generally used for Vendor Checks with stub and IRS 1099 Forms. The 44 accounting and management reports printed by the Accounts Payable System from Legler Systems are listed below.

     PROC S  B   AP Report name and description
      --  -  -   ---------------------------------------------------------
  1.  03  Y  Y   Vendor Invoice Report by accounting period range.
  2.  03  Y  Y   Vendor Invoice Report by batch number range.
  3.  03  Y  Y   Vendor Invoice Report by location code (4).
  4.  03  Y  Y   Vendor Invoice Report by vendor number (4).
  5.  03  Y  Y   Vendor Invoice Report by pay code (4).
  6.  03  Y  N   Vendor Invoice Summary by pay code, account code and
                   batch number (5).
  7.  04  Y  Y   Vendor Master List by location code (4).
  8.  04  Y  Y   Vendor Master List of active or inactive vendors.
  9.  04  Y  Y   Vendor Master List by IRS 1099 code (4).
 10.  04  Y  Y   Vendor Master List by batch number (4).
 11.  04  Y  N   Vendor Master Summary by total vendor purchases (5).
 12.  05  Y  Y   Cash Requirements Report by payment date range.
 13.  05  Y  Y   Cash Requirements Report by batch number (4).
 14.  05  Y  Y   Cash Requirements Report by bank ID code (4).
 15.  05  Y  Y   Cash Requirements Report by vendor number (4).
 16.  05  Y  N   Cash Requirements Summary by payment date and
                   invoice date (5).
 17.  06  Y  N   Vendor Checks with stub by payment date range.
 18.  06  Y  N   Vendor Checks with stub by batch number (4).
 19.  06  Y  N   Vendor Checks with stub by bank ID code (4).
 20.  06  Y  N   Vendor Checks with stub by vendor number (4).
 21.  07  Y  Y   Accounts Payable Register by paid period range.
 22.  07  Y  Y   Accounts Payable Register by bank ID code (4).
 23.  07  Y  Y   Accounts Payable Register by vendor number (4).
 24.  07  Y  Y   Accounts Payable Register by location code (4).
 25.  07  Y  N   Accounts Payable Register Summary by accounting period
                   and batch number (5).
 26.  08  Y  Y   Payables Distribution Report by period range.
 27.  08  Y  Y   Payables Distribution Report by vendor number (4).
 28.  08  Y  Y   Payables Distribution Report by account code (4).
 29.  08  Y  Y   Payables Distribution Report by department number (4).
 30.  08  Y  N   Payables Distribution Summary by account code and
                   department number (5).
 31.  09  N  N   Payables Posting Report by location (4) - Preliminary.
 32.  09  N  N   Payables Posting Report by location (4) - Final.
 33.  11  N  N   APS Purge Control Report by period range - Counts only.
 34.  11  N  N   APS Purge Control Report by period range - File update.
 35.  12  N  N   Periodic Payments Report - Preliminary.
 36.  12  N  N   Periodic Payments Report - Final.
 37.  13  N  N   APS Batch Input Report - Preliminary.
 38.  13  N  N   APS Batch Input Report - Final.
 39.  14  Y  N   IRS 1099 Forms by check date range.
 40.  14  Y  N   IRS 1099 Forms by IRS 1099 code (4).
 41.  14  Y  N   Summary IRS 1096 Transmittal Report (5).
 42.  16  Y  Y   Vendor History Report for amounts paid.
 43.  16  Y  Y   Vendor History Report for number of invoices.
 44.  18  Y  Y   Aged Payables Report.

--------------------------------------------------------------------------
Notes:
 1.  Column "PROC" refers to the online procedure number on the AP menu.
 2.  Column "S" indicates sort option by vendor, ZIP, name initials or
       Alphasort when 'Y', otherwise 'N' means no record sorting.
 3.  Column "B" indicates both online processing and batch job processing
       is available when 'Y', otherwise 'N' means no batch processing,
       only online processing.
 4.  These AP reports can be printed for single code or all codes.
 5.  Summary reports are printed when the 'Entry Correct' prompt = 'S'.
--------------------------------------------------------------------------

In addition to the standard AP reports identified above, custom AP reports can be created, sorted and printed by procedure DB12 in the Database Control System, where the user specifies the data content and report format.

The online AP procedures that print these reports are described in the Accounts Payable Menu document.

More Information on the AP Software:

To receive sample Accounts Payable System reports, e-mail Bill Legler in the SF Bay Area, California or go to the Accounts Payable System main page.

Version 11.5 (2015). All rights reserved by Legler Systems Company.