RE: currency.decimal.format
Hi MR Moatasim ,
To solve this problem Follow this steps:
go to accounting-entitymodel.xml in datamodel folder , and in
change from
Change To
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:malma...@bi-bst.com]
Sent: Sunday, February 19, 2017 10:24
To: user@ofbiz.apache.org
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:rishisolan...@gmail.com]
Sent: Friday, February 17, 2017 7:36 AM
To: ofbizuser
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
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
>
>
>
>
>
>
>
>
>
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:rishisolan...@gmail.com]
Sent: Friday, February 17, 2017 7:36 AM
To: ofbizuser
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
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
>
>
>
>
>
>
>
>
>
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
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
>
>
>
>
>
>
>
>
>
Re: currency.decimal.format
Hi Moatasim,
The format in the UtilFormatOut code is a default if the property can't be
found, so use the property and don't change the code.
In your invoices, is the problem the presentation on the screen or when you
create a PDF?
Cheers
Paul Foxworthy
On 16 February 2017 at 20:19, Moatasim Al Masri 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 <+966%2055%20788%205607>
>
>
>
>
>
>
>
>
>
--
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
currency.decimal.format
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
[Description: Logo for Office-4]
[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
[Description: bi email-3-04]
[Description: bi email-3-05]
/biict
@biict
Kingdom of Saudi Arabia
Mob (KSA).+966 55 7885607
