ECM: Book To Bank Unbooked Payments Are Showing As Positive Amounts Instead Of Negative Amounts
Last updated on APRIL 02, 2018
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.
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.
1. Create bank statement with bank statement lines
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms