What Are Report Currencies?
You can use a report currency to consolidate data from multiple companies that are operating in different base currencies. The process for creating such a consolidated report is the same as the process you would use to create any other type of report, but there are special considerations that you must make along the way.
Report currencies are additional nonbase currencies assigned to a company or activity group for reporting and analysis only. Transaction amounts are always converted to the base currency when they are entered or interfaced to the General Ledger. If you also use a report currency, transaction amounts are converted to both the base and report currency. If you use two report currencies, transaction amounts are converted to all three currencies (base, report currency one, and report currency two). Report currency balances are immediately accessible for viewing and reporting.
Example
LGE Corporation has three companies operating in different base currencies. They need to create a consolidated Income Statement report in US dollars (USD). As illustrated in the table below, Company 4321 has a base currency of USD and the other two companies, 4322 and 4323, have report currencies of USD.
The highlighted cells of the table show the data that would be accessed for a consolidated report of data from companies 4321 to 4323 if USD was selected on the Options tab of RW00.1. The consolidated amount that would print on the report is $10,500 USD.
| Company |
Base Amount |
Base Currency |
Report1 Amount |
Report1 Currency |
Report2 Amount |
Report2 Currency |
|---|---|---|---|---|---|---|
| 4321 | 5000.00 | USD | N/A | N/A | ||
| 4322 | 3000.00 | FRF | 1500.00 | USD | N/A | |
| 4323 | 9000.00 | DEM | 8000.00 | FRF | 4000.00 | USD |
Assigning a Report Currency to the Report
You must assign a report currency to a report to be able to produce the report in the currency. You can assign a report currency in one of two places:
-
In the Currency field on the Options form tab on Report Writer (RW00.1)
-
On the format by entering a currency code after a data dictionary name with a RAM (report amount) suffix, such as CYDRAM(FRF)
The Report Writer application first looks at the format for the currency. If a currency has not been specified on the format, the currency assigned on the Options tab is used. If no currency has been defined, the application will use the base currency of the first company in the company range.
Access Report Currency Data in a Format
Use a data dictionary name with a RAM suffix to access the currency specified on the Options form tab or on the Format. For example, if you use the CYDRAM data dictionary name and select CAD in the Currency field on the Options form tab of Report Writer (RW00.1), report results will be displayed in Canadian currency.
Define Appropriate Levels for the Report
When you define level ranges for a report that consolidates data from multiple companies you will need to use the company group option or the variable level range option to select multiple companies, such as 4321 to 4323.