Report Currency Table

Overview

The Report Currency table defines the currencies Portfolio Slicer can use for reporting.

Portfolio Slicer supports up to three reporting currencies, plus the special *Original* value.

This table should have minimum 2 records - first record with *Original* value and second record with your primary reporting currency value and CurrencyID = 1.

Table Columns

ReportCurrency - Three chacter currency code. Values in this column (excluding *Original*) should be the same as values in configuration file psConfig.txt parameter Currency.
CurrencyID - Numeric value, representing unique currency sort order. Value 0 always should be assigned to currency *Original*. Value 1 should be assigned to your primary used currency. Other records are optional and additional acceptable values are 2 and 3.

Required Structure

The first row should remain the special *Original* record with CurrencyID value as 0.

When a report uses *Original*, Portfolio Slicer does not convert values into a single reporting currency. That can be useful for inspection, but totals may not be meaningful if multiple currencies are involved.

The second row should be your primary used currency with CurrencyID value as 1.

Two more rows after that, with CurrencyID 2 and 3, are optional.

Why This Table Matters

This table is closely tied to:

symbol currency definitions
account currency definitions
exchange-rate data in CurrencyConv.csv
reporting exchange-rate override fields in transactions

If these parts are inconsistent, multi-currency reporting will not behave correctly.

Practical Advice