Skip to main content

Setting Up a Reporting Currency

The Sage X3 Template allows you to create a reporting currency, which can be used to consolidate values across all reports. The steps to do this are as follows:

  1. Configure the Global Variable
  2. Generate lines for data entry
  3. Include the reporting currency amount in your reports

Configure the Global Variable​

  1. In the Global Variables section, search for YCURRPT.
  2. Click on the Edit button and modify the script to the desired reporting currency.

Generate lines for data entry​

  1. From the Command Center, go to Common Data > Configuration > Currency Rates.

  2. Right-click on the data model and select View Info Page.

  3. The following window appears:

    View Info Pages Settings​

    PropertyDescription
    Generate Lines From Currency Rates
    YearEnter the range of years for currency rates (e.g., From: 2022 To: 2024).
    Transaction CurrencyEnter the currencies to convert to the reporting currency.
    Reporting CurrencyEnter the currency you want to report on.
    GenerateClick to begin the generation process.
    Calculate Inverse Rates
    GenerateClick to automatically calculate the inverse currency rates.
    Delete Records
    YearEnter the range of years to delete currency rates for.
    Transaction CurrencyEnter the transaction currency to delete.
    Reporting CurrencyThe reporting currency to delete.
    GenerateClick to begin the deletion process.

  4. In the section titled Generate Lines for Currency Rates, enter the appropriate information.

  5. Click Generate to create the lines for data entry.

  6. Expand the Currency Rates data model and open the Currency Rates worksheet.

  7. You should see the table populated with the currency codes entered.

    There are 4 rate types to populate for each currency:

    Currency Rate TypeDescription
    Spot RateUsed for balance sheet accounts in Financial reports.
    Average RateUsed for all other accounts in Financial reports.
    Non-Financial RateUsed for all non-financial reports.
    Budget RateUsed for budget values in financial reports.

  8. Expand the transaction currency and month you wish to enter data into.

  9. For each date, enter the appropriate exchange rate. The worksheet will auto-save rates by default.

    Note: You may apply rates to the entire group at the same time by entering a rate at the group level.

  10. Optionally, calculate the inverse rates for all data entered. For example, if you enter exchange rates for CAD to USD, you may simply click the Generate button in the bottom part of the info page to calculate the equivalent rate for USD to CAD.

Include the reporting currency amounts in your reports​

Once the previous steps are completed, you may include Reporting Amounts (Measures > Reporting Currency Amounts) in all your SEI reports.