ECM: Book To Bank Unbooked Payments Are Showing As Positive Amounts Instead Of Negative Amounts
(Doc ID 2157145.1)
Last updated on MARCH 08, 2021
Applies to:
PeopleSoft Enterprise FIN Cash Management - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When all bank statement lines contained positive amounts, it was necessary for the Book to Bank Reconciliation process TR_BTB_CALC to negate the lines of the bank statement code that were defined as debits.
TR_BTB_CALC.UpdMAmts.AdjSign SQL)UPDATE PS_BTB_UNBKD_TAO4 SET MONETARY_AMOUNT = - MONETARY_AMOUNT WHERE
PROCESS_INSTANCE = 69550 AND (BANK_STMT_CODE = ' ' OR EXISTS ( SELECT 'X'
FROM PS_STMT_CODE_TBL WHERE BANK_STMT_CODE = PS_BTB_UNBKD_TAO4.BANK_STMT_CODE
AND TYPE_CODE = '3' AND CR_DB= '2'))
As of PUM 10 bank statements lines which are debits are now loaded with negative transaction amounts so this TR_BTB_CALC step is no longer necessary.
STEPS:
1. Create bank statement with bank statement lines
BANK_STMT_CODE 475
RECON_TRANS_CODE CHK
RECON_TRANS_AMT -100
2. Run Automatic Reconciliation to generate NTF exception.
3. Select and run Calculate Book to Bank process
4. On Book to Bank Reconciliation details page, click on Bank Adjustments link
Changes
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 |
Changes |
Cause |
Solution |
References |