8.3 Functional Currency for Reporting

To see the analytics reporting amounts in a preferred functional currency, there are some tasks that you need to perform at the Profitability Management Cloud Service (PFTCS) end, which is currently a prerequisite for the Profitability Analytics Cloud Service to be operational.

In PFTCS you will need to visit the Reference Data menu and set up a currency in the Currencies module. For functional currency, please indicate No for Reporting currency.

Confirm that all currencies required by the input data and reporting configuration are active. To activate a currency, select the inactive currency and click Activate from the toolbar or the Action menu. Activate the required currencies before loading exchange rates

Next you will need to access the Currency Rates module under Reference Data menu to define the exchange rate, applicable for a specified time period.

Ensure that exchange rates are available for the required currency pairs and processing dates. Select the From Currency, To Currency, Rate Type, configured Rate Provider, and effective-date range. Upload and save any missing rates. Click Currency Rate Validation, select Specify Dates and enter the required period, or select Validate For All Dates, and then click OK. Resolve validation errors before executing the runcharts.

As of now multiple currency rate providers is not supported. Note that Conversion rate used in reporting layer is always the latest exchange rate data and rate provider combination value as per the inputs provided. If you want to figure out the exchange rate getting used, you can click on Actions > Analytics under Currency Rates to see the analytics report. Else you can refer to the same report under Operations Analytics section of the Analytics menu under PACS. Once the currency rate has been loaded and validated, please select the preferred functional currency for Analytics reporting from the dropdown under the Global Parameters section of the Preferences menu in PACS.