Answered

How do I use decimals for product quantity?

(0) Share

Report

Posted on by Community Member

Hi,

I'm adding some products to my CRM online instance. I'm having trouble setting them up so that I can use decimals for product quantity such as; 0.25, 0.50 or 0.75 when adding products to quotes, orders, invoices etc.

I've created a unit group called 'Hourly Unit' with a default unit of 'Hour'.

I've created various products such as "out of hours remote support" and "out of hours on-site support". In these products I've set 'Decimals Supported' to '2'.

I've added my products as items in the Standard Pricelist and set 'Quantity Selling Option' to 'Whole and Fractional'.

From what I understand, the above should allow me to choose a product quantity of 0.25 etc when adding a product to an invoice? The problem is that when I do this, the decimal numbers are rounded up or down (i.e. 0.25 becomes 0 and 0.75 would become 1.)

Can anybody explain why this is happening? Have I got the wrong idea about selling fractions?

Thanks,

James

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

I found a solution elsewhere. All I needed to do was change the 'precision' value for the 'quantity' field on the product entities (opportunity product, quote product, order product, invoice product etc.) It was set to 0 on my system. I've now changed this to 2 and I can enter 0.75 etc.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

Did you set rounding policy in Price list item None? If not you have to set that value in order to keep whatever decimal value you entered in the Quantity field. Otherwise system will do round based on the Rounding policy you have it in the price list item

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi,

My pricing method was set to currency and therefore I didn't have any rounding methods entered. The problem was that the 'precision' field on my product entities had been set to 0. I changed the precision to 2 and it now allows me to enter the decimals.

Was this reply helpful? Yes No