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

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Forcing a 0 decimal for products on quote

(2) ShareShare
ReportReport
Posted on by 32
Each of my products has 0 decimal points, however, the quotes still forces 5 trailing zeros (cannot understand this behaviour!)
 
- I cannot edit the quantity field under Quote Products Columns
- The Word template also has no native mechanism to modify the field for force even a 2 declimal
 
How on earth do we then tell the system that when generating quotes, dont apply decimal points to the quantity? 
Categories:
I have the same question (0)
  • MVP-Daniyal Khaleel Profile Picture
    639 on at
    Forcing a 0 decimal for products on quote
    Why This Happens
    Underlying Field Type:
    The Quantity field on Quote Product (or Opportunity Product, etc.) is a decimal number field in D365.
    Even if your product unit precision is set to 0, the system still stores Quantity as a decimal and doesn't auto-format the display.
    Word Template Behavior:
    Word templates pull raw field values with default formatting (often 5 decimal places).
    There is no built-in option to format decimals directly within the Word XML template editor.
    ✅ Solutions & Workarounds
    Option 1: Format Field in Word Template (Recommended)
    You can force decimal formatting in the Word template using field switches in Word. Here’s how:
    Steps:
    Open your Word template.
    Press Alt + F9 to show field codes.
    Find your Quantity field—it will look like:
    { MERGEFIELD "quantity" }
    Modify it like this:
    { MERGEFIELD "quantity" \# "#,##0" }
     

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 149

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 142

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 125 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans