Re: Need Help - BOM with decimals

[Pierre Smits]

Hi James, all


This was ready and available upto branches 15.12 of OFBiz, as I have
frequently implemented it for craft breweries where recipes for beer and
for bottling the beer. OOTB there is a limitation of (showing) 4 digits
behind the decimal point shown in a BoM.

The key issue is the proportions of the ingredients to produce 1 standard
measure of your product. That is the BoM and the basis for each Production
Run in OFBiz.

In one of our example recipes for 1 hectoliter of beer we have the
following - imaginary - ingredients in our BoM:
100 liters of water + 15 % for evaporation (scrap percentage)
20 kilograms of mats
200 grams of hops
1 pack of yeast (starter).

And our BoM for 1 bottle (33 cL) of beer (see attached screenshot:
1 bottle
0.0033 hectoliter of beer
1 cap

The way to get it working is setting up your manufacturable products and
components/ingredients set up properly. It is important to set the -
default - quantityUomId on the first screen of the product. The other
measure definitions are not used - as far as I can tell - not used in the
manufacturing functions.

I trust the above helps.

Best regards,

*Pierre Smits*

Apache Trafodion , Vice President
Apache Directory , PMC Member
Apache Incubator , committer
Apache OFBiz , contributor since 2008
Apache Steve , committer

On Mon, Aug 6, 2018 at 9:29 AM,  wrote:

>
> Team - How have you handled in the past a BOM that is a formula and uses
> fractions of inventory.  Let's say we inventory mix in gallons but to
> make 1 bottle of the mix it requires .00983 of a gallon?  It seems ofbiz
> doesnt handle decimals in BOM.  How have you handled this in the past?
>
> Thanks,
>
> James
>

Re: Need Help - BOM with decimals

[Rishi Solanki]

Yes exactly, but as it is not currently supported in the process so you
have free hand to achieve the things as per requirement.
Also some generic solution welcome to the community.  :-)

Community, is there any other options we can workout then please suggest.

Thanks!





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

On Tue, Aug 7, 2018 at 7:11 PM,  wrote:

> Rishi - Lets use your example.
> Lets say the component product is defined as 1 and the
> product.quantityincluded is .00983
>
> If I was making 200 of the produced product will Ofbiz calculate .00983
> * 200 = 1.966 so it would actually request 2 gallons on the production
> process.  Is that correct?
>
>  Original Message ----
> Subject: Re: Need Help - BOM with decimals
> From: Rishi Solanki 
> Date: Mon, August 06, 2018 11:40 pm
> To: ofbizuser 
>
> Deepak,
> You are correct, that is not used in the manufacturing. But it is not
> useful for manufacturing as well.
>
> James,
> What I'm suggesting is to use the integer part quantity as is in the BOM
> to
> create new product. I took the product weight example, but for your
> exact
> case you may need to check the Product.quantityUomId and
> Product.quantityIncluded. Here your component product may define that 1
> quantity means gallon and included 0.00983 gallons.
>
> I hope I'm clear this time. I think this should be good way to go with
> and
> will have very minor code customization.
>
> Regards,
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Tue, Aug 7, 2018 at 10:25 AM, Deepak Dixit 
> wrote:
>
> > Hi James,
> >
> > We have Product.orderDecimalQuantity, we can use this if we want to use
> > product as decimal quantity. But I think this is not used in
> > manufacturing code.
> >
> > Thanks & Regards
> > --
> > Deepak Dixit
> >
> >
> > On Mon, Aug 6, 2018 at 5:28 PM,  wrote:
> >
> > >
> > > Thanks Rishi - By using decimal in its weight how will that update the
> > > required quantity in BOM? Anyone else in the community have come into
> > > this issue and updated BOM to accept decimals. I would imagine this is
> > > very common on process manufacturing
> > >
> > >  Original Message 
> > > Subject: Re: Need Help - BOM with decimals
> > > From: Rishi Solanki 
> > > Date: Mon, August 06, 2018 2:41 am
> > > To: ofbizuser 
> > >
> > > James,
> > >
> > > This is tricky, and you can not see if this is directly available OOTB.
> > > But
> > > the trick will surely work ootb. Please follow the following steps;
> > > - Create a manufacturing product in the system. We call it as MP_01
> > > - Lets say add two manufacturing component (raw material) with it. Name
> > > them as MC_A and MC_B for easy reference.
> > > - Each component will have 1 quantity of its own to create the MP_01.
> > > That
> > > mean 1 * MC_A + 1 * MC_B = MP_01.
> > > - Now set the product weight of both (MC_A and MC_B) for both items in
> > > decimal and use its quantity as per requirement in the MP_01 product
> > > associations.
> > >
> > > Hopefully, with minor or negligible changes in code you should be able
> > > to
> > > achieve decimal functionality. Alternatively, you can go for
> > > customization
> > > which may include some additional fields to work on in product or
> > > product
> > > assoc entity to incorporate the decimal support in BOM.
> > >
> > > As far as I remember there is no direct way to BOM with decimal, good
> to
> > > know if someone from community already know or did this in past.
> > >
> > >
> > > Thanks!
> > >
> > >
> > > --
> > > Rishi
> > >
> > >
> > >
> > >
> > >
> > >
> > > Rishi Solanki
> > > Sr Manager, Enterprise Software Development
> > > HotWax Systems Pvt. Ltd.
> > > Direct: +91-9893287847
> > > http://www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Mon, Aug 6, 2018 at 12:59 PM,  wrote:
> > >
> > > >
> > > > Team - How have you handled in the past a BOM that is a formula and
> > uses
> > > > fractions of inventory. Let's say we inventory mix in gallons but to
> > > > make 1 bottle of the mix it requires .00983 of a gallon? It seems
> ofbiz
> > > > doesnt handle decimals in BOM. How have you handled this in the past?
> > > >
> > > > Thanks,
> > > >
> > > > James
> > > >
> > >
> >
>

RE: Need Help - BOM with decimals

[james]

Rishi - Lets use your example.
Lets say the component product is defined as 1 and the
product.quantityincluded is .00983

If I was making 200 of the produced product will Ofbiz calculate .00983
* 200 = 1.966 so it would actually request 2 gallons on the production
process.  Is that correct?

 Original Message 
Subject: Re: Need Help - BOM with decimals
From: Rishi Solanki 
Date: Mon, August 06, 2018 11:40 pm
To: ofbizuser 

Deepak,
You are correct, that is not used in the manufacturing. But it is not
useful for manufacturing as well.

James,
What I'm suggesting is to use the integer part quantity as is in the BOM
to
create new product. I took the product weight example, but for your
exact
case you may need to check the Product.quantityUomId and
Product.quantityIncluded. Here your component product may define that 1
quantity means gallon and included 0.00983 gallons.

I hope I'm clear this time. I think this should be good way to go with
and
will have very minor code customization.

Regards,



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

On Tue, Aug 7, 2018 at 10:25 AM, Deepak Dixit 
wrote:

> Hi James,
>
> We have Product.orderDecimalQuantity, we can use this if we want to use
> product as decimal quantity. But I think this is not used in
> manufacturing code.
>
> Thanks & Regards
> --
> Deepak Dixit
>
>
> On Mon, Aug 6, 2018 at 5:28 PM,  wrote:
>
> >
> > Thanks Rishi - By using decimal in its weight how will that update the
> > required quantity in BOM? Anyone else in the community have come into
> > this issue and updated BOM to accept decimals. I would imagine this is
> > very common on process manufacturing
> >
> >  Original Message 
> > Subject: Re: Need Help - BOM with decimals
> > From: Rishi Solanki 
> > Date: Mon, August 06, 2018 2:41 am
> > To: ofbizuser 
> >
> > James,
> >
> > This is tricky, and you can not see if this is directly available OOTB.
> > But
> > the trick will surely work ootb. Please follow the following steps;
> > - Create a manufacturing product in the system. We call it as MP_01
> > - Lets say add two manufacturing component (raw material) with it. Name
> > them as MC_A and MC_B for easy reference.
> > - Each component will have 1 quantity of its own to create the MP_01.
> > That
> > mean 1 * MC_A + 1 * MC_B = MP_01.
> > - Now set the product weight of both (MC_A and MC_B) for both items in
> > decimal and use its quantity as per requirement in the MP_01 product
> > associations.
> >
> > Hopefully, with minor or negligible changes in code you should be able
> > to
> > achieve decimal functionality. Alternatively, you can go for
> > customization
> > which may include some additional fields to work on in product or
> > product
> > assoc entity to incorporate the decimal support in BOM.
> >
> > As far as I remember there is no direct way to BOM with decimal, good to
> > know if someone from community already know or did this in past.
> >
> >
> > Thanks!
> >
> >
> > --
> > Rishi
> >
> >
> >
> >
> >
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Mon, Aug 6, 2018 at 12:59 PM,  wrote:
> >
> > >
> > > Team - How have you handled in the past a BOM that is a formula and
> uses
> > > fractions of inventory. Let's say we inventory mix in gallons but to
> > > make 1 bottle of the mix it requires .00983 of a gallon? It seems ofbiz
> > > doesnt handle decimals in BOM. How have you handled this in the past?
> > >
> > > Thanks,
> > >
> > > James
> > >
> >
>

Re: Need Help - BOM with decimals

[Rishi Solanki]

Deepak,
You are correct, that is not used in the manufacturing. But it is not
useful for manufacturing as well.

James,
What I'm suggesting is to use the integer part quantity as is in the BOM to
create new product. I took the product weight example, but for your exact
case you may need to check the Product.quantityUomId and
Product.quantityIncluded. Here your component product may define that 1
quantity means gallon and included 0.00983 gallons.

I hope I'm clear this time. I think this should be good way to go with and
will have very minor code customization.

Regards,



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

On Tue, Aug 7, 2018 at 10:25 AM, Deepak Dixit 
wrote:

> Hi James,
>
> We have Product.orderDecimalQuantity, we can use this if we want to use
> product as decimal quantity.  But I think this is not used in
> manufacturing  code.
>
> Thanks & Regards
> --
> Deepak Dixit
>
>
> On Mon, Aug 6, 2018 at 5:28 PM,  wrote:
>
> >
> > Thanks Rishi - By using decimal in its weight how will that update the
> > required quantity in BOM?  Anyone else in the community have come into
> > this issue and updated BOM to accept decimals.  I would imagine this is
> > very common on process manufacturing
> >
> >  Original Message 
> > Subject: Re: Need Help - BOM with decimals
> > From: Rishi Solanki 
> > Date: Mon, August 06, 2018 2:41 am
> > To: ofbizuser 
> >
> > James,
> >
> > This is tricky, and you can not see if this is directly available OOTB.
> > But
> > the trick will surely work ootb. Please follow the following steps;
> > - Create a manufacturing product in the system. We call it as MP_01
> > - Lets say add two manufacturing component (raw material) with it. Name
> > them as MC_A and MC_B for easy reference.
> > - Each component will have 1 quantity of its own to create the MP_01.
> > That
> > mean 1 * MC_A + 1 * MC_B = MP_01.
> > - Now set the product weight of both (MC_A and MC_B) for both items in
> > decimal and use its quantity as per requirement in the MP_01 product
> > associations.
> >
> > Hopefully, with minor or negligible changes in code you should be able
> > to
> > achieve decimal functionality. Alternatively, you can go for
> > customization
> > which may include some additional fields to work on in product or
> > product
> > assoc entity to incorporate the decimal support in BOM.
> >
> > As far as I remember there is no direct way to BOM with decimal, good to
> > know if someone from community already know or did this in past.
> >
> >
> > Thanks!
> >
> >
> > --
> > Rishi
> >
> >
> >
> >
> >
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Mon, Aug 6, 2018 at 12:59 PM,  wrote:
> >
> > >
> > > Team - How have you handled in the past a BOM that is a formula and
> uses
> > > fractions of inventory. Let's say we inventory mix in gallons but to
> > > make 1 bottle of the mix it requires .00983 of a gallon? It seems ofbiz
> > > doesnt handle decimals in BOM. How have you handled this in the past?
> > >
> > > Thanks,
> > >
> > > James
> > >
> >
>

Re: Need Help - BOM with decimals

[Deepak Dixit]

Hi James,

We have Product.orderDecimalQuantity, we can use this if we want to use
product as decimal quantity.  But I think this is not used in
manufacturing  code.

Thanks & Regards
--
Deepak Dixit


On Mon, Aug 6, 2018 at 5:28 PM,  wrote:

>
> Thanks Rishi - By using decimal in its weight how will that update the
> required quantity in BOM?  Anyone else in the community have come into
> this issue and updated BOM to accept decimals.  I would imagine this is
> very common on process manufacturing
>
>  Original Message ----
> Subject: Re: Need Help - BOM with decimals
> From: Rishi Solanki 
> Date: Mon, August 06, 2018 2:41 am
> To: ofbizuser 
>
> James,
>
> This is tricky, and you can not see if this is directly available OOTB.
> But
> the trick will surely work ootb. Please follow the following steps;
> - Create a manufacturing product in the system. We call it as MP_01
> - Lets say add two manufacturing component (raw material) with it. Name
> them as MC_A and MC_B for easy reference.
> - Each component will have 1 quantity of its own to create the MP_01.
> That
> mean 1 * MC_A + 1 * MC_B = MP_01.
> - Now set the product weight of both (MC_A and MC_B) for both items in
> decimal and use its quantity as per requirement in the MP_01 product
> associations.
>
> Hopefully, with minor or negligible changes in code you should be able
> to
> achieve decimal functionality. Alternatively, you can go for
> customization
> which may include some additional fields to work on in product or
> product
> assoc entity to incorporate the decimal support in BOM.
>
> As far as I remember there is no direct way to BOM with decimal, good to
> know if someone from community already know or did this in past.
>
>
> Thanks!
>
>
> --
> Rishi
>
>
>
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Mon, Aug 6, 2018 at 12:59 PM,  wrote:
>
> >
> > Team - How have you handled in the past a BOM that is a formula and uses
> > fractions of inventory. Let's say we inventory mix in gallons but to
> > make 1 bottle of the mix it requires .00983 of a gallon? It seems ofbiz
> > doesnt handle decimals in BOM. How have you handled this in the past?
> >
> > Thanks,
> >
> > James
> >
>

RE: Need Help - BOM with decimals

[james]

Thanks Rishi - By using decimal in its weight how will that update the
required quantity in BOM?  Anyone else in the community have come into
this issue and updated BOM to accept decimals.  I would imagine this is
very common on process manufacturing

 Original Message 
Subject: Re: Need Help - BOM with decimals
From: Rishi Solanki 
Date: Mon, August 06, 2018 2:41 am
To: ofbizuser 

James,

This is tricky, and you can not see if this is directly available OOTB.
But
the trick will surely work ootb. Please follow the following steps;
- Create a manufacturing product in the system. We call it as MP_01
- Lets say add two manufacturing component (raw material) with it. Name
them as MC_A and MC_B for easy reference.
- Each component will have 1 quantity of its own to create the MP_01.
That
mean 1 * MC_A + 1 * MC_B = MP_01.
- Now set the product weight of both (MC_A and MC_B) for both items in
decimal and use its quantity as per requirement in the MP_01 product
associations.

Hopefully, with minor or negligible changes in code you should be able
to
achieve decimal functionality. Alternatively, you can go for
customization
which may include some additional fields to work on in product or
product
assoc entity to incorporate the decimal support in BOM.

As far as I remember there is no direct way to BOM with decimal, good to
know if someone from community already know or did this in past.


Thanks!


--
Rishi






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

On Mon, Aug 6, 2018 at 12:59 PM,  wrote:

>
> Team - How have you handled in the past a BOM that is a formula and uses
> fractions of inventory. Let's say we inventory mix in gallons but to
> make 1 bottle of the mix it requires .00983 of a gallon? It seems ofbiz
> doesnt handle decimals in BOM. How have you handled this in the past?
>
> Thanks,
>
> James
>

Re: Need Help - BOM with decimals

[Rishi Solanki]

James,

This is tricky, and you can not see if this is directly available OOTB. But
the trick will surely work ootb. Please follow the following steps;
- Create a manufacturing product in the system. We call it as MP_01
- Lets say add two manufacturing component (raw material) with it. Name
them as MC_A and MC_B for easy reference.
- Each component will have 1 quantity of its own to create the MP_01. That
mean 1 * MC_A + 1 * MC_B = MP_01.
- Now set the product weight of both (MC_A and MC_B) for both items in
decimal and use its quantity as per requirement in the MP_01 product
associations.

Hopefully, with minor or negligible changes in code you should be able to
achieve decimal functionality. Alternatively, you can go for customization
which may include some additional fields to work on in product or product
assoc entity to incorporate the decimal support in BOM.

As far as I remember there is no direct way to BOM with decimal, good to
know if someone from community already know or did this in past.


Thanks!


--
Rishi






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

On Mon, Aug 6, 2018 at 12:59 PM,  wrote:

>
> Team - How have you handled in the past a BOM that is a formula and uses
> fractions of inventory.  Let's say we inventory mix in gallons but to
> make 1 bottle of the mix it requires .00983 of a gallon?  It seems ofbiz
> doesnt handle decimals in BOM.  How have you handled this in the past?
>
> Thanks,
>
> James
>