Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

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

(0) ShareShare
ReportReport
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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans