Mapping & Importing MT940 in Oracle EBS R12 Cash Management Bank Statements | Auto Reconciliation

[@farihaafreen9761]

Excellent video Brother!

[@ERPstuff]

Much appreciated

[@AbdulRehman-ku]

This video contains Very Key Information indeed! Really Appreciable

[@ERPstuff]

Glad to hear that!

[@GodhuliDas-v5i]

Very informative and to the point video.

[@ERPstuff]

Glad you think so!

[@AbdulRehman-ku]

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?

[@ERPstuff]

dear all is explained in the video. thanks

[@0603010115]

Well explained . Thanks for sharing this

[@ERPstuff]

You are welcome

[@jayaveld124]

good video about CM

[@ERPstuff]

Welcome

[@umar3351]

Well explained

[@ERPstuff]

thanks

[@YgalAllouche]

some very informative stuff.

[@ERPstuff]

Glad it was helpful!

[@varuntarak1110]

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.

[@ERPstuff]

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

[@varuntarak1110]

@@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

[@jayaveld124]

thank you

[@ERPstuff]

Welcome

[@venusgold2486]

Can u share this presentation to us ?

[@ERPstuff]

Register for free and then you can download, www.erpstuff.com/viewtopic.php?t=11221

[@bhubusingh4378]

Hello Sir could you provide your email as I need to understand how we can automate the bank reconciliation process

[@ERPstuff]

[e-mail]