Reporting currency: Currency conversion date?

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
archanadixit
Posts: 3
Joined: Thu Jan 31, 2008 12:37 am
Location: India

Reporting currency: Currency conversion date?

Post by archanadixit »

Hi All,

My question is on R12 General Ledger Reporting Ledger.

When I create a journal in GL in the primary ledger which has a reporting ledger associated to it say with the following information:
Currency: USD (Functional Currency)
Effective Date: 21-08-2009

What date will be used to convert this to INR (Reporting currency)?

Another example would be a foreign currency journal:
Currency: ITL (Functional Currency)
Effective Date: 21-08-2009
Currency Conversion Date: 20-08-2009

What date will be used to convert this to INR (Reporting currency)?


Same questions for transactions from subledgers (AP and AR).

Appreciate your help.

Thanks,
Archana
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

<b>When I create a journal in GL in the primary ledger which has a reporting ledger associated to it say with the following information:
Currency: USD (Functional Currency)
Effective Date: 21-08-2009
What date will be used to convert this to INR (Reporting currency)?
</b>
The conversion date used in the journal (unless you changed it manually, it will be same as effective date) will be used to convert to INR.
<b>Another example would be a foreign currency journal:
Currency: ITL (Functional Currency)
Effective Date: 21-08-2009
Currency Conversion Date: 20-08-2009</b>
Here again, currency conversion date will be used to convert to INR.

Cheers,
Saravanan TG
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

For subledger transactions, it depends on the conversion method.

If the conversion method is "Journal', then conversion will happen based on the journal conversion date. Conversion will happen only during posting of JV

If the conversion method is 'Subledger', then the conversion will happen
a. based on the GL date for functional currency transactions
b. based on the exchange rate date of the transaction for foreign currency transactions.
In this case, conversion will happen during accounting of the subledger transactions.

Cheers,
Saravanan TG
Post Reply

Who is online

Users browsing this forum: Google Adsense [Bot] and 7 guests