Amount for updating in general ledger amount in local currency
Before the conversion, the GBP (British pound) to CAD exchange rate (2.34849) from the F0015 table was used to calculate the original domestic amount and the CAD to EUR rate (0.61752) was used to calculate the original alternate currency amount: The base currency conversion programs in Oracle's JD Edwards Enterprise One Sales Order Management, unlike those in Oracle's JD Edwards Enterprise One Procurement, convert the unit price and then use the converted unit price to recalculate the extended price.The conversion programs were specifically designed to convert the unit price: The base currency conversion programs in JD Edwards Enterprise One Procurement, unlike those in JD Edwards Enterprise One Sales Order Management, convert both the unit cost and extended cost, as well as the transaction amounts.It is not a tool that can perform translation of foreign subsidiary financial statements as part of a company consolidation.The additional reporting currency functionality only provides the option of preparing reports in another currency, as if that currency was the company’s local currency.Because exchange rates fluctuate constantly, additional currency equivalents in your system must be adjusted periodically.
The Additional Reporting Currency functionality should NOT be used as a basis for financial statement translation.As of the 8.11 release, the system stores both the domestic and foreign amounts on a single record in the F0911 table.The foreign amount is stored in the Foreign Amount field (ACR) and the Actual Amounts field (AA) of the CA ledger. The base currency conversion converts and updates foreign currency amounts differently, depending on whether the original transaction (before the conversion) is the currency of the new base currency.Unit costs, extended costs, and transaction amounts are converted: After all unit costs, extended costs, and transaction amounts are converted to the new base currency, the conversion programs recalculate the Unit Cost in Purchasing (PRRC).
This graphic is an illustration of Unit Cost in Purchasing recalculations: The programs for the base currency conversion convert records that are created and maintained using JD Edwards Enterprise One software.This list discusses how the currency of a transaction affects the conversion: Review this example to understand how the base currency conversion converts and updates a domestic-only transaction in the F0911 table.