Bank Reconcilation in PS 9.2
Hello! Good Day!
We are currently upgrading our client's PeopleSoft Financial System from 9.1 to 9.2 (Image 21). I understand that the AP Bank Reconciliation process has changed in Image 18 where PeopleSoft enhanced the recon processing. While I was testing the delivered AP reconcilation functionality, I encountered an issue where Bank Statements loaded into the PS_BANK_STMT_TBL are not reconciling to what's in PeopleSoft due to AMT (Amounts Not Equal). PeopleSoft uses the delivered BNK_RCN_AP_PYMN record view (pulls information from the PS_PAYMENT record) to match transactions to the Bank Statement table.
My question is, why does the PYMNT_AMT field negated in the BNK_RCN_AP_PYMN record? Is this used somewhere else? How does the Amount Tolerance used on this situation? This is causing the Reconcilation process set the RECON_STATUS to AMT since the Amount is not eual to the PS_BANK_STMT_TBL.