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

Bu cavab sizə kömək etdi? 0 istifadəçi bunu faydalı hesab edir (0 səs)

Ən məşhur məqalələr

No Field to Enter the Customer Purchase Order and Alternate Order Number on the Import Manager Template

Synopsis: No field to enter the Customer Purchase Order and Alternate Order Number in the Import...
CBlogo
How to create new company database starting CB22 and Higher Versions
How to Export Email Address of the Customer

Synopsis: How to Export the Email Address of the Customer Solution:  There is an option to...
Known Issue: Sales Tax Not Calculating for Customer That Uses Zip+4 Address

Synopsis: Creating a sales order for a customer who uses a Zip+4 address does not calculate tax....