Thursday, December 10, 2009

CrmException: transactionCurrencyId needs to be supplied to format a transaction money field.



Sometime you may find above error when you tried to open a record in MS CRM. This happened because there is no data in transactioncurrencyid attribute defined in your record. (For my case, it is related to data migration issue.) This transactioncurrencyid field is related to money data type attribute.

Resolution: Query the default  transactioncurrencyid (guid) in your organization and update from SQL. Please backup your database before you start this process.

Sometime, it can also happened if you take out existing money attribute from your CRM entity. In this case, adding one money attribute to that entity will solve your problem. Weird Thing!!!