UOM conversion OOTB

[JulienNicolas]

Hi all,

I'm trying to use UOM conversion.
My exemple is : the supplier sales a raw material by unit (coil) that
contains 45 meters of adhesive paper.
I want to buy it by coil. Store and sale it by meter.

I tried this example :
https://www.mail-archive.com/user@.../msg25571.html
But I'm unable to see automatic conversion during reception (OOTB).

I followed many thread about this case but no one is solved... Is
anybody could confirm that it's not possible in OOTB and/or have a
solution for this case ?

Thank you,

Julien NICOLAS.

[Pierre Smits]

Hi Julien,

We came across the same issue.

In general, when you want to order a product your PO should reflect what
your supplier needs for easy processing and avoidance of ambiguity.

So, in your PO you want the supplier unit (coil) and the supplier price per
unit.

In your warehouse you would preferably want to have it the same, as this is
easiest for stock-taking moments. Counting coils is easier than meters in
your case.

So, the actual problem is how the inventory of the product is used. Is the
product used for sales, like in a box  of 6 eggs is being sold as separate
eggs. Or is the product used for manufacturing?

Regards,


Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

[JulienNicolas]

Hi Pierre,

Thanks for your help !
My answers below.

Julien.

Le 23/06/2014 12:04, Pierre Smits a écrit :
> Hi Julien,
>
> We came across the same issue.
>
> In general, when you want to order a product your PO should reflect what
> your supplier needs for easy processing and avoidance of ambiguity.
>
> So, in your PO you want the supplier unit (coil) and the supplier price per
> unit.
Yes
>
> In your warehouse you would preferably want to have it the same, as this is
> easiest for stock-taking moments. Counting coils is easier than meters in
> your case.
Not exactly. In this case we want to follow coil AND meters.
Because it's a manufactured product. If the finished product need 12
meters of adhesive paper, and you have 2 coils of 7 meters, you have to
buy one more coil to produce it.
So we need to know how many meters are in stock and how many meters by
coil (we will use serialization for this part).
We also use the bom produced by the configuration. RM quantity is
managed by meter.

The final need of our customer is to know how many meters are available
in stock and what is the length available on each coil.

>
> So, the actual problem is how the inventory of the product is used. Is the
> product used for sales, like in a box  of 6 eggs is being sold as separate
> eggs. Or is the product used for manufacturing?
>
> Regards,
>
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>

[Pierre Smits]

Julien,

In your first posting you stated that the supplier sells it per coil and
that your customer resells it per meter. In your second posting you stated
that it is a manufactured product.

Does your customer manufacture it as well, or does he use it in a
manufacturing process?

Apart from that, your customer will have:

   - unused (new) coils, supplied by the supplier - to be used in the
   manufacturing process of your customer and for sales
   - used coils, with less than the original quantity - to be used in the
   manufacturing process of your customer and for sales

As far as I can tell, there is functionality available in current feature
set that will display inventory (items) of a product in a facility
converted into various quantityUomIds.


Regards,


Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

[Pierre Smits]

Julien,

What you could do is register the coils as a serialized product.
Subsequently, you could register a bom that transforms 1 coil to meters of
adhesive paper. And each time a new coil is being used, run the production
run to convert. And register the the serialized inventoryId as the lotId
for the registered meters.

That way you would gain insights about the meters on each coil that has
been issued

Regards,



Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

[JulienNicolas]

Hi Pierre,

Thank you for suggestions, we are following several ways to find the best solution for this issue.
I keep the community informed about the solution we'll finally use. In case of somebody need it.

Regards,

Julien.

Julien NICOLAS Intégration ERP/GPAO/MES Apache-OFBiz
	Mobile : [phone] Bureau : 02.85.52.30.55 Courriel : [hidden email]

Le 23/06/2014 13:24, Pierre Smits a écrit :

Julien,

What you could do is register the coils as a serialized product.
Subsequently, you could register a bom that transforms 1 coil to meters of
adhesive paper. And each time a new coil is being used, run the production
run to convert. And register the the serialized inventoryId as the lotId
for the registered meters.

That way you would gain insights about the meters on each coil that has
been issued

Regards,



Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

[Pierre Smits]

Julien,

It is always good to post back. Others might learn from it.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

[Jacques Le Roux]

+1, this ML is our knowledge base in a sense...

Jacques

Le 25/06/2014 10:44, Pierre Smits a écrit :

> Julien,
>
> It is always good to post back. Others might learn from it.
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>

--

[JulienNicolas]

Hi all,

We have finally decided to develop an automatic converter based on the
uomConversion table.

I have open a new Jira (OFBIZ-5672
<https://issues.apache.org/jira/browse/OFBIZ-5672>) to follow it and
keep the community informed about the developpement.

Regards,

Julien.


Le 25/06/2014 11:07, Jacques Le Roux a écrit :

> +1, this ML is our knowledge base in a sense...
>
> Jacques
>
> Le 25/06/2014 10:44, Pierre Smits a écrit :
>> Julien,
>>
>> It is always good to post back. Others might learn from it.
>>
>> Regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>

[Pierre Smits]

Hi Julien,

Thanks.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com