Post

13 followers Follow
13
Avatar

Unit price to 3 decimal places then round sub total to 2 decimal places to export to Xero?

Hi

We tend to  purchase high volumes of low value components which are priced to 3 decimal places. Unfortunately Unleashed rounds the unit  value to 2 decimal places. As you can imagine on high volumes the rounding error can make a great difference in the total value. If unleashed could possibly use 3 decimal places then round the sub total to 2 d.p that would help us immensely as the export to Xero will match with the invoice from suppliers... Hope that makes sense!!

Paul Roling

Official comment

Avatar

Hi All,

Pricing has now been extended to 4 decimal places in Unleashed so all Sales, Purchases, Credits & Returns will support 4 decimal places in pricing. This will also push through into your accounting provider if they support it.

Sales/Support

Please sign in to leave a comment.

13 comments

0
Avatar

Thanks for your suggestion Paul.  Have you also suggested this to Xero?  the better solution would be for Xero to have more than two decimals so we can all have a perfect solution.

Matt 0 votes
0
Avatar

I'd like to see 4 decimal places because there are a number of businesses that could use the BOM/Production and use low value components to make products.  To avoid an issue with Xero the export could be for a quantity of one at the line total price.

Gavin Welsh 0 votes
0
Avatar

Does anyone have a workaround for this problem. It is holding up my first installation as the client needs to show 3 decimals on their purchase orders and sales. Is it something Unleashed are working on or leaving it in Xeros hands?

Jim Walker 0 votes
0
Avatar

We need this too... the 2 decimal places is causing our final amount to be out by 0.01 in a lot of cases

Nina Young 0 votes
0
Avatar

2 decimal places just doesn't cut it for purchasing when most of our suppliers use 3 and some use 4 decimal places. We are having to use pack sizes to minimise the differences but this creates a lot more work with bills of materials and selling units. 3 decimal places would be good, 4 would be great!

Gavin Barker 0 votes
0
Avatar

I have been thinking about this one... as we too would LOVE to have 4dp, rounding the fifth.  I am considering having this function available when Unleashed is run standalone from Xero.  This does mean you won't be able to have Xero integration, but you can have 4dp.

---  So you are fully informed, Xero calculates gst on a line by line basis.  This means that with 4dp in Unleashed and 2dp in Xero there will always be rounding errors.  The Xero API sends us a 'refusal to post rounding errors' to the lines.  

I can't give a timeframe on it yet, but I have heard from Xero that for them to do 4dp they would need to completely overhaul their engine which is not something they are planning to start doing this year.

Sales/Support 0 votes
0
Avatar

I have the same problem, one of our materials costs us 16.5p per unit. There is already a feature request in Xero  https://community.xero.com/business/discussion/51751/

Another option would be to allow purchases of boxes, i.e. we buy 2 boxes of 250 units each. If we were able to enter 2 boxes in the purchase order this would post to Xero fine and then still use single units in the bill of material or sales.

David 0 votes
0
Avatar

well thought through David! 

Your solution to this issue is something we are kicking around now.  will post more on multiple units soon

Matt 0 votes
0
Avatar

We had this same problem last week with receipt of 50k of screws where the unit price as less than a 10th of a cent.
As suggested by Gavin & Gavin, it would be good to have the purchase unit price to be 4 decimal places to cope with these very low price items.
In order to correct our stock on hand (in both Unleashed & Xero) we needed to receipt the goods of a value of 0.01 per unit and then perform a nil-Quantity stock adjustment to correct the value of the goods downwards.
This wouldn't have been so much a drama for a single line order, but we had multiple line items (and additional costs specific to one line) and had to perform mad maths to ensure correct amount was adjusted.

Also, surely when the "Default Purchase Price" & "Default Sell Price" go to 3 DPs wouldn't it be simple sense to allow the unit Price (on an order) to go to the same depth?

Ian Yang (ikeGPS) 0 votes
0
Avatar

A suggestion to this would be to allow conversion of UoM, currently there is only 1 UoM allowed and no conversion. if we can set conversion tables for UoM this would minimize this problem as we can use a bigger bundle. For example my UoM for purchasing is KG but I sell per G, I purchase it at 175 per KG but since I need to use the same unit for purchasing and selling I need to enter .175 in purchasing and it gets rounded up to .18

Superman 0 votes