Skip to main content

Reporting Currency

The Sage 300 template allows you to define a reporting currency, enabling you to consolidate values into a single currency across all reports—ideal for group-level or multi-national reporting.

Benefits of reporting currency​

  • Consolidating values across multiple entities: Produce reports that combine data from companies using different base currencies.
  • Reporting in a non-local currency: Present financial results in a currency other than the local operating currency.
  • Comparing values across currencies: Summarize or compare financial results across companies with different functional currencies.

Set up the reporting currency​

Configure the global variable​

  1. In the navigation panel, select the gear icon to open the Administration section.
  2. Go to Global Variables.
  3. Search for @@YCURRPT.
  4. Click the pencil next to it to open the Reporting Currency dialog.
  5. In the Script box, enter your reporting currency code (e.g., 'USD' or 'EUR').
  6. Click Update to save the changes.

Generate currency rate lines​

  1. Go to the Data Models and Views tab.
  2. In Sage 300, expand the Common Data > Configuration.
  3. Righ-click the Currency Rates data model and select Execute Info Pages.
  4. In Generate Lines for Currency Rates, enter the required information. Use the prompt icon as needed to select values.
  5. Click Generate to create the data entry lines and close the dialog.
  6. Expand the Currency Rates data model and open the Currency Rates worksheet. The worksheet is now populated with the currency codes.
  7. Expand the transaction currency and month you want to edit.
  8. Enter the appropriate exchange rate for each date.
    The worksheet auto-saves. To apply a rate across a group or month, enter the value at the group level.
  9. (Optional) Calculate inverse rates based on the values you entered.
    For example, after entering CAD to USD rates, click Generate at the bottom of the info page to calculate USD to CAD rates automatically.

Currency rate type​

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.

Include reporting currency amounts in reports​

  1. From the Toolbar panel, select Dimensions and Measures.
  2. In Dimension, select Reporting Currency.
  3. Drag the selected field into the Columns section to view consolidated amounts in your reports.

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