Hi Tim, Thanks for your feedback.
I am curious what you would use the unit price for. Do you order your washers in quantities of thousands, and might the price vary if you ordered in quantities like 10,000 or 100,000? So acquisition price might depend on quantity ordered. If you are calculating cost price for a manufactured product, the prices for washers might be imprecise but that's unlikely to be most significant contributor to the cost price. What am I missing? Thanks Paul Foxworthy On 24 December 2017 at 22:42, Boyden, Timothy <[email protected]> wrote: > The issue that I had was that the underlying field would not accept a > value of 0.00590. I had to enter the value as a lot of 10000, to get the > price to 59.00, before it would accept the value. If I read the first link > correctly, that is referring to display format, and not validation of the > field input, or the size of fields. Looking at the table spec, indeed the > LAST_PRICE field of SUPPLIER_PRODUCT is only a decimal field with 3 decimal > place precision. It should be at least 5. All price fields should be at > least 5 decimal place precision. > > -Tim > > -----Original Message----- > From: Paul Foxworthy [mailto:[email protected]] > Sent: Saturday, December 23, 2017 7:36 PM > To: [email protected] > Subject: Re: Add Product Supplier broken - similar to Edit Facility bug > > Hi Tim, > > Decimal places are configurable for many things in OFBiz - see > https://github.com/apache/ofbiz/blob/trunk/applications/ > accounting/config/arithmetic.properties#L24 > and below. > > I can see product pricing should be configurable too. In > https://issues.apache.org/jira/browse/OFBIZ-6436, Ingo Wolfmayer was > proposing adding a similar thing for prices. > > Cheers > > Paul Foxworthy > > > On 24 December 2017 at 08:02, Boyden, Timothy <[email protected]> > wrote: > > > Also, it looks like the Last Purchase Price field doesn't accept 5 > > digit decimal places. Major bad for a manufacturing system. A steel > > washer, priced per each, would be like $0.00590 USD. Similarly, > > precious metals, like silver for silver plating, would be ordered in > 5-digit decimal ounces. > > That needs to get fixed. > > > > Thanks, > > > > Tim > > > > > > -- > Coherent Software Australia Pty Ltd > PO Box 2773 > Cheltenham Vic 3192 > Australia > > Phone: +61 3 9585 6788 > Web: http://www.coherentsoftware.com.au/ > Email: [email protected] > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
