Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

1 Entity with 2 lookups to Currencies

Posted on by

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

Categories:
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 1 Entity with 2 lookups to Currencies

    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

  • Verified answer
    Neil Parkhurst Profile Picture
    Neil Parkhurst 10,725 User Group Leader on at
    RE: 1 Entity with 2 lookups to Currencies

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans