OFBiz › OFBiz - User

currency.decimal.format

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

9 messages Options

Moatasim Al Masri

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

P.O.Box 3516 Amman, 11821 The Hashemite Kingdom of Jordan	Tel. +962 (6) 556 2620 Mob (Jordan). +962 79 5426384	/biict @biict
Kingdom of Saudi Arabia	Mob (KSA). +966 55 7885607

Paul Foxworthy

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 <[hidden email]> 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: [hidden email]

--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

Rishi Solanki

Re: currency.decimal.format

In reply to this post by Moatasim Al Masri

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 <[hidden email]>
wrote:

Alfonso Barreto

Purchase problem

When I try to create a purchase order, got this error on the log:
No tag configuration found for organization [Company]PRCH_ORDER_IT
Will appreciate any ideas.
Many helps

Ashish Vijaywargiya-4

Re: Purchase problem

Can you please share the code base details? Are you using trunk or any of
the release branch?

--
Kind Regards
Ashish Vijaywargiya
HotWax Systems - est. 1997 <http://www.hotwaxsystems.com/>

On Fri, Feb 17, 2017 at 11:46 AM, Alfonso Barreto <[hidden email]>
wrote:

> When I try to create a purchase order, got this error on the log:
> No tag configuration found for organization [Company]PRCH_ORDER_IT
> Will appreciate any ideas.
> Many helps
>

Alfonso Barreto

Re: Purchase problem

Yes, many thanks, using opentaps 1.5.0

From: Ashish Vijaywargiya <[hidden email]>
To: [hidden email]; Alfonso Barreto <[hidden email]>
Sent: Friday, February 17, 2017 12:32 AM
Subject: Re: Purchase problem

Can you please share the code base details? Are you using trunk or any of the release branch?
--Kind Regards
Ashish Vijaywargiya
HotWax Systems - est. 1997

On Fri, Feb 17, 2017 at 11:46 AM, Alfonso Barreto <[hidden email]> wrote:

When I try to create a purchase order, got this error on the log:
No tag configuration found for organization [Company]PRCH_ORDER_IT
Will appreciate any ideas.
Many helps

Rishi Solanki

Re: Purchase problem

Opentaps will have different code version that of OFBiz and different
mailing list. The error you have shared will never display with OFBiz as
this is not an defined error of OFBiz.

You should ask your question to Opentaps forum. Also it seems your error is
related to some missing data while setting up your company. After fixing
the data it should work.

HTH!

Rishi Solanki
Sr. Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Fri, Feb 17, 2017 at 12:44 PM, Alfonso Barreto <[hidden email]>
wrote:

> Yes, many thanks, using opentaps 1.5.0
>
> From: Ashish Vijaywargiya <[hidden email]>
> To: [hidden email]; Alfonso Barreto <[hidden email]>
> Sent: Friday, February 17, 2017 12:32 AM
> Subject: Re: Purchase problem
>
> Can you please share the code base details? Are you using trunk or any of
> the release branch?
> --Kind Regards
> Ashish Vijaywargiya
> HotWax Systems - est. 1997
>
> On Fri, Feb 17, 2017 at 11:46 AM, Alfonso Barreto <[hidden email]>
> wrote:
>
> When I try to create a purchase order, got this error on the log:
> No tag configuration found for organization [Company]PRCH_ORDER_IT
> Will appreciate any ideas.
> Many helps
>
>
>
>
>
>

Moatasim Al Masri

RE: currency.decimal.format

In reply to this post by Rishi Solanki

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:[hidden email]]
Sent: Friday, February 17, 2017 7:36 AM
To: ofbizuser <[hidden email]>
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 <[hidden email]>
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
>
>
>
>
>
>
>
>
>

Ahmad Rabab’ah

RE: currency.decimal.format

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:[hidden email]]
Sent: Sunday, February 19, 2017 10:24
To: [hidden email]
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:[hidden email]]
Sent: Friday, February 17, 2017 7:36 AM
To: ofbizuser <[hidden email]>
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 <[hidden email]>
wrote: