EAP:Incorrect Closing Balance Calculation Causing Error On Bank Statement Page

(Doc ID 2368901.1)

Last updated on MARCH 05, 2018

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

9.2 PUM 25 > Tools 8.55

ISSUE:
Warning message received while saving the Enter Bank Statement page. The page is calculating the Closing Balance based only on the transactions which appears first in the grid i.e. top 50 or 100 rows. Also, while downloading data from the grid it only downloads the visible rows not the complete data. For eg. if we have 300 rows and the grid displays for 100 then it will download only those 100 rows not the complete 300 rows.

ERROR:
Warning - Calculated sum of opening balance plus transactions -97580019.31 is different than closing balance -90153062.64
There may be an error in one of the transactions since the calculated sum does not equal the closing balance

STEPS:
1. Add Bank Statement: Banking > Bank Statements > Enter Bank Statement
2. Bank Transaction Entry page
3. Save
4. Warning Message received: Calculated sum of opening balance plus transactions 11000 is different than closing balance 9900. (9450,1229)
There may be an error in one of the transactions since the calculated sum does not equal the closing balance.

BUSINESS IMPACT:
Usability issue creates confusion

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms