Decimal Places
Richard Noakes
Please provide an option to round prices to two decimal places throughout i.e. not just display two decimals but round off.
Decimals are tricky. I just ran into the problem where I'm creating a disassembly from one double pack of products into two single packs. Let's say the double pack cost $6.97. Dividing by two results in $3.485. When I load the BOM, the price per unit is displayed as $3.48 and yet the total still adds up to $6.97. So this is where you need and want the extra decimals but you also want to be able to see the meaningful fractional cents, perhaps up to four places (which is what's used in the Maximum Quantity field for disassemblies). I ended up just breaking the result into two individual units with on priced at $3.48 and the other at $3.49. Better that than an invisible fraction of a cent.
I'd also like to see decimal places in the Dimensions tab of a product record. If I enter a value as "4.250" then that is what I want to see.
So maybe the site-wide setting for decimals should not be on/off, but should be "decimal precision" and then you specify up to 4 or 5 places. Obviously, rounding would then be assumed to be applied automatically by DEAR when precision is set to less than needed: if you set precision to "2" then values with a third place would be rounded.
7 people like this
How about a General Setting to control the number of visible decimal places on pricing? You do it for quantity. Why not pricing?
5 people like this
Thanks Mark, you've set it out clearly.
Come on DEAR, how about some response to this one? This issue clearly needs some attention.
5 people like this
This is an issue for us also, as our pricing structure is a discount off of an rrp - we now have to reconfigure our pricing due to this issue, which is by no means a quick task....
A simple setting would make things so much simpler, especially when it is already there for quantity.
3 people like this
4 decimal points in an accounting system for a value is strange
2 people like this
2 people like this
Any update on this Dear or a plan to have this developed in the road map - it really is a basic requirement - failing that more pricing tiers are needed - we simply need a solution!
1 person likes this
This is particularly needed on the B2B portal. Prices are displayed to 4 decimals. Surely the norm would be two in this case even if all the decimals are preserved in the system?
1 person likes this
It is a major problem for us - our sales department is giving me hell over this! We are a distribution company that publishes a price list and when DEAR applies our 33% trade discount to a sales order line for a large quantity of items (we sell in the hundreds) the lack of rounding means that the line total is inflated above our published prices. We are having to manually adjust every order because of this. We need unit-price rounding to be to two decimal figures after the customer's discount has been applied and before the quantity has been totalled so that the simple multiplication of quantity x discounted unit-price to two decimal places is correct!
Agreed this is a major problem for us - the cost of Dear keeps increasing but the basics are not being addressed....
Agreed, this is clearly a failing and problematic for our processes.
We would like the ability to choose the number of decimal points we work to in production orders – most of the time we do not use any more than 2 decimal points. The increased decimal point for precision is not needed and time consuming to fix.
See attached for settings and the problem in action (image). It would be great if we could choose the decimalisation we work to within the production module.
It means we chase round small decimal points in the system unless anyone thinks to 0 out the decimals.
Would be good to have a resolution to this as we find this has a big impact on our business functions.
Hi Marvin,
Thanks for the above I have reviewed in full and it does not fix the issue we have. I believe our request is very basic - all we want is the ability to round all customer pricing to 2dp.
So we have one fixed price the customer then gets a discount of x% off of the price, and the system then rounds this, as we cant charge a customer a fraction of a pence for one whole product. e.g. Product price is £29.17 customer gets 45% discount = £16.04 however Dear will invoice them £16.0435. If the customer orders 10 units the charge should be £160.40 however their invoice line total will be £160.4350 Please please provide a solution this has now been an issue for us since implementing Dear 3 years ago, we have now ran out of price tiers to solve this issue. Please escalate this.
Many thanks,
Cheryl
A much needed feature for many different accounts. Would help companies reduce errors that are caused by large decimals since they aren't needed by everyone
Agreed. This is the one single most frustrating part of DEAR. We are a distributor who publishes price lists to trade customers and when their discount is applied to the order line the calculated discounted price to many decimal points multiplies by the quantity to cause a price "error". E.g. if the item has a list price 2.22 and the discount is 33% then DEAR calculates the discounted price as 1.4874 and then, for a quantity of 1, rounds it up to 1.49 . However for a quantity of 100 DEAR totals it to 148.74 - not 149.00 . This means that our order entry people have to manually adjust the total price to match our published price. We need DEAR to calculate the unit discounted price to 2 decimal places - not 4.
Unfortunately the present way DEAR works makes DEAR unsuitable for distribution companies like us. I cannot type what my sales department regularly says about this!!!