AP22S1 Accounts Payable Purge AP Open Item File

Purge A/P Open Item File

Application Overview


Even when an invoice has been fully paid, the information on the A/P Open Item File pertaining to it remains on file until purged.  If you never purged the A/P Open Item File, the disk would eventually get very full, and some of the applications in the A/P package would start running very slowly, since they would need to sift through large volumes of data to operate.


The A/P Open Item File is always purged up to a particular cut‑off date.  Any invoices on file that have been fully paid on or before this date will be removed from the file.  A purge journal is printed that shows all of these removed invoices in detail, sorted by vendor.



Normally, purging clears out a file and the only access you have to purge information is the Purge Journal. The Elliott Purge A/P Open Item File Function gives you a new file, A/P History File; and when you purge the A/P Open Item File, the data is written to the A/P History File.  As a result, you can still maintain detailed A/P History without slowing the system down.


This is a useful feature in that it allows you to selectively maintain historical data by vendor.  Example:  You may just want to keep open items for 90 days and the rest in history.  Since the open items purged are written to the History File, you can then select vendors by range and cutoff date when you purge the A/P History File.  This will allow you to keep unlimited history for key vendors, a specified length for other vendors or a determined time period for all vendors.



Note:    When you do a vendor inquiry, you will have the option of viewing both the A/P Open Item File and the A/P History File.  At the present time, purged data from the Open Item File will not be available for reporting purposes, i.e., A/P Open Item Report, Vendor History Report, and the Check History Report.  However, you can access the A/P History File with a third-party report writer and create your own reports.


Run Instructions  


Accounts Payable à Processing à Purge A/P Open Item File à Purge à then select Open Item File or History Item File.



The A/P package always remembers the cut‑off date of the last purge.  Every time the purge is run, the cut‑off date will need to be at least one day later than the previous purge cut‑off date.


The purge also removes the data used to produce the Check History, Open Item, Vendor History, and Vendor Analysis Reports. 

Entry Field Descriptions



Type and Description

1. Thru What Date ?

A date in the standard date format.


Enter the cut‑off date for the purge.


Any invoices on file, which have been fully paid on or before this date will be removed from the A/P Open Item File.


Press the ESC or F10 key to exit without purging the A/P Open Item File

2. Starting Vendor No

6 alphanumeric characters.


Enter the starting vendor number that you want to purge, or press RETURN to default to All vendors.

3. Ending Vendor No

6 alphanumeric characters.


Enter the ending vendor number you want to purge. If RETURN was entered in the starting vendor no., this field will be skipped.

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
  58. Feature - F1 Key Next Manual Check Support in Single Screen Transaction Processing
  59. Values in APCHKHST (AP Check History) Status Column (APCHKHST_STATUS)
  60. How to Print Long AP Invoice Number on Checks

Feedback and Knowledge Base