Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Does anyone know how I can change the number of decimal places on an invoice/quote/order?

Posted on by Microsoft Employee

I have created custom Word Invoice/quote/order templates but the quantity shows 5 decimal places.

Do you know how I can change this to none?

Any help would be appreciated.

Thanks, Carl.

*This post is locked for comments

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    I hope someone has an answer here!  I think this is definitely needed as well...

    Thanks much,

  • Thomas I Profile Picture
    Thomas I on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    So... no idea to allow the use of decimal numbers with custom templates ?

    This seems like a big missing feature... quantities might be OK without decimals, but typically discounts would eventually need it !

  • Verified answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    Carl, since I solved can you please verify my answer?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    That worked perfectly.

    Thank you.

    One less thing on my endless list done!

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    Hopefully this change helps Carl, it should display 0 decimals if you change the precision to 0.

    Thanks,

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    Hi Carl,

    You have to change the precision in the customizations for the quantity attribute on your entity. PLease see the below screenshot :

    62520.Capture.JPG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    Drew, I think I missed a step in this one...

    Where do I change the precision entry?

    Thanks,

    Carl.

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    Hi Carl,  if that is true then can you just change precision as I mentioned on the quantity field in the entity?

    Thanks,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    It is a shame because it makes the quotes/invoices look very untidy.

    None of our products can be divided into fractions so we will only every need a number and no decimals.

    If you find a way I would love to know.

    Thanks,

    Carl.

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Does anyone know how I can change the number of decimal places on an invoice/quote/order?

    Hi Carl,  

    I don't think this is possible without changing the decimal precision on the quantity field in Dynamics CRM.  I looked at multiple ways to utilize content controls to make this happen for the Word Template and I could make it work but only with VBA code like what was done in this article:  gregmaxey.mvps.org/.../contentcontrol_enhancements_word_2013.html

    Once you do that you are not able to load into Dynamics CRM because it is not a supported format.

    I wish we had the capability like MERGEFIELD in mail merge...

    Anyone else have other ideas or something that I missed?

    Thanks,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans