Financial - JDE1 (MOSC)

MOSC Banner

How does GLHCRR (Historical Date) and GLHDGJ (Historical Date) get populated?

edited Dec 4, 2013 1:51AM in Financial - JDE1 (MOSC) 1 commentAnswered
My company is using multiple currencies, all exchange rates appear to be coming out of Rate Type M Month End Balance Sheet tables in Currency Restatement (P1113).

Despite having H* Rate type tables, most of our FX related entries to the F0911 have either the rate or date fields populated for Historical amounts.  Our M rate tables are updating weekly, and that appears to be the FX rate stamped in GLCRR as the entries post throughout a month.  Users in my company want the historical GLHCRR populated for FX gain/loss analysis over a period. 

What I can't seem to find is how the Historical Date field chooses to get populated (as function of entry, doc type, process step involved, etc).  I believe (and I'm currently guessing) that populating the GLHDGJ field and having an appropriate H* Rate type currency table would give us a proper HCRR value in the F0911.

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

E1 Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center