decimal places on quotes

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Conversion of quotes to invoices and decimal places need to change. I raise a quote with an exact price out to 2 decimal places but when the quantities are entered it alters the rate sometimes out to 5 decimal places. It needs to be exactly as entered the first time and not alter it at all so when converted to an invoice you don't have to adjust rates and potential do a rounding back to the quotation amount so you are back to a reasonable 2 decimal places to your customers. It looks crappy and unprofessional to go any more than 2 decimal places on a quote and even worse on an invoice. Please resolve this issue that is long overdue for a fix.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Matt,

Could you please let us know which program you're using so we can test this scenario? I haven't heard of this occurring before.

Luke.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Using Premier Contractor edition Luke. A simple example is if I raise a quote and have a product that is sold by the m2 and its m2 rate is $7.60 + gst. I set the rate at $7.60 + gst then add in the quantities of how many m2 are required. What it then does is change it from $7.60 + gst to $7.6013 as an example. This then also becomes the default rate for the invoice once converted instead of $7.60 as typed in to begin with. It is extremely frustrating and time consuming to rectify as you have to then tweak the %'s back and work out via a calculator what the end price needs to be. Very time wasting. 
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Matt,

I still cannot replicate this.

Can you please confirm the below for me:
1. Go into the item's setup and check whether the box 'Amts include tax' is ticked or unticked?
2. When you're creating the estimate is the box 'Amounts include tax' ticked or unticked?

Luke.
(Edited)
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
In items set up the "Amounts Include tax" is unticked. When creating the estimate the "Amounts Incldue Tax" box is also unticked.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
If I could upload pics, I could take some snapshots and send them through.
Photo of Rav

Rav, Community Manager

  • 64,284 Points 50k badge 2x thumb
Hi Matt,

You can upload images using the camera icon in the reply box.

Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Another way of explaining what it does Luke is as follows:
I have an item that has a cost of $7.59 + gst. The sell price of this item is $11.50 + gst. The markup is 51.52%. When I add the quantities, lets say 252 for arguments sake the price should be 252 x $11.50 + gst correct? It never is. 252 x $11.5 = $2898.00 + gst. The system gives me a price on the quote of $2898.09 + gst, $0.09 more than it should be. If I then convert that quote to an invoice instead of charging $11.50 for that product it invoices it at $11.50125 etc, just guessing on the actual invoice amount as I am just using this as an example.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
When I have started this quote with a sell price of $11.50 for the sell price, why does it give me $2898.09 as a sell price when it should be $2898.00?
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
This is my starting figure, yet it multiplies it incorrectly.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
The mark up % at the start needs to be more precise as it is more like 51.515% (3 decimal places) not 2 to multiply the final figure on bigger quantities.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
For even bigger quantities the % goes out to 4 decimal places to be accurate. A quantity of 750 is 51.5151% mark up. This is what I am trying to say. The mark up % needs to be adjusted to more decimal places than 2 so it is more accurate.
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Matt,

When I first enter the item in the estimate, the markup is not 51.52%. Are you manually changing this?

This is how I set the item up:




If I then add this item into an estimate with a quantity of 1, the markup is 51.51515%:




If I then change the quantity to 252, the markup remains the same and it gives the total price as $2898.00 which is what you were expecting?




You can click on the images to enlarge them.

Luke.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Hi Luke, the issue is I am changing the sell price for every customer as you guys dont have customer specific pricing. So that product might have a standard sell price of $13.00 + gst and it is changed to specific pricing we have for various customers. Usually changed down from the retail rate. When you do that, it works it back to 2 decimal places only and every time it must be adjusted manually.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
I know you have % markups but this does not work for the way we price our customers as some products are marked up more than others so we cannot use a flat % mark up for any of our customers and we have over 200 customers. 
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Matt,

Thank you for that extra information. This makes more sense now. 

Have you looked into setting up price levels per item instead of a fixed %? E.g. You can set particular items to be set at a certain price for certain customers.

Apart from that, unfortunately, for your scenario there's nothing else that can be done except for manually changing the amounts.

Luke.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Manually changing the amounts is what we have been doing since we started using reckon (Quickbooks) over 10 years ago. I would be interested to know how we can set an individual product at a specific price for a specific customer though. I was unaware that we could do that.
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Matt,

This will be setup in the following way:
1. Go to Lists > Price Level List
2. Click 'Price Level' (bottom left-hand corner) > New
3. Price Level Name > enter a name
4. Price Level Type > select 'Per Item'
5. Type in a Custom Price for each relevant item > click OK
6. Go inside the customer's record > 'Additional Info' tab > 'Price Level' field > select the price level setup.

I hope this helps.

Luke.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Helps, are you kidding. You are a legend. Do you know how many of your techs I have spoken to over the years trying to work out how to achieve exactly what you just sent me? I have already tested it for 1 customer and it is exactly what I have been wanting for years. How long has this been part of reckon? If you tell me always I am likely to try and reach down the internet line and strangle half of your techs. You have solved a massive problem that has been very time consuming for years and we just accepted it. Whilst you just gave my wife a months work, it will save countless hours once set up. Thanks again Luke.
Photo of Luke

Luke, Technical Support Team Leader

  • 3,674 Points 3k badge 2x thumb
Hi Matt,

This feature has been around for a good ten years or so. I'm so sorry one of our technicians hasn't been able to suggest or help you with setting this up in the past but I'm glad it's now going to help you moving forward :)

Have a great afternoon.

Luke.
Photo of Matt Bonnici

Matt Bonnici

  • 120 Points 100 badge 2x thumb
Thanks Luke. It will be a massive time saver. Wish I had been able to speak with a tech that understood what I required. Glad I stumbled onto you though. Thanks again. What makes me laugh more though is my accountant has charged me a couple of hundred via his supposed Reckon expert to see what she could find out regarding if it was within reckons capabilities, only to be told we could not do customer specific pricing. That was only 12 months ago. I will be having words with my accountant you can be sure.