Hi MR Moatasim , To solve this problem Follow this steps: go to accounting-entitymodel.xml in datamodel folder , and in <entity entity-name="AcctgTransEntry" package-name="org.apache.ofbiz.accounting.ledger" title="Transaction Entry Entity"> change from <field name="amount" type="currency-amount"></field> <field name="origAmount" type="currency-amount"></field> Change To <field name="amount" type="currency-precise"></field> <field name="origAmount" type="currency-precise"></field>
in data type currency-precise the decimal = 3 in data type currency-amount the decimal = 2 To see all data type in ofbiz with DATABASE go to this path framework\entity\fieldtype . . Best Regards, Ahmad Rbab’ah Java Developer P.O.Box 3516 Amman, 11821 The Hashemite Kingdom of Jordan Tel. +962 (6) 556 2620 Mob (Jordan). +962 79 5077915 /biict @biict -----Original Message----- From: Moatasim Al Masri [mailto:[email protected]] Sent: Sunday, February 19, 2017 10:24 To: [email protected] Subject: RE: currency.decimal.format Thank you Rishi I changed arithmetic.properties, when I create purchase invoice AP its display in invoice search correct with 3 decimal , but in sales invoice AR still display in 2 decimal, also in sales & purchase invoice when posted, display in 2 decimal not 3 decimal !!! invoice.decimals = 3 invoice.SALES_INVOICE.decimals = 4 invoice.PURCHASE_INVOICE.decimals = 4 invoice.rounding = ROUND_HALF_UP Best Regards, Moatasim L. Al-Masri Program Manager -----Original Message----- From: Rishi Solanki [mailto:[email protected]] Sent: Friday, February 17, 2017 7:36 AM To: ofbizuser <[email protected]> Subject: Re: currency.decimal.format For invoices, please check arithmetic.properties file and change the invoice.decimals value. HTH! Rishi Solanki Sr. Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com On Thu, Feb 16, 2017 at 2:49 PM, Moatasim Al Masri <[email protected]> wrote: > Dears > > If I need to change the currency.decimal.format from 2 digits to 3 > digits in all ofbiz invoices etc.., so we should change it from > > *general.property* from currency.decimal.format=#,##0.00 > > To > currency.decimal.format=#,##0.000 > > And also change *UtilFormatOut.java* > > *From DecimalFormat(UtilProperties.getPropertyValue("general", > "currency.decimal.format", "#,##0.00"));* > > *To DecimalFormat(UtilProperties.getPropertyValue("general", > "currency.decimal.format", "#,##0.000"));* > > > > I changed it but unfortunately not applied on when create invoices, is > there missing extra step ? > > > > *Best Regards,* > > > > *Moatasim L. Al-Masri* > > Program Manager > > > > [image: Description: Logo for Office-4] > > > > [image: Description: bi email-3-02] > > > > P.O.Box 3516 Amman, 11821 > > The Hashemite Kingdom of Jordan > > *Tel.* +962 (6) 556 2620 > > *Mob (Jordan).* +962 79 5426384 > > [image: Description: bi email-3-04] > > [image: Description: bi email-3-05] > > /biict > > @biict > > Kingdom of Saudi Arabia > > *Mob (KSA).* +966 55 7885607 > > > > > > > > >
