R12: AR Reconciliation Report Shows Difference For Over Application Through Lockbox
Last updated on JUNE 29, 2017
Applies to:Oracle Receivables - Version 12.0.1 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
AR Reconciliation Report
AR reconciliation is showing differences the issue can be reproduced with the following steps:
Below is the scenario to replicate the issue:
Setup: Allow Overapplication = Yes
Step1 : Create a transaction with below details
amount = $100
transaction date = 01-Jun-09
GL Date = 01-JUN-09
Step2 : Make an Adjustment type "Invoice", GL Date = 02-Jun-09 which will do adjust for entire invoice amount $100
Now if record is queried in account details form the GL Date Closed will be 02-Jun-09.
Step3 : Run Lockbox for this transaction for amount of $100 (GL Date for receipt 18-Jun-09) which will make invoice over applied and when you query once again in account details screen the details will be:
GL date Closed in the form is blank
Status = open
Query the record from database GL Date Closed = 02-Jun-09
Status = 'OP'
Actual Date Closed = 02-Jun-09
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