About consolidating companies with different 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 kind of report, but there are special considerations that you must make along the way.

Report currencies are additional non-base currencies assigned to a company or activity group for reporting and analysis only. If you use report currency, then the transaction amounts are converted to both the base and report currency. Report currency balances are immediately accessible for viewing and reporting.

Assigning a currency to the report

Assign a currency to the report to select which currency the report should use to print in. By assigning a currency, Report Writer finds the appropriate currency to use whether it is in Base, Report 1, or Report 2. You can assign a currency in one of two places:

in the Currency field on the Options 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, then the currency assigned on the Options tab is used. If no currency has been defined, then the application uses the base currency of the first company in the company range.

For example, if you use the CYDRAM data dictionary name and select CAD in the Currency field on the Options tab of Report Writer (RW00.1), then the report results display in Canadian currency.

Define appropriate levels for the report

When you define level ranges for a report that consolidates data from multiple companies, you need to use the company group, accounting unit list, level group, company range, or variable level range option to select multiple companies, such as 4321 to 4323.

Note: If you want to consolidate data from multiple companies, then all companies must have the same organizational structure. This means that they must have the same number of levels and each level must be the same size. The companies must also use the same chart or share a master chart.

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