You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by YaoCL <ch...@gmail.com> on 2014/08/08 10:04:16 UTC
LotId of raw material
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.
Re: LotId of raw material
Posted by Guillaume Sigoigne <gu...@nomaka.fr>.
Le 08/08/2014 11:15, YaoCL a écrit :
> Hi Guillaume
>
> On Fri, Aug 08, 2014 at 16:45, Guillaume Sigoigne <gu...@nomaka.fr> 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 : 06.01.92.45.70
>> Bureau : 02.85.52.30.55
>> Courriel : guillaume.sigoigne@nomaka.fr
>> 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.
>>>
>
Re: LotId of raw material
Posted by YaoCL <ch...@gmail.com>.
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 <pi...@gmail.com> 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
Re: LotId of raw material
Posted by Pierre Smits <pi...@gmail.com>.
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
Re: LotId of raw material
Posted by YaoCL <ch...@gmail.com>.
Hi Guillaume
On Fri, Aug 08, 2014 at 16:45, Guillaume Sigoigne <gu...@nomaka.fr> 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 : 06.01.92.45.70
> Bureau : 02.85.52.30.55
> Courriel : guillaume.sigoigne@nomaka.fr
> 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.
>>
>
Re: LotId of raw material
Posted by Guillaume Sigoigne <gu...@nomaka.fr>.
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.
Hope it helps.
Regards
Guillaume SIGOIGNE
ERP/GPAO/Suivi de production Apache-OFBiz
Mobile : 06.01.92.45.70
Bureau : 02.85.52.30.55
Courriel : guillaume.sigoigne@nomaka.fr
<ma...@nomaka.fr>
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.