We are configuring the Cash Management Setup in existing Oracle EBS instance. We have successfully loaded and imported the Bank Statement in MT940 format and also able to reconcile it manually. Now we are stuck at the point that which code/number in the Bank Statement in MT940 format reflects the respective EBS Transaction (payment/receipt) link. If its clarified then we will be move to the final step of auto reconcile. Please guide which code (text/number) in the bank statement should reflect the respective payment/receipt (doc/check #/etc.) to reconcile the exact/respective transaction?
Sir after getting receipt amount from customer we create "RECEIPT" in our ERP and receipt number is auto generated by oracle ERP. But in bank statement different transaction number is there. Hence that transaction number in statement and receipt number in our ERP is different how can we make them reconcile. Please sir reply as quick as possible I am a fresher in my company and I took this task. Please help me with this.
Hi, if bank and you transaction can't match that means auto-recon will not happen now two options will remain one to write a script and based on details in the banks statment try to link with received based on date+amount and match or manual. thanks
This video contains Very Key Information indeed! Really Appreciable
Glad to hear that!
Excellent video Brother!
Much appreciated
Very informative and to the point video.
Glad you think so!
Well explained . Thanks for sharing this
You are welcome
Well explained
thanks
good video about CM
Welcome
some very informative stuff.
Glad it was helpful!
thank you
Welcome
We are configuring the Cash Management Setup in existing Oracle EBS instance. We have successfully loaded and imported the Bank Statement in MT940 format and also able to reconcile it manually. Now we are stuck at the point that which code/number in the Bank Statement in MT940 format reflects the respective EBS Transaction (payment/receipt) link. If its clarified then we will be move to the final step of auto reconcile. Please guide which code (text/number) in the bank statement should reflect the respective payment/receipt (doc/check #/etc.) to reconcile the exact/respective transaction?
dear all is explained in the video. thanks
Sir after getting receipt amount from customer we create "RECEIPT" in our ERP and receipt number is auto generated by oracle ERP.
But in bank statement different transaction number is there.
Hence that transaction number in statement and receipt number in our ERP is different how can we make them reconcile. Please sir reply as quick as possible
I am a fresher in my company and I took this task. Please help me with this.
Hi, if bank and you transaction can't match that means auto-recon will not happen now two options will remain one to write a script and based on details in the banks statment try to link with received based on date+amount and match or manual. thanks
@@ERPstuff really can we match with date and amount?? Please guide me how to do it.
And thank you very much for your reply sir
Can u share this presentation to us ?
Register for free and then you can download,
www.erpstuff.com/viewtopic.php?t=11221
Hello Sir could you provide your email as I need to understand how we can automate the bank reconciliation process
Info@erpstuff.com