Cash Management: Selecting Records to Reconcile in the Bank Statement Errors - APP-CE-53021: AR Period Not Open or Future (Doc ID 1483587.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Bank statements are loaded into Cash Management and are auto-reconciled.

Items that are not reconciled through the auto-reconciliation process are manually reconciled by going to Bank Statements->Review->Lines and querying for bank statement lines of a particular bank statement that are in an unreconciled status.The ‘Available’ button is used to find available transactions.

Search criteria is entered into the Find Transactions parameters and the Find button is used to find all available transactions matching the search criteria. Selecting to reconcile the bank statement line to a transaction that has a GL date in a prior period that has been closed produces the error ‘APP-CE-53021: AR period not open or future’.

For example:  A bank statement line from May 4th was being manually reconciled against a miscellaneous receipt that had a Receipt Date and GL Date of April 24th. When attempting to manually reconcile the misc receipt against the bank statement line, the error appears. Only by manually overriding the GL Date of the miscellaneous receipt can the bank statement line be successfully reconciled against the receipt.

During the auto-reconciliation process, when a bank statement line with the same May 4th dates is auto-reconciled against a receipt with the same April 24th Receipt Date and GL Date, the auto-reconciliation process is successful and the bank statement line is reconciled against the AR misc receipt.

When viewing the reconciliation of the bank statement line (clicking on the ‘Reconciled’ button on the Bank Statement lines screen), the GL date of the transaction is not the April 24th.  The date of the reconciliation is displayed instead (in this case, 30-MAY-2012).

The expectation is that the manual reconciliation of a transaction will behave in the same manner as the auto-reconciliation process and the GL date of the transaction would be updated to reflect the date of the reconciliation itself without manual intervention.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms