Invoices - Increase Unit Price field to six decimal places
Ability to increase unit price field to six decimal places.
Purpose: To make users easier when they have to input unit price with lots of decimal numbers
-
Aamir Khan commented
Quantity section of the invoice, there are 4 decimal places. Increase the decimals to 6 decimal places
-
Tim Cockfield commented
Been said before but I'll say it again... when dealing with anything other than small numbers, 2 decimal places is a problem. Our solution at the moment is to enter a unit of one and manually calculate the price of all the units combined, but information is lost doing this because we can't readily see the number of units from the GL
-
Allen Bronton commented
I'm afraid you may be right. About 5 years ago I tried Xero and had this issue but there was no response so I changed to Microsoft Dynamics Business Central. BC is an outstanding system but for too complex for my needs. I returned to Xero because I forgot about this problem. Now, with great frustration I am trying to be patient and see if this gets solved or I'll have to find an alternative. I know QBO goes out to 5 or 6 dp but not a big fan of Intuit.
-
Charles Bradshaw-Smith commented
Hello Xero,
Are you reading this thread at all or are we wasting our time leaving constructive comments to help improve your product?
Pretty please respond.
-
Michael Hood commented
This has been an issue for many years - Xero have never shown any intention of implementing an increase beyond the current 4dp.
If you upload an invoice CSV file with 5dp on the unit price, then the invoice will correctly calculate amounts - BUT if you do any kind of change to that invoice (e.g. merely change the print template), then it will re-calculate but only with 4dp on the unit price. With large enough amounts this will lead to the VAT being incorrect.
One workaround (fiddly) is to change units (e.g. £/mWh rather than £/kWh) but then your quantity may require more than 4dp and so you'd be back at the start.
-
Allen Bronton commented
Many businesses like mine in the U.S. cannot use Xero because of this restriction. We price in basis points 1/100th of a percent which goes to 4 decimal places but then we bill quarterly so dividing by 4 causing the price to go to 6 decimal places. Currently, we have to manually calculate the total or migrate away to QBO if we want to automate the process.
-
Jon Marks commented
Please implement for sales, bills/purchase orders and product, inventory items.
When I want to process my production and reduce the quantity of the raw materials consumed in the production of a finished goods, the purchase unit price is to 7 decimal places as the items are stocked in g and purchased in kg. Rounding causes differences. I would also need the name decimal places for making product, inventory item adjustments when reducing the qty of each product and increasing the qty of the finished product that was produced. Currently this cost price is only 2 decimal places.
-
Jen Fellowes commented
Really hoping that this becomes a possibility as when dealing with large numbers, a few extra decimal places makes a huge difference in the accuracy of the billing!
Curious to know why it would be so hard to provide that option?
-
Charles Bradshaw-Smith commented
I have also raised a support case CX0013184989 for this and it has been passed to a specialist for further assistance.
Fingers crossed.
-
Charles Bradshaw-Smith commented
I strongly support this idea to stay within UK law!
I am importing energy invoices from a specialist app into Xero via a CSV file. I need UnitAmount to use 5dp. I wish I could reduce my UnitAmount to 4dp but I cannot legally. Energy in UK use tariffs that are quoted in pence per kWh to 3 decimal places. So in pounds (£) 5dp are required by the time the UnitAmount has been divided by 100. I do not want to be outside government regulations. If after import, I edit the draft invoice line and add back the 5th dp to UnitAmount, it correctly calculates the Total - so it can't be a big change to make please.
-
SIMON FRYER commented
This is very frustrating, I sell screws, when I create a part and price it at 0.124 (£12.40/100) the quote/order/invoice comes out at £0.12 (£12.00/100) this can be a considerable loss in some cases, we now have to manually put the price in to 3 decimal points !!!
-
PORNPAILIN KHULEE commented
I also support this idea. It would be great to increase the decimals more than 4 decimal places by automatically.
-
Alan Macdonald commented
There are many different scenarios where a unit price that is limited to four decimal places is too restrictive for bills and invoices.
For example, unit prices that have been converted from a foreign currency, share dividends and many others.
Why not make it unlimited?
-
Ross Stewart commented
This is somethng that is needed sooner reather than later, as we use a seperate CRM package that deals with products to 4 decimal places and when syncing the invoices across into Xero they come in with 2 decimal places and it causes grief to us and our clients
-
Edralyn Cabungcag commented
I support this idea. It would be great to increase the decimals up to 6 decimal places.
-
Charlotte Hinwood commented
This will allow me to reconcile share buys correctly without having to do a seperate line item for the difference.
-
Roger Coyles commented
Our POS system goes up to 7 decimal points so this information is lost when it integrates into Xero. The knock on effect is that all of our unit costs for supplier invoices are incorrect and need to be manually corrected in Xero.
-
Rodien van Zyl commented
Please implement this also in bills
-
Virgil Ierubino commented
Please allow arbitrary decimal precision on quantity, price and discount. There is no other way to ensure numbers come out correctly.