- Open Microsoft SQL Server Management Studio and connect to the SQL server hosting your CRM database.
- Find database with name [YourCompanyName]_MSCRM
- Backup that database!
- Open table [dbo].[TransactionCurrencyBase]
- The existing base currency is the first row. Ensure the target currency is there.
- Open table [dbo].[OrganizationBase] for edit. Find your organization there, most likely there will be just one row.
- Change CurrencySymbol, BaseISOCurrencyCode, BaseCurrencySymbol and BaseCurrencyId. The last field’s value you should take from TransactionCurrencyBase table, from the TransactionCurrencyId field.
That’s it. One thing you should bear in mind – if the conversion rate to base currency was used somewhere, the numbers may become incorrect. Like, if the sum was meant in base currency, but the base currency changed without recalculation.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.