Skip to main content

Reporting Currency

Reporting currency in SEI allows you to consolidate all financial values into a single currency for analysis and reporting. By setting up a reporting currency, you can produce group-level reports, support multi-national analysis, and ensure consistency in financial KPIs across different entities. Once configured, reporting currency measures are available in any data model.

To use them, open a visualization, select Dimensions and Measures from the Toolbar panel, and choose any measures from the Reporting Currency folder.

Benefits of reporting currency​

  • Consolidating multi-entity values: Enable group reporting by converting transactions from different base currencies into a single currency.
  • Standardizing financial analysis: Provide one common reporting standard for comparing results across multiple subsidiaries or legal entities.

Configure the global variable​

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. On the left panel, click Global Variables.
  3. Click the pen icon next to @@YCURRPT. Use the search box to find it quickly from the list.
  4. Next to Scripts, enter the desired reporting currency code, such as EUR.
  5. Click Update to save your changes.

Generate lines for data entry​

  1. In the navigation panel, select Data Models and Views.
  2. Expand Sage X3, then Common Data and Configuration.
  3. Right-click the Currency Rates data model and select Execute Info Pages from the context menu.
  4. Under Generate Lines for Currency Rates, fill in the required properties, and click Generate to create lines for entry.

Generate Lines for Currency Rates propeties​

PropertyDescription
YearEnter the year or range of years for which you want to input currency rates.
Transaction CurrencySpecify the currency or currencies to convert to your reporting currency. To select multiple, use Ctrl with the prompt or enter codes separated by a semicolon (;).
Reporting CurrencyEnter the code of your reporting currency. To select multiple, use Ctrl with the prompt or separate codes with a semicolon (;).

Enter and manage exchange rates​

  1. In the navigation panel, expend the Currency Rates data model.
  2. Open the Currency Rates worksheet. The sheet contains four column:
    • Spot Rate: Used for balance sheet accounts in financial reports.
    • Average Rate: Used for all other accounts in financial reports.
    • Non-Financial Rate: Used for non-financial reports.
    • Budget Rate: Used for budget values in financial reports.
  3. Expand the transaction currency and month you want to enter data for.
  4. Enter the exchange rate for each date as needed.
    To input a value for an entire month, enter the rate at the month level.
tip

Instead of manually entering inverse rates, you can click Generate under Calculate Inverse Rates within Execute Info Pages to automatically calculate inverse currency rates.