Skip to main content

Global Currency Rates

Many data models in the standard Nectari template return amounts converted to your company’s global currency. Conversion is based on rates stored in a custom table (ZTABCHANGE), which is created during template import. To keep your reports accurate, you need to regularly update these currency conversion rates.

You can update the rates automatically using a scheduled job or manually in Nectari.

note

For most implementations, it is strongly recommended to schedule an automatic update job in SQL Server Agent.

Benefits of global currency rates​

  • Standardizing analysis: Ensure all reports and KPIs use consistent currency rates for consolidated and comparative analysis.
  • Reducing manual errors: Automate updates to minimize mistakes and save time over manual entry.

Set up an automatic job​

Setting up a scheduled job to refresh global currency rates works best for ongoing maintenance. Frequency should be agreed with the client (for example, daily after office hours). Repeat this process for each defined environment or custom schema.

On SQL Server​

  1. In SQL Server Management Studio, set up a new SQL Server Agent Job.
  2. Use a script like the following, replacing x3 with your Sage X3 ERP database name, , NEC_SEED with your Nectari custom schema, and USD with your global currency code: 
    USE [x3]
    GO
        EXEC    [NEC_SEED].[ZREFCNVRATES] 'USD'
  3. Create a separate job for each custom schema created during Template Import, ensuring each job calls ZREFCNVRATES in the correct schema.

On Oracle​

  1. Create a new job in Oracle to run a script similar to: 
    BEGIN
        NEC_SEED.ZREFCNVRATES('USD')
    END;
  2. Replace NEC_SEED with your custom schema, and USD with your reporting currency.
  3. Set up one job per custom schema used in your installation.

Update manually​

  1. Log in to Nectari.
  2. In the navigation panel, select Data Models and Views.
  3. Expand Sage X3, then Common Data.
  4. Right-click the Global Currency Rates (Consolidation) data model and click Execute Info Pages from the context menu.
  5. Click Update internal currency exchange rates.