NeilA's avatar
NeilA
Cover User
11 years ago
Status:
Done

Sales: Invoice rounding on unit price

Description: We are selling in units of each
with unit cost say.08112 and when printing the invoice it only shows a rounded
number where the extension is correct to the quantities sold but customers are
checking the price on the invoice and recalculating and reducing the invoice
value and short paying. I have had a couple of phone conversations with Myob help line and are told it cant be fixed ! Surely it can? as we sell everything
by each and the parts in cents. I don't really want to give money away and
understand the customers point of view but it is costing me money now can
someone look into it or someone suggest a soloution? I have put a comment on the invoices saying it rounds up
at point of invoicing but they still deduct and short pay. thanks Neil

 

"invoice rounding"

Inventory
Sales

29 Comments

Sort By
Show More
  • Bumper's avatar
    Bumper
    Partner
    11 years ago

    I think a good solution would be to have an option in Preferences for stock of how many decimal points you want to calculate to for your own business. Then it should be updated throughout the system (ie. when you enter a purchase, a stock adjustment, an invoice, build items) so that even if you use the calculator function, it still rounds it in the system to the number of decimal points you have specified.

  • Bumper's avatar
    Bumper
    Partner
    11 years ago

    More examples of wreaking havoc

     

    Items register is rounding the figure to 0.01

    stock2.png

     

     

    But when you go to invoice the figure out, you see that it is actually being rounded to 0.1. (see below)

     

    stock figure.png

     

     

  • MWilliames's avatar
    MWilliames
    Cover User
    11 years ago

    We need at least 3 decimal points please. It wasnt a problem with our previous version. Thanks

  • Bil's avatar
    Bil
    Experienced Cover User
    10 years ago

    The problem with MYOB rounding decimals to the nearest cent is a very anoying and important problem. We have been using MYOB software since Version 4. No prior version of MYOB had this issue. So the make you upgrade, charge you more money and then create new problems that didnt exist before. Just like buying petrol for 149.9 cents per litre, we sell small items for 15.8 cents and 19.9 cents. We might sell 10,000 or even 40,000 units to a customer so the difference is huge. The problem is that the prices appear correctly on our screen and internally in MYOB but the rounding only occurs when you PRINT the invoice and send it to a customer. They see the WRONG prices. MYOB--Shame on you. Fix this now. Dont tell me it can't be fixed. You created the error where it didnt exist before.

  • Steven_M's avatar
    Steven_M
    Former Staff
    10 years ago

    Hi Bil 

    Thank you for your feedback

    AccountRight 2015.1 does allow for the unit cost to be entered and printed in 4 decimal places like AccountRight Classic.  The Quantity column would still round to be 2 decimal places.

  • Bil's avatar
    Bil
    Experienced Cover User
    10 years ago

    Thank you Steve, but you didnt say HOW to cure the problem?!

     

    Please see this invoice: I enter the price as 19.9 cents and it calculates correctly but prints incorrectly as mentioned by others in this feed. RoundingCentsInvoiceMYOB.PNG)

     

     

     

  • Steven_M's avatar
    Steven_M
    Former Staff
    10 years ago

    Hi Bil 

    What version of the program are you using? This can be checked via Help>>About

    Also I assume you have entered that transactional line into AccountRight as 0.199

  • Bil's avatar
    Bil
    Experienced Cover User
    10 years ago

    Yes, Steve. I entered the price as 0.199. In our previous Premier v19 (and for ALL previous for the past 11 years) it has been correct. Only since we upgraded to AccountRight Live 8 months ago did this problem appear. Our current version is 2015.1.17.580. Are you able to correct our invoice template for us. I have tried removing and replacing the ex-price field.

  • Emile's avatar
    Emile
    Former Staff
    10 years ago

    Hi Bil 

     

    Could you please preview an invoice using one of the default MYOB forms to see if the price shows up to more than two decimals?

     

    If it does, could you please go to customise forms and open both your form and the default one, delete the table from your custom form and copy the table from the default form?

  • Bil's avatar
    Bil
    Experienced Cover User
    10 years ago
    I phoned MYOB Tech support on 26 Feb at 10:15. On hold for 47+ minutes. Issue: Item invoice rounding to cents instead of showing decimals of a cent when the invoice was printed. It showed and calculated correctly on the screen. But when you print and send to a client, the line item price displayed incorrectly rounded to 2 decimals. Ritika was helpful. The issue occurred with an item invoice template imported from Premier 19.10 into AccountRight cloud version. Ritika had me hide and redisplay the ex-price field. Did not resolve. She asked me to check a standard MYOB Plain Paper invoice. It worked correctly showing 4 decimals on the printed invoice. We gave up trying to fix the imported template. Instead I rebuilt my custom invoice from scratch using their plain paper item invoice as a template. It now works correctly.
     
    I spent more than 4 hours trying to trouble shoot this issue. It would have been much better if MYOB did two things: First create a support note clearly describing the problem and work-around. I checked Support Notes first and no mention was made. This would have saved me many hours wasted time, plus 47 minutes on hold and saved MYOB from an hour-long support call for a known issue?!
     
    Second, the template import tool in AccountRight should WARN users that a known glitch exists for items with fractions of a cent in the pricing and refer them to the Support Note. This would have been extremely helpful.
     
    I am disappointed MYOB was not more proactive on this simple, annoying issue. I know by looking at your forum that many customers are impacted by this same simple issue. 
     
    Thank you for your help. Please consider my two suggestions above.
     
    Thank you,
    Bil