| Legler Systems Company | | | AP Reports | | | Contact Us | | | Help | | | Home | | |
The accounts payable reports can be requested at any time, sorted and printed on a standard line printer or a laser printer. Most accounts payable reports are 120 characters wide (landscape), while some audit control reports are 80 characters wide (portrait). Also, these standard accounts payable reports can be written to a temporary disk file for subsequent viewing in a separate report window by using procedure 92V or 92W.
A new 2018 option (Sys-Opt-44 in DB03) converts all uppercase letters to upper and lowercase letters when accounts payable reports are printed for easier reading.
The standard 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 required for Vendor Checks with stub and IRS 1099 Forms. Some 44 accounting and management reports printed by the Accounts Payable System from Legler Systems are identified below.
PROC S B Accounts Payable 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 accounts payable reports can be printed for single vendor or
all vendors.
5. Summary reports are printed when the 'Entry Correct' prompt = 'S'.
--------------------------------------------------------------------------
In addition to the standard accounts payable reports identified above,
custom accounts payable 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 procedures that print these accounts payable reports are described in the Accounts Payable Menu document.
Any questions about these Accounts Payable System reports, e-mail Bill Legler in the SF Bay Area, California or go to the Accounts Payable System main page.