ARPRGSCN Accounts Receivable Purge Closed Open Items

Purge Closed Open Items

Application Overview


Periodically, you will want to remove from the A/R Open Item File all transactions that have been fully paid off. Otherwise, the file could become very large over a period of time. This application will accom­plish this function for you.


When you purge the A/R Open Item File, the system writes the purge information to the History Item File, which holds all your purged records.  Inquires, reports, and a purge function are available for this file as well.


Since this application does remove detail from the A/R Open Item File, you should not run it until you have printed statements for the period. Otherwise, much of the activity, which has occurred during the period, may not appear on the statements.


You may select which customer's accounts will be purged in the same way you selected which customers were to have statements printed.  You can enter up to five Statement Frequency codes, and a starting and ending range of customers.  Only those customers who have a Statement Fre­quency code matching one of the codes you entered and who fall within the range specified will have their account purged.


You will also enter a cut‑off date for the purge.  Any items in a cust­omer's account dated after this cut‑off date will not be considered at all during the purge.  They will remain on file.  For example, let us assume you want to purge the file through the end of June, even though you are currently mid‑way through July.  The program will not look at payments, which have occurred toward a customer's open items if they occurred after the end of June, even if they fully paid off one or more open items.  This is done in this fashion so that the detail of cust­omer payments during the month of July will remain intact for the next printing of statements.


Only customers that have transactions purged will be printed in the purge journal.


Purged Data


Any data purged is moved to the A/R History Item File and is available for viewing and reporting.  This file can also be purged by a cut-off date and any purging of this file removes that data from you system.


How the Purge Works


When an Open Item customer's account is purged, the program looks at each invoice to determine if its current balance is zero, meaning that it has been fully paid.  If its balance is zero, then the invoice and all payments, credit memos and debit memos, which apply to the invoice, will be deleted from the file.  Any open items whose current balance owing is not zero will be left on file.


When a Balance Forward customer's account is purged, the program totals up all credits on the customer’s account, and apply those credits to the oldest debits on the account.  Every invoice, or other debit, which can be paid off by the total credit amount is deleted from the file. All open items, which could not be fully paid off, remain on file.



Run Instructions


A/R Processing Menu à Purge Closed Open Items à Purge


 The following screen will displayed where you can select the Open Item File or History Item File




Purge Closed Open Items Entry Screen




 The following option is available:

  • Allows you to remove transactions, which have been fully paid off

This application does remove detail from the A/R Open Item File and should not be run until after statements for the period have been printed.


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



Type and Description

 1.  Thru What Date ?

A date in the standard date format.

No documents past this date will be considered during the purge.  This field defaults to the system date.

2.  Stmnt Freqs to Purge

Five entries of 1 alphanumeric character.

Only those customers having a statement frequency matching one of the frequencies you enter here, and whose customer number also falls within the range you will enter below, will have their account purged.  If you press RETURN for the entry of the first entry of a statement frequency, it will default to All statement frequencies.

These are the valid values which can be entered for these fields:

D              =              Discretionary

W             =              Weekly

S              =              Semi‑monthly

M             =              Monthly

Q             =              Quarterly

N              =              No Statement

3.  Starting Customer No

6 alphanumeric characters.

Enter the number of the starting customer to be purged.  If you press RETURN for this entry, it will default to All customers.

4.  Ending Customer No

6 alphanumeric characters.

Enter the number of the ending customer to be purged.  If you press RETURN for this entry, it will default to the starting customer entry.  In other words, only the customer specified by the starting customer number will be purged.



Purge Closed Open Items Screen:







Purge Closed History Items Screen

























Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Refund customer open credit / overpaid
  72. Feature - Add Acct Name to ACH Account Detail Screen
  73. Feature - ACH Add and Change Event
  74. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  75. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  76. Feature - Age Customer Accounts When Cash Receipts Are Posted
  77. Feature - Validate Collector Against Salesman File
  78. NSCTLMN2 Accounts Receivable Global Setup 1
  79. NSCTLMN2 Accounts Receivable Global Setup 2
  80. NSCTLMN2 Accounts Receivable Global Setup 3
  81. NSCTLMN2 Accounts Payable Global Setup 1
  82. NSCTLMN2 Accounts Payable Global Setup 2
  83. NSCTLMN2 Accounts Payable Global Setup 3
  84. NSCTLMN2 Accounts Payable Global Setup 4
  85. NSCTLMN2 Accounts Payable Global Setup 5
  86. NSCTLMN2 Accounts Payable Global Setup 6
  87. NSCTLMN2 Accounting Global Setup: Index
  88. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  89. What Does the Asterisk Mean in A/R Account Inquiry?
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd
  93. Change - Sync Order Addresses in Customer Change Program
  94. Feature - Append Re-Apply Cr/Dr Memos Info To Log File

Feedback and Knowledge Base