My Oracle Support Banner

AR Reconciliation Report Shows Difference in Applied/Unappled Receipts Section and Matches Difference Between Aging to GL (Doc ID 2659267.1)

Last updated on MAY 04, 2023

Applies to:

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

Symptoms

AR Reconciliation Report is unbalanced with offsetting difference in Applied Receipts (+ve) and Unapplied Receipts (-ve) section of the Report body.
There is also a matching (-ve) difference in the overall Report balance.

      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                                                                                 4,877.00
                                                                                                                 -----------------------
          Difference                                                                                                             123.00
                                                                                                                ==================
      Unapplied Receipts Register     (-)                                                    4,877.00                  4,877.00
          On Account                                        0.00
          Unapplied                                     4,877.00
          Claims Investigation                              0.00
          Prepayments                                       0.00
      Unapplied Receipts Journal Entries                                                                              5,000.00
                                                                                                                -----------------------
          Difference                                                                                                           -123.00
                                                                                                                ==================


                                                                         ------------------------
      Difference                                                                       -123.00
                                                                          ====================


When balancing the Subledger to the GL, for Receivable Account, the Aging - 7 Buckets by Account Report is out of balance with the GL by the same amount as above.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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