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:p...@cohsoft.com.au] Sent: Saturday, December 23, 2017 7:36 PM To: user@ofbiz.apache.org 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 <tboy...@electroswitch.com> 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: i...@coherentsoftware.com.au
