Need Help - BOM with decimals

[james-2]

CONTENTS DELETED

The author has deleted this message.

[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: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Mon, Aug 6, 2018 at 12:59 PM, <[hidden email]> 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
>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Deepak Dixit-4]

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, <[hidden email]> 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 <[hidden email]>
> Date: Mon, August 06, 2018 2:41 am
> To: ofbizuser <[hidden email]>
>
> 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: [phone]
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Mon, Aug 6, 2018 at 12:59 PM, <[hidden email]> 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
> >
>

[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: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Tue, Aug 7, 2018 at 10:25 AM, Deepak Dixit <[hidden email]>
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, <[hidden email]> 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 <[hidden email]>
> > Date: Mon, August 06, 2018 2:41 am
> > To: ofbizuser <[hidden email]>
> >
> > 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: [phone]
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Mon, Aug 6, 2018 at 12:59 PM, <[hidden email]> 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
> > >
> >
>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[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: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Tue, Aug 7, 2018 at 7:11 PM, <[hidden email]> 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 <[hidden email]>
> Date: Mon, August 06, 2018 11:40 pm
> To: ofbizuser <[hidden email]>
>
> 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: [phone]
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Tue, Aug 7, 2018 at 10:25 AM, Deepak Dixit <[hidden email]>
> 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, <[hidden email]> 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 <[hidden email]>
> > > Date: Mon, August 06, 2018 2:41 am
> > > To: ofbizuser <[hidden email]>
> > >
> > > 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: [phone]
> > > http://www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Mon, Aug 6, 2018 at 12:59 PM, <[hidden email]> 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
> > > >
> > >
> >
>

[Pierre Smits-3]

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.

On Mon, Aug 6, 2018 at 9:29 AM, <[hidden email]> 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