web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / 1 Entity with 2 lookup...
Microsoft Dynamics CRM (Archived)

1 Entity with 2 lookups to Currencies

(0) ShareShare
ReportReport
Posted on by Vassil

Hello,

We are designing an KPI entity which should be fed with datawarehouse data. The different values come in the default and local currency. The default currency is always USD but the other one is changing. When we create the first lookup to Currency in an entity all Currency fields use this one.

Is it possible that a set of fields is using one lookup ref to currency and another set uses another lookup ref to currency.

Thanks and regards,

Vassil

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Neil Parkhurst Profile Picture
    Neil Parkhurst 10,727 User Group Leader on at

    All of the currency fields on the entity will relate to just one of your currency fields. Out of box they will not take the second currency into account. As there isn't a mechanism to relate a specific money field to a different currency field.

    If the data is being fed into CRM from a datawarehouse maybe just put the local currency in CRM currency fields. Then old the USD values in a decimal field with precision of 2.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Vassil,

    Its not possible for one Entity to have two currencies. "transactioncurrencyid" is the field which define currency for all fields at the time of creation of record.  

    Hope this helps!!

    Regards,

    Kamran

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans