We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a parse rule set that will calculate inverse exchange rate using 'payment amount' and

Received Response
12
Views
5
Comments
edited May 24, 2021 11:00PM in Payables, Payments & Cash Management 5 comments

Summary

Is there a way to create parse rule set which will calculate inverse exchange rate using 'payment amount' and 'Original Amount' (like using formula payment amount/original Amount)?

Content

When in case of foreign/cross-currency payments (eg: SEK payment from GPB account), the bank statement (BAI) file has Payment amount,  
Original Amount, Currency and exchange rate.

unfortunately, the exchange rate on the BAI file is GPB -> SEK instead of  SEK ->GPB. This is causing the wrong exchange rate gain or loss calculation in Oracle.

Bank is unable to provide the inverse exchange rate on the BAI file.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!