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:

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

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