Purge cleared transactions in Bank Reconciliation
Description
Cause
Resolution

Satisfy the following criteria to gain the option to purge the cleared transactions.

  1. Out of Balance shown in the Reconcile Bank window is $0.00.
  2. The Bank Reconciliation Register/Report shows an Out of Balance amount of $0.00. Follow the steps below to verify that the Out of Balance is indeed $0.00.

 NOTE: Check and see if the out of balance amounts shown in the Reconcile Bank window and on the Bank Reconciliation Register/Report match. If they don't match, see Reconcile Bank Matches But Bank Reconciliation Report Shows Out of Balance. 

  1. Open Bank Reconciliation, Main, Bank Reconciliation Register/Report.
  2. Deselect the Summarize Activity check box, and make the following selections.
    • Document Types to Print = All Types
    • Print Cleared Documents = All Documents
    • Bank Code Operand = Equal to
    • Bank Code Value = select the applicable bank code
    • Document Date Operand = All, Less than, or Range
       NOTE: When selecting Range, enter the ending date in the second Value field.  To purge through a specific date, leave the first field blank and use the second Value column 
  3. Click Print or Preview.
    •  NOTE: If you don't have security set up, print the report to a printer, file, or defer it 
  4. Close Preview.
  5. Do you want to remove cleared documents as of mm/dd/yy? will display only if the out-of-balance amount on the report is $0.00. This date is the Document Date used when printing the report. If you leave the Document Date blank, then the date displayed will be 12/31/2999.
  6. Click Yes to purge the cleared documents.
[BCB:155:Chat 100 US:ECB]

 

Steps to duplicate
Related Solutions