R12: AR Reconciliation Report Shows Difference For Over Application Through Lockbox
(Doc ID 889003.1)
Last updated on JANUARY 05, 2021
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!