Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Partner Quoting Workspace (PqW)
  • Editing a Quote

How to Use Decimal Quantities for Item Types

Learn how to use decimal quantity types for selected items in PqW

Written by Akanksha Shukla

Updated at March 2nd, 2026

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Partner Quoting Workspace (PqW)
    Introducing StrataVAR PQW Importing Vendor Quotes – Creating Bills of Materials (BoMs) Assembling a Quote Editing a Quote Pricing, Margins and Calculations in PqW Preparing a Quote for Ordering Exporting Quotes in PqW StrataVAR Admin Related Articles Order Management and Upload Finding and Managing Quotes Cisco 360 Estimated Land Rebate
  • Partner Renewal Workspace (PrW)
    About Partner Renewal Workspace (PrW) PrW Maintenance Contract Module PrW Subscription Module
  • Data Grid Capabilities
+ More
  • Partner Quoting Workspace (PqW)

    • Introducing StrataVAR PQW

    • Importing Vendor Quotes – Creating Bills of Materials (BoMs)

    • Assembling a Quote

    • Editing a Quote

      •  How to Edit a Customer Quote
      •  How to Clone Multiple Items (Box-Level Cloning)
      •  How to View Quote Summary
      •  How to Use Grouping in PqW to Group Quote Items
      •  How to Create New Version of Quote
      •  How to Use Decimal Quantities for Item Types
    • Pricing, Margins and Calculations in PqW

    • Preparing a Quote for Ordering

    • Exporting Quotes in PqW

    • StrataVAR Admin Related Articles

    • Order Management and Upload

    • Finding and Managing Quotes

    • Cisco 360 Estimated Land Rebate

  • Partner Renewal Workspace (PrW)

  • Data Grid Capabilities

Introduction 

StrataVAR Partner Quoting Workspace (PqW) supports decimal quantities for certain item types such as services, subscriptions, partial licenses, or usage‑based items.

This article explains when and how decimal quantities can be used in PqW, how they affect pricing and totals, and what to check when configuring item types to allow decimal values.


Why This Is Needed & Where It Fits in the User Journey

Not all items fit neatly into whole‑unit quantities. Examples include:

  • Services purchased in fractions of an hour or day
  • Subscriptions sold in partial terms (for example, 0.5 year)
  • Usage‑based or capacity‑based items (for example, 1.5 TB, 2.75 units)

Supporting decimal quantities allows users to:

  • Quote more accurately for partial or prorated services
  • Align deal structure with vendor or distributor BoMs that use decimal quantities
  • Avoid workarounds such as manual price overrides or additional lines

Decimal quantity usage typically appears:

  • After importing a BoM or adding items to a quote
  • When adjusting quantities for specific service or capacity items
  • Before finalising pricing and sending the quote to the customer

When to Use Decimal Quantities

Use decimal quantities when the vendor, distributor, or your internal pricing policy defines quantities that are not whole numbers

Item types represent:

  • Time‑based services (for example, 0.25 day, 0.5 hour)
  • Capacity or volume (for example, 1.5 TB, 2.3 units of resource)
  • Prorated subscriptions or partial periods

Do not use decimal quantities when the item must be purchased in whole units only (for example, hardware devices, per‑unit licenses that cannot be split)

The vendor or distributor system rejects non‑integer quantities for that SKU


Prerequisites

Before using decimal quantities, ensure that:

  • The item type (or product category) is configured to allow decimal quantities according to your organisation’s rules
  • Your quote layout or BoM layout has Quantity displayed as a numeric field that supports decimals
  • You have permission to:
    • Edit quantities on BoM items and quote items
    • Save quotes with updated quantities

Note: Item type configuration (for example, whether decimals are allowed and what precision is supported) is typically managed by administrators.

 

How Decimal Quantities Work in PqW

When decimal quantities are allowed for an item, you can enter non‑integer values in the Quantity field (for example, 0.5, 1.25, 2.75)

PqW calculates pricing as:

  • Extended List Price = List Unit Price × Quantity
  • Extended Net / Cost / Sell = Unit value × Quantity

Margin and totals follow from these extended values, just like with whole‑unit quantities.

If an item type is configured for whole units only, PqW may:

  • Prevent entry of decimals, or
  • Automatically round to the nearest allowed value, depending on configuration

Decimal quantities are only allowed when:

Your admin has enabled fractional quantity support in the global PqW configuration, and

The item’s Item Type is one of the types that your organisation (and PqW) has approved for non‑integer quantities (typically things like Professional Services and Managed Services).

For all other item types, quantities must be whole numbers. If you try to enter a decimal quantity for an unsupported item type, PqW will block the change and show an error that Non Integer values are not allowed for Item type.


Step-by-Step: Using Decimal Quantities for Item Types

Step 1: Add or Import Items into a BoM or Quote

  • Log in to your Salesforce/PqW environment.
  • Navigate to the relevant Opportunity / Quote.

  • Add items via:
    • BoM import (from Cisco, distributors, or files), or
    • Manual addition of items on the quote.
  • Create the quote for imported BoM and follow the process of adding BoM/BoM items to quote.

At this stage, items are created with default quantities as mentioned in the imported BoM - API/File. 

Note: If the decimal quantity is not supported for the item type and import file mentions decimal quantity, it will show BoM import error.

 

Step 2: Confirm the Item Type Allows Decimal Quantities

For each item where you expect to use decimals:

  • Identify the Item Type or Category (for example, Service, Subscription, Usage).
  • Confirm with your admin or reference your internal item type matrix to ensure that decimal quantities are allowed for that item type
  • The required decimal precision is supported (for example, 1 decimal place, 2 decimal places)

If decimals are not allowed for that item type, you may need to:

  • Use whole units only, or
  • Ask an admin to review whether that type can be enabled for decimals. This is typically done in Custom Metadata Types tab inside Setup. This change can be performed only by Admin users.

Step 3: Edit the Quantity with a Decimal Value

On the BoM or Edit quote grid:

  • Locate the item line you want to adjust and Click into the Quantity field.
  • Enter the desired decimal value, for example- 3.5 – half unit and click on enter to save. 

PqW recalculates:

  • Extended prices and costs
  • Margin % for that line
  • Overall quote totals, including tax/fees where applicable

Similarly you can modify quantity for other items or you can use bulk editing mode to change the quantities of multiple quote items simultaneously.


Step 4: Review Pricing and Totals

After entering a decimal quantity, verify:

  • Unit Price remains as expected
  • Extended Price / Extended Cost reflects Unit × Quantity correctly
  • Margin % is still appropriate for the deal

For service or capacity items, confirm that:

  • The decimal quantity matches the intended units (for example, 0.5 = half day, 0.25 = quarter of capacity unit)
  • There is no mismatch between what PqW shows and the underlying vendor/distributor quote

Step 5: Save and Use Decimal Quantities in the Final Quote

Once you’re satisfied with the decimal quantities and pricing:

  • Save the BoM or quote.
  • Proceed with: Internal review/approval steps and generating customer‑facing documents or proposals

Decimal quantities will be reflected in:

  • Line item details
  • Totals and summary sections
  • Any integrated downstream processes that read the quote values

What Happens After Using Decimal Quantities

Once decimal quantities are saved, PqW continues to treat those values like any other quantity. They are included in rollups, totals, and margin calculations.

If the item is updated later (for example, through a BoM re‑import or a pricing refresh), you may need to reconfirm the decimal quantity, especially if the upstream system uses whole units.

In some integrations, distributors or vendors might:

  • Round decimal quantities to allowed increments, or
  • Reject updates that use decimals for products that require whole units.

Check your integration behaviour if you see discrepancies between PqW and external systems.


Common Checks When Working with Decimal Quantities

It is recommended to:

  • Confirm that decimal quantities are permitted for the specific SKU or item type
  • Ensure the meaning of the decimal is understood (for example, 0.5 = half day, 0.1 = 10% of capacity unit)
  • Review extended prices and margins after changing quantities
  • Validate that downstream systems (for example, ordering, ERP) accept the same decimal logic

Any discrepancies between PqW and vendor/distributor values should be corrected before finalising the quote.


Conclusion

Using decimal quantities in PqW allows you to accurately quote services, subscriptions, and other non‑integer items without resorting to manual workarounds. When item types are correctly configured to allow decimals, PqW automatically recalculates prices, costs, and margins based on the entered decimal quantities.


What’s Next?

After understanding how to use decimal quantities, you may want to continue with:

  • How to Configure Item Types and Categories (for admins)
  • How to Edit Line Items on a Quote
itemization decimalization

Was this article helpful?

Yes
No
Give feedback about this article
In this article
  • Introduction 
  • Why This Is Needed & Where It Fits in the User Journey
  • When to Use Decimal Quantities
  • Prerequisites
  • How Decimal Quantities Work in PqW
  • Step-by-Step: Using Decimal Quantities for Item Types
  • Step 1: Add or Import Items into a BoM or Quote
  • Step 2: Confirm the Item Type Allows Decimal Quantities
  • Step 3: Edit the Quantity with a Decimal Value
  • Step 4: Review Pricing and Totals
  • Step 5: Save and Use Decimal Quantities in the Final Quote
  • What Happens After Using Decimal Quantities
  • Common Checks When Working with Decimal Quantities
  • Conclusion
  • What’s Next?

Related Articles

  • How to Edit a Customer Quote
  • How to Clone Multiple Items (Box-Level Cloning)
  • How to View Quote Summary
  • How to Use Grouping in PqW to Group Quote Items
  • How to Create New Version of Quote

Salesforce™, Force.com™ and other trademarks are trademarks of Salesforce.com, Inc. and are used here with permission.

Linkedin-in Youtube
Platform
  • Platform Overview
  • Partner Quoting Workspace (PqW)
  • Salesforce CPQ Enhencements (iCPQ)
  • Partner Renewal Workspace (PrW)
  • Integrations
Resources
  • Blogs
  • Case studies
  • White Papers
  • FAQ
Company
  • About us
  • Contact Us
  • Support Portal

2024© All rights reserved

  • Privacy Policy
  • Terms & Conditions

Made with 🤍  by StrataVAR

Knowledge Base Software powered by Helpjuice

Expand