AP05S1 Accounts Payable A/P Open Item Report

Reports

A/P Open Item Report

Application Overview

The A/P Open Item Report contains detailed information about the invoices on a vendor's account and summarized vendor aged totals aged by invoice or due date.


The report shows each vendor's aged A/P balance and how much discount is still valid on that balance.  Optionally, it will also show detail for every invoice and payment.


The vendor's aged A/P balance is shown in four categories.  There are: current 30 days or less, 31‑60 days, 61‑90 days and over 90 days.


These figures can be based on the invoice date or on the due date of each invoice, at your option.  The aging can be done as of any date you wish.


You may also enter a voucher cutoff date.  Only vouchers with Distribution to G/L dates on or before this date will print.


If you choose not to include items past the aging date, you can get a view of what the A/P looked like as of the selected aging date.  Vouchers paid after this time will appear as unpaid, provided they have not been purged from the system.  This can be used to verify the balance in Accounts Payable against your A/P accounts in your General Ledger.


The last option is whether you wish to show fully paid vouchers.  By answering Y, you will not affect the aged totals of the vendor but the detail of all transactions that have not been purged will print.

Run Instructions

Select A/P Open Item Report from the pull down A/P Reports window.  The following screen will then be displayed:



 The following options are available:


  • Enter the data requested on the screen. The report will be printed at your option

To exit press the ESC or F10 key when the cursor is positioned for entry of the first field on the screen.

 

To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

Entry Field Descriptions

 

Name

Type and Description

1.   Starting Vendor No

6 alphanumeric characters.

 Enter the beginning of the range of vendors to be printed on the report.

 This field defaults to All.

2.   Ending Vendor No

6 alphanumeric characters.

Enter the end of the range of vendors to be printed on the report.

This field defaults to the starting vendor number to facilitate printing the report for a single vendor.

3.   Age Documents As Of

Enter a date in the standard date format.

Enter the date that aging is to be based on.

This field defaults to the system date.

4  .Based Upon Inv  Or  Due Date

1 alphanumeric character.

The valid values for this field are:

I = Documents are to be aged by their invoice dates.

D = Documents are to be aged by their due dates.

If I is entered, an invoice will be considered to have an age of 30 days if it was written 30 days ago.

If D is entered, an invoice will be considered to have an age of 30 days when it is 30 days overdue.

It is a matter of company policy which method you will use.

The default is D for due date.

5.   Include Items Past   Aging Date ?

Y or N.

This will include or exclude items dated after the aging date selected. If you wish to get a print‑out of the exact vendor balances as of the aging date, answer N. If you want the balances to reflect all open items regard­less of date, answer Y.

This field defaults to N.

6.   Show Detail

Y or N.

If Y is entered, then detail on every voucher will be printed on the report.

If N is entered, only summary data for each vendor will be printed.

The default is Y for yes, show detail.

7.   Show Fully Paid                      Vouchers ?

Y or N.

If Y is entered, then any fully paid vouchers, which have not yet been purged, will appear on the report if detail is selected.

If N is entered, then fully paid vouchers will not be shown on the report.

The default is N, do not show fully paid vouchers.

8.   Print Misc Vendors ?

Y or N.

This will allow or disallow printing of miscellaneous vendors on the report.

This field defaults to N.

9.   Voucher Cutoff Date

A date in the standard date format.

If a date is entered here, items with Distribution to G/L (voucher) dates after this date will be excluded.

This field defaults to the system date.

 



 




Accounts Payable

  1. AP0000 Accounts Payable Overview
  2. What Is The Difference Between Payment Date and Check Date during Print AP Check?
  3. How to Purge AP Distribution to GL Report
  4. DYO (Design Your Own) AP Laser Check Design
  5. How Can I Get a List of New Vendors Set Up Since a Certain Date?
  6. Why Doesn't the System Print the Bottom Stub on My Design-Your-Own AP Laser Check?
  7. System Period Control Does Not Apply to Recurring Transactions
  8. AP Check History Report That Includes Voided Check
  9. ERROR 035 on AP TEMP CHK File
  10. Feature - Voucher Criteria On Vendor Account Summary
  11. Feature - Voucher Reference on A/P Distribution to G/L Report
  12. Feature - A/P Simple Trx Processing
  13. AP01S4 Accounts Payable Vendor Audit Trail Report
  14. AP05S1 Accounts Payable A/P Open Item Report
  15. AP07S1 Accounts Payable Cash Requirements Report
  16. AP08S1 Accounts Payable Pre-Check Writing Report
  17. AP08S2 Accounts Payable Post A/P Checks
  18. AP08S4 Accounts Payable Void Checks After Posting
  19. AP10S1 Accounts Payable Check Reconciliation Report
  20. AP11S1 Accounts Payable Check History Report
  21. AP13S1 Accounts Payable Vendor History Report
  22. AP22S1 Accounts Payable Purge AP Open Item File
  23. AP0200 Accounts Payable Post AP Transactions
  24. AP0301 Accounts Payable Recurring Voucher Processing
  25. AP0302 Accounts Payable Post Recurring AP Transactions
  26. AP0400M Accounts Payable Vendor Account Inquiry
  27. AP0601 Accounts Payable Open Item Adjustment
  28. AP0800 Accounts Payable Payment Preparation
  29. AP0900 Accounts Payable AP Distribution to GL Report
  30. AP1001 Accounts Payable Check Reconciliation
  31. AP1200 Accounts Payable Vendor Analysis Report
  32. AP1400 Accounts Payable Job Distribution Report
  33. AP1500 Accounts Payable Job Analysis Report
  34. AP1600 Accounts Payable A/P Setup
  35. AP1701 Accounts Payable A/P Account File Maintenance
  36. AP1801 Accounts Payable FOB Code File Maintenance
  37. AP1901 Accounts Payable Ship Via Code File Maintenance
  38. AP2001 Accounts Payable Job Code File Maintenance
  39. AP2100 Accounts Payable Print/Create 1099 Forms
  40. AP2300 Accounts Payable Clear Vendor YTD Accumulators
  41. APDISSCN Accounts Payable Distribution History Report
  42. APINVIMS Accounts Payable Invoice Import Utility
  43. AP0100 Accounts Payable Vendor File Maintenance
  44. AP0202 Accounts Payable Transaction Processing
  45. FULLPAY Accounts Payable Reset Fully Paid Status
  46. Feature - Default Value For Create Variance Prompt
  47. Feature - Assign Next Manual Check Number in Computer Check Printing
  48. Feature - Added First Bank Export Format to Checks History Export
  49. I Forgot to Clear the AP Vendor Paid Accumulators at Year End
  50. What If I Do Not Run AP Manual Check Register?
  51. Feature - Add Ability to Include or Exclude by Vendor Type for AP Checks
  52. How to Find a Voided AP Check in Check History Report
  53. What Are the Impacts of Purging Accounts Payable Old Inactive Vendors?
  54. Feature - AP Check History CSV Creation
  55. AP Laser Check Layout
  56. How to Apply AP Credit to Voucher When Credit Is Greater Than Voucher Amount
  57. Feature - Add Amigo Support to Additional Transactional Files

Feedback and Knowledge Base