Instead of defaulting to the company’s home currency, the Default filter for all Business Intelligence Default Data has defaulted to USD.
Business Intelligence has its currency implementation which you can find in the Format Field menu. The currency symbol is in the $ sign because the static data, when Business Intelligence was created, were based in the US.
Make sure to backup your database before executing the script so you can restore it when needed.
Instruction on how to use the script:
- Load SQL Management Studio.
- Run the following script.
- Open it in a New Query window in SQL Management Studio.
- Point to your database. To run the script, click Execute.
set CurrencySymbol = (select top 1 Symbol from SystemCurrency where IsHomeCurrency = 1)
where FormatType = 'Currency' and GetCurrencyFrom = 'Home Currency'
Connected Business 13 only