Where Currency code are stored in MS Dynamics CRM

(0) Share

Report

Posted on by Community Member

Hi All,

I do have a query in MS CRM we are maintaining currency record in "transactioncurrency" Entity.

When we are creating currency record then on create currency form there is a lookup of Currency Code. I want to know from which Entity these Currency code are stored in CRM.
Scenario which I want achieve from plugin :
I have to create Currency records in Transaction Currency from Plugin, so before creating record in "transactioncurrency" I want to check that if currency code is present or not. If its present then only create the record in "transactioncurrency".

Please suggest on same . Thanks

Kamran.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

You can find the list in your organization database's table named as "transactioncurrencybase".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Vikas,

I am referring to below currency Code on Transaction currency form.

Regards,

Kamran

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes Kamran, this is the form I am talking about too. If you check the form editor, the currency code field is a normal text box. However, when you click, it shows you list of available currencies. That list is pulled from transactioncurrencybase table. Looks like it is not available as an entity. So you have to query the table instead.

Thanks

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear Arjum,

he currency cofe stroed in transactioncurrencybase entity. You can get the detials in the following link.

msdn.microsoft.com/.../gg328355.aspx

Regards,

Hasintha

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Vikas,Hasintha.

I absolutely agree with you that currency code are text fields in "transactioncurrencybase" table.

I have yet not got what i am looking for.
As shared one screen shot in above post,plz check there are two "Currency Type" ie System & Custom.
If we select Custom then Currency Code is appearing as text field but if we select as System then its Lookup and gives a list of currencies.
I am searching how this text field is changing to lookup when type is system ?

Also When Currency code is acting as look up from where data is population in Currency code lookup ?

Was this reply helpful? Yes No
Verified answer

MilindP 1,019 on at

Like (1)

Report
Copy link

Link copied!

The currency lookup gets the value of the existing currency using "TransactionCurrency.RetrieveDotNetCurrencies". the lookup is calling a view with id "1A364391-BF41-407B-B91F-5C326BAF0A3B" in saved query.

if you check this record

select * from SavedQuery where SavedQueryId='1A364391-BF41-407B-B91F-5C326BAF0A3B'

in the field QueryAPI it mentions "TransactionCurrency.RetrieveDotNetCurrencies"

Please see this blog

http://mscrmshop.blogspot.com/2012/11/list-of-currencies-in-crm2011.html

Was this reply helpful? Yes No
MarkR_B 465 on at

Like (1)

Report
Copy link

Link copied!

To check if the currency exists within your plugin you can use the following QueryExpression

QueryExpression GetCurrency = new QueryExpression("transactioncurrency");
GetCurrency.Criteria.AddCondition("currencyname", ConditionOperator.Equal, "Pound Sterling");
EntityCollection currencies = service.RetrieveMultiple(GetCurrency);

Hope this helps

Mark

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

MilindP ,

Appreciate your response and findings. This is something i was looking for which u told.

Seems to me that CRM has not exposed the table where it exactly stores currency. I am still finding what this QueryAPI( "TransactionCurrency.RetrieveDotNetCurrencies" ) is performing behind the scene.

Regards,

Kamran

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Please go thru the blow link. you will get some idea.

mscrmshop.blogspot.com/.../list-of-currencies-in-crm2011.html

Was this reply helpful? Yes No
Saddamk206 777 on at

Like (1)

Report
Copy link

Link copied!

Get and Set Currency(Money) using C#

Get : -

var moneyValue = ((Money)item.Attributes[attributeName]).Value;

Set: -

newSalesOrder[attributeName] = new Money((decimal)moneyValue);

Was this reply helpful? Yes No