LotId of raw material

[YaoCL]

I will track the lotId of raw materials, Is the lotId in InventoryItem only for manufactoried product?
These raw materials be used to make some parts. And I want to known every part belong to which lotId.

What is the good solution.

[Guillaume Sigoigne nomaka]

Hi Yao,

If I well understand your question, you want to know if :
- lotId can be used for any kind of products (raw material, semi-finished and finished product, trade, ...)
- raw material lotId can be linked to miscellaneous manufactoried products

Answer of 1st question is yes.
You can input lotId during products reception or during manufacturing.

Answer of 2nd question is also yes.
For example, you receive a 45 meter coil. You give lotId 12345 to this product.
You will have one stock line with lotID 12345 with quantity 45/45 (if product Uom quantity is in meter).
Then, you produce a manufactoried product which use 2 meters of this coil.
You have to indicate lotId used during the manufacturing process (production run screen).
Raw material stock line of lotId 12345 will change to quantity 43/45.
Manufacturied product stock line has a link to production run.
Production run has a link to used raw materials and their stock lines.


Le 08/08/2014 10:04, YaoCL a écrit :

I will track the lotId of raw materials, Is the lotId in InventoryItem only for manufactoried product?
These raw materials be used to make some parts. And I want to known every part belong to which lotId.

What is the good solution.

[YaoCL]

Hi Guillaume

On Fri, Aug 08, 2014 at 16:45, Guillaume Sigoigne <[hidden email]> Wrote:
> Hi Yao,
>
> If I well understand your question, you want to know if :
> - lotId can be used for any kind of products (raw material, semi-finished and finished product, trade, ...)
> - raw material lotId can be linked to miscellaneous manufactoried products
Yes

> Answer of 1st question is yes.
> You can input lotId during products reception or during manufacturing.
LotId is a primary key of Lot table, raw materials from different suppliers may contains same lotId.
I don’t assign a new lotId for the raw materials, but use the lot id from supplier.

> Answer of 2nd question is also yes.
> For example, you receive a 45 meter coil. You give lotId 12345 to this product.
> You will have one stock line with lotID 12345 with quantity 45/45 (if product Uom quantity is in meter).
> Then, you produce a manufactoried product which use 2 meters of this coil.
> You have to indicate lotId used during the manufacturing process (production run screen).
> Raw material stock line of lotId 12345 will change to quantity 43/45.
> Manufacturied product stock line has a link to production run.
> Production run has a link to used raw materials and their stock lines.
Yes the production run screen can input lotId, should I custom the screen to display the lotId of main raw material,
so I can input, without It I can not remember the lotId.

Regards
—
YaoCL

>
> Hope it helps.
>
> Regards
>
>
> Guillaume SIGOIGNE
> ERP/GPAO/Suivi de production  Apache-OFBiz
>
> <signature.png>
> Mobile : [phone]
> Bureau : 02.85.52.30.55
> Courriel : [hidden email]
> Le 08/08/2014 10:04, YaoCL a écrit :
>> I will track the lotId of raw materials, Is the lotId in InventoryItem only for manufactoried product?
>> These raw materials be used to make some parts. And I want to known every part belong to which lotId.
>>
>> What is the good solution.
>>
>

[Guillaume Sigoigne nomaka]

Le 08/08/2014 11:15, YaoCL a écrit :

> Hi Guillaume
>
> On Fri, Aug 08, 2014 at 16:45, Guillaume Sigoigne <[hidden email]> Wrote:
>> Hi Yao,
>>
>> If I well understand your question, you want to know if :
>> - lotId can be used for any kind of products (raw material, semi-finished and finished product, trade, ...)
>> - raw material lotId can be linked to miscellaneous manufactoried products
> Yes
>
>> Answer of 1st question is yes.
>> You can input lotId during products reception or during manufacturing.
> LotId is a primary key of Lot table, raw materials from different suppliers may contains same lotId.
> I don’t assign a new lotId for the raw materials, but use the lot id from supplier.

I see what you mean. As it is a primary key, you can't avoid this problem.
You can probably use InventoryItem.softIdentifier to store supplier lot id.
I'm not totally sure about the relevancy of this solution, but that's
the field I'll use in your case.

>
>> Answer of 2nd question is also yes.
>> For example, you receive a 45 meter coil. You give lotId 12345 to this product.
>> You will have one stock line with lotID 12345 with quantity 45/45 (if product Uom quantity is in meter).
>> Then, you produce a manufactoried product which use 2 meters of this coil.
>> You have to indicate lotId used during the manufacturing process (production run screen).
>> Raw material stock line of lotId 12345 will change to quantity 43/45.
>> Manufacturied product stock line has a link to production run.
>> Production run has a link to used raw materials and their stock lines.
> Yes the production run screen can input lotId, should I custom the screen to display the lotId of main raw material,
> so I can input, without It I can not remember the lotId.

Effectively, in out of the box version there is, in my knowledge, no way
to list lotId in production run screen.
You have several possibilities.
First one should be to print barcode of your lotId (with Interleaved 2
of 5 barcode type for example) and use a barcode scanner.
Second one is what you propose, customize production run screen by
adding a lookup button on lotId.


Just for your information, if you need a solution of traceability for
factory, we are currently working on a floss solution which is already
functional.
It allows you to followup production run tasks, raw material
traceability (by lotId, but without lookup ;) )and real used quantity
directly in the factory instead of flying reports you have to keyin in
office.
You can find source code here : https://github.com/nomakaFr/nomaka-followup


Regards

Guillaume Sigoigne
Nomaka

>
> Regards
> —
> YaoCL
>
>> Hope it helps.
>>
>> Regards
>>
>>
>> Guillaume SIGOIGNE
>> ERP/GPAO/Suivi de production  Apache-OFBiz
>>
>> <signature.png>
>> Mobile : [phone]
>> Bureau : 02.85.52.30.55
>> Courriel : [hidden email]
>> Le 08/08/2014 10:04, YaoCL a écrit :
>>> I will track the lotId of raw materials, Is the lotId in InventoryItem only for manufactoried product?
>>> These raw materials be used to make some parts. And I want to known every part belong to which lotId.
>>>
>>> What is the good solution.
>>>
>

[Pierre Smits]

Hi YoaCL, all,

Re: Raw materials from different suppliers may contains same lotId
I agree that this is an improvement that should be included. Therefore I
have created the following JIRA issue to capture further aspects regarding
this improvement.

https://issues.apache.org/jira/browse/OFBIZ-5704


@all: feel free to add additional requirements, etc as a comment to the
JIRA issue.

Regards,

Pierre Smits

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

[YaoCL]

Hi ,all

Thanks.

@Pierre that improvement will resolve the problem.
@Guillaume I ill take a look at nomaka-followup later.

Regards
YaoCL
On Fri, Aug 08, 2014 at 18:10, Pierre Smits <[hidden email]> Wrote:

>
> Hi YoaCL, all,
>
> Re: Raw materials from different suppliers may contains same lotId
> I agree that this is an improvement that should be included. Therefore I
> have created the following JIRA issue to capture further aspects regarding
> this improvement.
>
> https://issues.apache.org/jira/browse/OFBIZ-5704
>
>
> @all: feel free to add additional requirements, etc as a comment to the
> JIRA issue.
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com