Reconciling External Transactions in PeopleSoft FSCM 9.2/ PUM 18/ PT 8.55.04
We have third party systems that issue checks and we load them to PS_BNK_RCN_TRAN table using a custom process. We load the check amount as +ve amount in TRAN_AMT field in PS_BNK_RCN_TRAN table. When we load the bank statement they get loaded as -ve amount in PS_BANK_STMT_TBL table and don't reconcile. If we update amounts to negative in PS_BNK_RCN_TRAN they do reconcile but we do not know if they should be loaded as negative in PS_BNK_RCN_TRAN table or there is another way to make them reconcile. Any help is appreciated.