8 JD Edwards EnterpriseOne Multicurrency Processing Reports

This chapter discusses report navigation, overview information and a report sample for the following reports:

Note:

This reports guide discusses reports that are commonly used in the JD Edwards EnterpriseOne system. This reports guide does not provide an inclusive list of every report that exists in the system.

This guide is intended to provide overview information for each report. You must refer to the appropriate JD Edwards EnterpriseOne implementation guide for complete report information.

8.1 Currency Exchange Rates Report (R00151P)

On the Multi-Currency Processing menu (G11), select Currency Exchange Rate Entry. On the Work with Currency Exchange Rates form, select Exchange Rate Rpt in the Report menu.

Use this report to review currency exchange rates from the Currency Exchange Rates table (F0015). You can use the data selection to print the exchange rates for a specific currency as of a certain effective date, to print all exchange rates for a certain effective date, and so on.

Review the Currency Exchange Rates report (R00151P): Surrounding text describes r00151p.png.

8.2 External Currency Exchange Rates Processor Report (R0015Z1)

On the External Currency Exchange Rates menu (G11311), select External Exchange Rate Processor.

After you upload exchange rates from an external source into the External Currency Exchange Rates table (F0015Z1) and, if necessary, revise the rates, use this program to process information from the F0015Z1 workfile and stores it in the Currency Exchange Rates table (F0015).

Review the External Currency Exchange Rates Processor report (R0015Z1): Surrounding text describes r0015z1.png.

8.3 External Currency Exchange Rates Purge Report (R0015Z1P)

On the External Currency Exchange Rates menu (G11311), select External Exchange Rates Purge.

Use this report to purge exchange rate records from the External Currency Exchange Rates workfile (F0015Z1).

Review the External Currency Exchange Rates Purge report (R0015Z1P): Surrounding text describes r0015z1p.png.

8.4 Monetary Account Valuation Report (R09415)

On the Monthly Valuation menu (G1121), select Monetary Account Valuation.

Typically, you run this program at the end of a fiscal period and calculate unrealized gains and losses prior to running financial statements. The program creates journal entries with a document type of JX (foreign currency revaluation) for the unrealized gains and losses.

Review the Monetary Account Valuation report (R09415): Surrounding text describes r09415.png.

8.5 Calculate Currency Cross Rate Report (R11153)

On the Multi-Currency Processing menu (G11), select Calculate Cross Currency Rates.

After you create currency cross-rate relationships and review them, you calculate new exchange rates based on the common currency. Use this program to calculate the new exchange rates based on the cross-rate relationships in the Currency Cross Rates Calculation Master table (F11151) and the exchange rates in the Currency Exchange Rates table (F0015).

Review the Calculate Cross Currency Rates report (R11153): Surrounding text describes r11153.png.

8.6 Detailed Currency Restatement Report (R11411)

On the Financial Restatement menu (G1122), select Detailed Currency Restatement.

Use this program to apply current exchange rates to transactions when restating amounts from one currency to another. Based on a processing option, this program creates a second restated ledger of transactions for the alternate currency ledger (XA) only, or for the XA, YA (domestic origin), and ZA (foreign origin) ledgers.

Review the Detailed Currency Restatement report (R11411): Surrounding text describes r11411.png.

8.7 Currency Restatement Compute and Print Report (R11414A)

On the Financial Restatement menu (G1122), select Compute Restated Balances.

Use this program to restate balances from a source ledger into a consolidation ledger (AC).

Review the Currency Restatement Compute and Print report (R11414A): Surrounding text describes r11414a.png.

8.8 As If Repost Report (R11415)

On the Financial Restatement menu (G1122), select "As If" Repost.

Use this program to restate account balances in the domestic currency using a single exchange rate.

Review the As If Repost report (R11415): Surrounding text describes r11415.png.