Specifying Currencies in Intercompany Matching Reports

You can generate an Intercompany Matching report in a currency that you specify. This enables you to run the report and validate intercompany transactions in a common currency before the amounts are consolidated. For example, to check the values in the EUR currency, you could change the Value in the Point of View from USD to EUR and generate the report.

If you define a report using a currency that has not been translated, the system performs the translation process using the translation rules defined in the Sub Translate section of your rule file. The system also stores the translated amounts in the corresponding currency Value dimension member. However, if the reporting currency has previously been translated and the translation status of the entity is OK, the system does not need to re-translate and uses the stored translated amounts for processing the Intercompany Matching report.

For example, if you run an Intercompany Match report for the currency EUR, the system first checks if the translated data has been created for the EUR currency (V#EUR). The system also checks to ensure that translation status is OK. If the translation status of the entity is TR (requires translation), the system re-translates to ensure that the translated data is valid. Otherwise, the system uses the stored translated amounts for processing. However, if the data has not yet been translated to EUR, the system performs the translation process as defined in Sub Translate and stores the translated amounts in the EUR value member. The EUR translated amounts are also used for the Intercompany Matching report.