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) / Base Currency Symbol i...
Microsoft Dynamics CRM (Archived)

Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I am having an issue where some fields on the field are not showing the base currency (Pound Sterling), but showing the current currency for the record. The value is the correct Pound Sterling value, but the symbol is not £, an example:

currency1.PNG

The Base currency is the correct £ price, but is not showing the correct symbol. Other fields on the form show correctly:

currency2.PNG

And another section has both correct and incorrect:

Currency3.PNG

So far I have not been able to find any pattern. I have added a new section to the form and added the fields there, but the issue still persists. Does anyone have any idea what is happening?

Thanks

Simon

*This post is locked for comments

  • Prashnat Verma Profile Picture
    Prashnat Verma 287 on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi,

    This will change once you close the opportunity as won or lose. 

    But yes unfortunately it is an issue confirmed by Microsoft technical team & i hope soon they will be providing the resolution for it.

    Thanks

    Prashant Verma

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi Andrew,

    That's good to know, unfortunately it is not the problem in our case.

    Thanks

    Simon

  • a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hello,

    Is it your case - crmtipoftheday.com/.../do-not-touch-currency-system-views

  • Steve Le Monnier Profile Picture
    Steve Le Monnier 955 on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi Jaya

    Not entirely sure I understand your question. But I can confirm that I am unaware of any bug affecting currency fields.

    In my example posted on the development forum what I had was 6 money fields that had been created by a colleague using a non IE browser. I noticed that one of the names he had used wasn't consistent with my naming conventions, so I deleted the field and re-created it myself.

    Fast Forward a couple of weeks and we noticed the when changing the currency field not all the money fields currency sign changed. All the MS fields were fine it was the custom fields that were not playing ball. Well all but the one I had created myself. After wasting hours trouble shooting I decided to delete and recreate the fields and then everything was fine.

    I don't know what the problem was, I don't know how my colleague set them up, but somewhere in that process these fields were damaged and behaving properly.

    If possible recreate one of the fields and see if that is okay, it may save you time looking for a bug you may never find.

    Steve

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    We are facing same issue On Load of form base fields are showing the symbol whatever selected in transactioncurrencyid lookup instead of $(organization currency).

    but in advanced find and updating some field and saving case its showing proper symbol for base fields.

    Is this a CRM Product bug? without adding above unsupported script how to show $ for base fields?

  • Steve Le Monnier Profile Picture
    Steve Le Monnier 955 on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi Simon

    I've a post on the CRM Dev Forums where this problem as got even stranger.

    Check out https://social.microsoft.com/Forums/en-US/905448d9-db78-4ab8-92fc-f74bf2b82cd1/crm2016-fix-currency-symbol-display-error-on-custom-attributes?forum=crmdevelopment

    For info on what I have discovered.

    Cheers

    Steve

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi Steve,

    I have seen a similar JQuery solution before, but that one changed the the Base or the Selected currency of the record during the onLoad. This may be useful for individual fields that are causing the problem, I will have a look further.

    I think you can download and add a jQuery library as a Web Resource and include it as one of the libraries in the form.

    Thanks

    Simon

  • Steve Le Monnier Profile Picture
    Steve Le Monnier 955 on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi Simon

    I've recently run into the same problem with currency fields showing the incorrect symbol.

    badcurrency.png

    After investigating this further, I believe the problem is caused by a change of currency on the form. Changing the default currency only seems to repaint the built in fields and not the custom fields. In the image above the top three fields are all custom and are showing the original currency sign, whereas the bottom field is an existing field which got repainted correctly.

    How this wasn't spotted and fixed in testing by MS I don't understand, but know I'm trying to find a solution to fix this efficiently and sightly. Some of the suggestions I've had thus far I've not had much luck with.

    Suggestion 1. Xrm.Page.data.refresh(true);

    Unfortunately this causes a save event which is an even bigger problem than the wrong currency signs

    Suggestion 2. JQuery Code 

    function ChangeCurrencySymbol(currencyInfo) {
if (currencyInfo != null) {
    var currencySymbol = currencyInfo.CurrencySymbol;
    // Looping through all currency controls on the form and sets the currency symbol.
    $.each($("span.ms-crm-Money-CurrencySymbol"), function()
    {
        this.textContent = currencySymbol;
    });        
}
}


    This code looks promising but I'm having trouble understanding how to use jquery in a supported manor within CRM 2016. MS say its unsupported to load jquery as is into forms. Others say encapsulate the code into own namespace, but I'm sure how to do this, and finally others say jquery is already built into crm, so if it is how do i access the libraries without getting $undefined errors?

    Any guidance gratefully received 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    Hi David,

    The views display the values with the correct currency symbols. I have disabled all onLoad, onSave and onChange scripting to the form and the issue still occurs.

    Thanks

    Simon

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Base Currency Symbol incorrect for some fields on Opportunity form, but the value is correct

    That does seem strange. The only mechanisms that I can think of are there being some custom code that's changing this:

    • Maybe there's client script on the form that is changing this, and this would affect the fields if you add them again to the form, as they are identified by the logical name.
    • Or, it might be possible for a plugin on the Retrieve to change this via the FormattedValues

    Do these fields show the correct symbols on views ? Client script wouldn't affect the data shown in a view, though a plugin could

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans