RE: decimal places

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Rishi Solanki]

Dear James,
If you have set the arithmatic.properties file then note that, the file
values can be override by db value. Please check your SystemProperty entity
data, and check for arithmatic properties.

Best Regards,
--
*Rishi Solanki* | Sr Manager, Enterprise Software Development
HotWax Systems <http://www.hotwaxsystems.com/>
Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore,
M.P 452010
Linkedin: *Rishi Solanki*
<https://www.linkedin.com/in/rishi-solanki-62271b7/>
Direct: [phone]


On Tue, Apr 30, 2019 at 5:33 PM <[hidden email]> wrote:

> I looked at the both of the areas below but we are still not getting 5
> decimal places on the catalog price list, purchase order unit
> price/total price, sales order unit price/total price , inventory item
> ID unit price, vendor invoice unit price/total price and sales invoice
> unit price/total price.  I would have to imagine several companies would
> have this requirement as the decimal places can make a major
> differences.  Is there anywhere else in the system where I can update
> the decimal places?  Any help is much appreciated
>
> Thanks,
>
> James
>
> -------- Original Message --------
> Subject: Re: decimal places
> From: Ankush Upadhyay <[hidden email]>
> Date: Thu, April 11, 2019 8:15 pm
> To: [hidden email]
>
> Hello James,
> Please check arithmatic.properties and UtilNumber.java.
> Thanks
> --
> Ankush Upadhyay
>
>
> On Fri, Apr 12, 2019 at 7:00 AM <[hidden email]> wrote:
>
> > Is there a setting in Ofbiz to increase the decimal points on all prices
> > in Ofbiz? We need at least 4-5 decimal points. Any help is much
> > appreciated.
> >
> > Thanks,
> >
> > James
> >
>

[Deepak Dixit-4]

Hi James,

You need to update the database field type, as right now most of the
mentioned fields are suing the currency-precise as field type and as per
configuration, it's having only 3 decimal places.

Please update the filedtype*.xml file as needed, you need to run alter the
query to update existing table field type.
Kind Regards,


Deepak Dixit
DIRECTOR OF PRODUCT ENGINEERING
mobile: [phone]
email: [hidden email]
*www.hotwax.co <http://www.hotwax.co/>*


On Tue, Apr 30, 2019 at 5:33 PM <[hidden email]> wrote:

> I looked at the both of the areas below but we are still not getting 5
> decimal places on the catalog price list, purchase order unit
> price/total price, sales order unit price/total price , inventory item
> ID unit price, vendor invoice unit price/total price and sales invoice
> unit price/total price.  I would have to imagine several companies would
> have this requirement as the decimal places can make a major
> differences.  Is there anywhere else in the system where I can update
> the decimal places?  Any help is much appreciated
>
> Thanks,
>
> James
>
> -------- Original Message --------
> Subject: Re: decimal places
> From: Ankush Upadhyay <[hidden email]>
> Date: Thu, April 11, 2019 8:15 pm
> To: [hidden email]
>
> Hello James,
> Please check arithmatic.properties and UtilNumber.java.
> Thanks
> --
> Ankush Upadhyay
>
>
> On Fri, Apr 12, 2019 at 7:00 AM <[hidden email]> wrote:
>
> > Is there a setting in Ofbiz to increase the decimal points on all prices
> > in Ofbiz? We need at least 4-5 decimal points. Any help is much
> > appreciated.
> >
> > Thanks,
> >
> > James
> >
>