how to reconcile RTGS payments in cash management
Hello,
In case of NEFT / RTGS payments made by Oracle AP, the bank UTR number is provided by the bank after the transaction is completed. In cash management, the reconciliation is based on transaction number. However, this number is generated in AP and cannot be updated. Due to this, automatic bank reconciliation fails.
Also, the document number field in Oracle is numeric in nature and does not support alpha. The UTR number is alphanumeric. This is also not supported by AP.
Can anyone please suggest a way out?
Regards,
Udit Pahwa