Product price rounding

Donate to this project

Development Project Status: Completed

Total cost estimate (ex-Tax): 
Due date for completion of this stage: 
Current Percentage Funded: 
Project funding: 

You can donate money to this project by entering the amount above and clicking the 'Add to cart' button. In the Checkout process you can either choose to pay now (via Bank Transfer, Cheque or Pay Pal) or you can pledge the amount by choosing the 'Pledge a payment for a Development Project' method. If you make a pledge, then when we have 100% funding commitments, you will be notified by email and you can then action your payment. Note that development will not commence until all funds are received.

Project description: 

In countries that have a low-value currency, it is standard practice to set the product's price (i.e. selling price) in round dollars.  For these environments, one needs the system to round any automatically calculated prices.

This project will add a 'Round Product Price to' field to the Currency screen. This will round prices to the specified amount. By default this will be set to $0.01. 

If this is set to say $1.00 then automatically calculated prices will be rounded to the nearest dollar. If it was set to $0.20 they would be rounded to the nearest 20 cents.

The Product Price Rounding will apply to both fixed and unit prices.

Prices will only be rounded when:

a) editing a product, and the product's markup or cost price are updated and the product's price is recalculated; or

b) Auto Price Update is set and a delivery is finalised which contains an updated Supplier List Price. [This will update the cost price to the list price, and calculate a new rounded unit price.]


Rounding will not occur if:

  • the Import facility is used to update a price
  • the price is entered during charging or estimating




Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Selling price rounding

Sounds reasonable. Can it be called 'Product Price' rather than 'Sell Price' though?

Re: Selling price rounding

Done - updated project description and name.  Regards, Tim G

Re: Selling price rounding

One consequence of this change would be that the markup needs to be recalculated after determining the rounded unit price.

So if you edit a products unit price, and change the markup, the unit price will be recalculated, and then the markup recalculated again.

Re: Selling price rounding

Tim - I do not see this as a problem.  Let us say the cost is $HKG 320.87 and our 'standard' markup is 80%.  This gives an unrounded sell price of $HKG 577.566, which (with dollar rounding) gives $HKG 578.00 - and the markup gets adjusted to 80.1353 when when rounded to 2 digits gets set to 80.14

So our markups will hover around the 'standard' setting that we input.

Now we get a delivery and the cost price goes to $329.45, so with a markup of 80.14% the unrounded sell price is $593.4712, and gets rounded to $593 and the markup gets adjusted to 0.79997 rounded to 80.00%.

So in this case the markup returns to our 'standard' value, but in general it will continue to hover around our standard value.

As long as we document the behaviour, I do not see a problem.

Regards, Tim G

PS I checked with the practice manager - she agrees with me  - not a problem.

Re: Selling price rounding

Any reason you don't want fixed prices to be updated in the same way when editing products?

Re: Selling price rounding

Tim - you are correct.  There is no logical reason why the fixed prices should not be subject to the same rounding.  That is although the fixed prices are never affected by any auto update on a delivery, it would be logical to have the same thing apply when editing - ie if you change the markup and/or cost then the price is re-calculated, and roounded, and the markup recalculated.

Hence the project description needs to be adjusted to include editing of fixed prices and to remove the exclusion of fixed prices.

Regards, Tim G


Syndicate content