Choose an option below to correct the report balance. Reconcile the void transactions Reconcile voided transactions using a Cleared date in the same month as the Void date. As best practice, when reconciling your bank statements, be sure to reconcile any checks voided in that statement period. Modify the formula As a temporary workaround, you can modify the Register Balance Adjusted for Future Period Voids total on the Bank Reconciliation report as follows: - In Report Designer, from the File menu, select Open Design.
- Browse to and select the CM Bank Reconciliation.rpt.
- From the Tools menu, select Formulas.
- Select TTL-Voided Amount.
- Click Change and enter the formula as follows:
- ASUM(Bank Account [CM Transaction], IF(Void Date [CM Transaction] > Statement Date [Prompt Field], Voided Amount [CM Transaction]))
- Click OK then Close.
- Select File, Save Design As, enter a modified name (for example: CM Bank Reconciliation_fix future voids.rpt)
- Using Reports Manager in Cash Management, you can either add this report or change the existing menu to use this modified report.
The future period voids total now balances with the General Ledger cash account total for the same period end date as the statement date. The Register Balance as of Statement Date total doesn't change.
[BCB:156:Chat 300 CRE US:ECB] |