Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

PC Conversion of GL Foreign Currency Transactions

edited Jan 27, 2014 4:53AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 5 commentsAnswered ✓

Hello Projects Community

We have a client who has a requirement to have PC convert some foreign currency transactions at the same exchange rate as is used by the GL, which is a "user defined" rate and NOT a value from the PS_RT_RATE_TBL.

Example:  In the GL journal:

Currency = QAR
Amount = -56,259.74
Rate Type = blank
Exchange Rate = .27429898
Base Currency = CAD
Base Amount =-15,431.99

The base amount of -15,431.99 is what is posted in the Monetary Amount in the journal line in GL.

However, when this transaction goes to Project Costing, the PC_MULTI_CUR job tries to find a value from the PS_RT_RATE_TBL.  Because the rate type is blank, it then defaults to the NoRate step and posts the Foreign Amount from GL to the Resource Amount in PC.  The result is the same if the rate type field is populated with the exchange rate.

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