Receivables Reconciliation and AR to GL Reconciliation Issue Created Due to Duplicate Journals from Receivable Accounting Entries (Doc ID 3025510.1)

Last updated on DECEMBER 10, 2024

Applies to:

Symptoms

Receivables Reconciliation and AR to GL Reconciliation Issue Created Due to Duplicate Journals from Receivable Accounting entries.

(A) From Concurrent Manager using Receivables Manager Responsibility, Navigate View > Requests and submit request:

AR Reconciliation Report
parameters:
GL Date From = [enter period start date]
GL Date To = [enter period end date]

When reviewing the AR Reconciliation Report output, the ending section balances and there is no overall report difference,
but for Applied Receipts section it is reporting difference similar to example below:

Applied Receipts Register (-)                         5,000.00               5,000.00
Amount Applied                           5,000.00
Earned Discounts                               0.00
Unearned Discounts                          0.00
Applied Receipts Journal Entries                                              10,000.00
                                                                                              ----------------------
Difference                                                                                 -5,000.00

(B) From Concurrent Manager using General Ledger Responsibility, Navigate View > Requests and submit request:

Account Analysis (either 132 or 180 Char)
parameters:
Type = Source Item
Balance Type = A
Order By = Source

When reviewing the GL Account Analysis Report output shows duplicate journal similar to example below:

Source Category Batch Name Debits (USD)
Receivable Receipts Receivables A 12345 10,000.00

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.