R12: CE: Bank Statement Detail Report Not Reflecting Reconciled Amounts Correctly, Non Sufficient Funds (NSF) Reconciled Transaction Appears In The Report. (Doc ID 2744503.1)

Last updated on JANUARY 15, 2021

Applies to:

Symptoms

Bank Statement Detail report is still showing un-reconciled amounts even though the line is completely reconciled.

Non Sufficient Funds (NSF) Reconciled Transaction Appears In The Report.

Bank Statement Detail Report By Statement shows the following:

                                                                             Bank Statement Detail Report                                      Report Date 09-NOV-20 12:44
                                                                                    By Statement                                                     Page      1  of         1
Statement Number                 -
Statement Date                  03-NOV-20 - 03-NOV-20
Bank Branch Name                122xxx821                     Bank Name                         US Bank
Bank Account Number             153xxxxxx288                  Bank Account Name                 MID Operating USB #3288                    Bank Account Currency         USD



Bank Account Number     :            153xxxxxx288
Bank Account Name       :            MID Operating USB #3288
Bank Account Currency   :            USD

Statement Number          201103                Statement Date            03-NOV-20             Document Number


Reconciled Statement Lines

---------------------------Statement Line--------------          ----------------------------------------------------Transaction------------------------------------
                                                          Amount
Num - Type       Date                    Amount     Unreconciled Type      Status     Number                   Amount       Amount Cleared        Bank Charges         Bank Errors
----  ---------- ------------  ---------------- ---------------- --------- ---------- ---------- -------------------- -------------------- ------------------- -------------------
1     Receipt    03-NOV-20              607.88             0.00  Receipt   Cleared    LB1xxxx0_0              607.88               607.88                0.00                0.00
2     Receipt    03-NOV-20              264.00             0.00  Receipt   Cleared    LB1xxxx0_0              264.00               264.00                0.00                0.00
3     Receipt    03-NOV-20               63.64             0.00  Receipt   Cleared    LB1xxxx0_0               63.64                63.64                0.00                0.00
4     Receipt    03-NOV-20          517,683.26             0.00  Receipt   Cleared    WIRxxxx320          517,683.26           517,683.26                0.00                0.00
5     Misc Recei 03-NOV-20           29,760.58             0.00  Receipt   Cleared    CC1xxxx0_0           29,760.58            29,760.58                0.00                0.00
6     Misc Recei 03-NOV-20           20,518.46             0.00  Receipt   Cleared    CC1xxxx0_0           20,518.46            20,518.46                0.00                0.00
8     Non Suffic 03-NOV-20               33.18            66.36  Miscellan Cleared    RTNxxxx20_              (33.18)              (33.18)               0.00                0.00
                              ----------------- ----------------                                 -------------------- -------------------- ------------------- -------------------
Net Reconciled                      568,864.64           (66.36)                                          568,864.64           568,864.64                0.00                0.00
                                                                Report data is only for operating units per Responsibility and Preferences. 

Notice the highlighted line number 8, Transaction Number RTNxxxx20_ (As a sample)


And screen shot of the Bank Statement Reconciliation form shows the following:

Notice the Non Sufficient Funds Transaction Number RTNxxxx20_ displayed as Reconciled is the same transaction number listed in the report.

Steps to Reproduce

1. Log into the application using "Cash Management" responsibility.
2. Go to hte Bank Statements and Reconciliation form  (N)Bank Statements > Bank Statements And Reconciliation
3. Query / Find the Bank Statement to reconcile.
4. Find the Payment to reconcile.
5. Set the type to "Non Sufficient Funds" (NSF)
6. Reconcile.
7. Exit the form.
8. Go to the Standard Request Submission form (N)Other > Concurrent
9. Click on [Submit A New Request]
10. Select "Bank Statement Detail Report"
11. Use parameter "Break Level" = Statement
12. Set other parameters needed.
13. [Ok] and [Submit].
14. Review the Report output.

Changes

Cause

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