Hi Gurus,
Here, we implimented e-payments(Electronic-NEFT/RTGS) functionality for my client. Than we came to know that there is a issue with Bank reconcilation of there e-payment.
Generally system will reconcile that transaction with document number and Amout, but in the electronic payment method bank does not have check number, it will generate UTR number for e payments.
Here my question is how can get the UTR number in oracle and how it will get auto reconciled in oracle.
Rgds,
Sekhar.
Bank Reconsilation with e-Payments(NEFT/RTGS)
-
- Posts: 19
- Joined: Sat Mar 29, 2008 10:08 am
- Location: India
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
Hi Sekhar,
below is the logic system will follow as stated in the Oracle Cash Management user guide:
Matching Criteria for Payables Transactions
============================================
The Cash Management Auto Reconciliation program fully matches Payables transactions against bank statement lines if the transactions meet the following criteria:
? For payment batches (such as EFT batches), the Payment Instruction ID matches the statement line Transaction Number, and the transaction amount is within the reconciliation tolerance, and
? For the detail payment transactions stopped transactions, the matching sequence searches in the following order:
1. Payment Number
2. Invoice Number and Supplier Bank Account
3. Invoice Number and Supplier Name
Also, the transaction amount is within the reconciliation tolerance.
Note: If the bank statement does not provide a check number for a
payment, then matching to the invoice number and supplier bank
account number is particularly useful.
? For stopped transactions, the payment must first be stopped or voided in Payables.
Regards,
Karthikeyan
below is the logic system will follow as stated in the Oracle Cash Management user guide:
Matching Criteria for Payables Transactions
============================================
The Cash Management Auto Reconciliation program fully matches Payables transactions against bank statement lines if the transactions meet the following criteria:
? For payment batches (such as EFT batches), the Payment Instruction ID matches the statement line Transaction Number, and the transaction amount is within the reconciliation tolerance, and
? For the detail payment transactions stopped transactions, the matching sequence searches in the following order:
1. Payment Number
2. Invoice Number and Supplier Bank Account
3. Invoice Number and Supplier Name
Also, the transaction amount is within the reconciliation tolerance.
Note: If the bank statement does not provide a check number for a
payment, then matching to the invoice number and supplier bank
account number is particularly useful.
? For stopped transactions, the payment must first be stopped or voided in Payables.
Regards,
Karthikeyan
-
- Posts: 58
- Joined: Thu Aug 28, 2008 4:21 pm
- Location: India
-
- Posts: 19
- Joined: Sat Mar 29, 2008 10:08 am
- Location: India
Hi Karthikeyan,
How can we upload the bank file, since it should have UTR number which oracle does not have the adoptability to pick the BAnk UTR Number. After upload the bank file only reconcilation can be done, here the problem is now with UTR number. if we consider your below solution for auto reconcilation.
Rgds,
Sekhar.
How can we upload the bank file, since it should have UTR number which oracle does not have the adoptability to pick the BAnk UTR Number. After upload the bank file only reconcilation can be done, here the problem is now with UTR number. if we consider your below solution for auto reconcilation.
Rgds,
Sekhar.
Who is online
Users browsing this forum: No registered users and 7 guests