Synopsis:

Instead of defaulting to the company’s home currency, the Default filter for all Business Intelligence Default Data has defaulted to USD.

 

Cause:

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.

 

Prerequisites:

Make sure to backup your database before executing the script so you can restore it when needed.

 

Resolution

Instruction on how to use the script:

  1. Load SQL Management Studio.
  2. Run the following script.
  3. Open it in a New Query window in SQL Management Studio.
  4. Point to your database. To run the script, click Execute.

update SystemDashboardManagerFieldFormat
set CurrencySymbol = (select top 1 Symbol from SystemCurrency where IsHomeCurrency = 1)
where FormatType = 'Currency' and GetCurrencyFrom = 'Home Currency'

 

Applicable Product:

Connected Business 13 only

Was this answer helpful? 0 Users Found This Useful (0 Votes)