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

In cash management, how to create system transactions automatically from imported bank statement

in Payables, Payments & Cash Management 2 comments

Hello,

I'm working on the Oracle Fusion Cash Management and have a scenario where i want the imported bank statement (XML file, i.e. CAMT.053/BAI2) to automatically create system transactions before reconciliation.

Example:

  • Ledger currency: HKD
  • Bank Statement Line: Cr. 10,000 JPY
  • The Bank Statement XML provides an exchange rate: JPY to HKD = 0.052
  • Expected outcome: system transaction is created for HKD 520 in functional currency (book currency), using the rate provided in the bank file.

My questions:

  1. How can I configure Fusion so that the exchange rate from the imported bank statement is used to generate the system transaction, instead of pulling from the corporate exchange-rate table?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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