Payables and Cash Management - EBS (MOSC)

MOSC Banner

Bank Statement Lines are not reconciling because of diffrent Exchange rate

edited Aug 20, 2021 7:35AM in Payables and Cash Management - EBS (MOSC) 10 commentsAnswered

Hi,

We are using cash management for Reconciling a Payment. But for those payment where the transactional currency is different from the Functional currency, lines are not getting reconciled.

As an example,

Functional Currency: USD

--------- Bank Statement Details-----------------

Transactional Currency: AED

Transaction amount(AED):2320.81

Exchange Rate Type : User

Exchange Rate: .7841

Converted amount (USD) : 1819.75

Exchange Date: Statement Creation Date

--------- Bank Statement Details-----------------

---------Details in Sub-ledger--------------------

Transaction Amount:2320.81

Base Amount:1804.54

Exchange Rate Type: Corporate

Exchange Rate Date: Transaction Date

Exchange Rate: 0.7775503

---------Details in Sub-ledger--------------------

In setup, I have put tolerance as 0.

Ideally this line should be reconciled automatically, but these lines are not getting reconciled. But as expected, in this case a Gain/Loss amount should be appeared when I run the create accounting after reconciling the payment.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center