Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <53E49B16.7050200@nomaka.fr>
Date: Fri, 08 Aug 2014 11:40:38 +0200
From: Guillaume Sigoigne <guillaume.sigoigne@nomaka.fr>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: user@ofbiz.apache.org
Subject: Re: LotId of raw material
References: <9256807D-9025-43D8-9086-117341EB6A1B@gmail.com>
 <53E48E32.7050005@nomaka.fr> <786B0FA5-F10F-4B74-9B96-91A119C27F87@gmail.com>
In-Reply-To: <786B0FA5-F10F-4B74-9B96-91A119C27F87@gmail.com>
Content-Type: multipart/alternative;
 boundary="------------040606060202080907050706"

--------------040606060202080907050706
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: quoted-printable


Le 08/08/2014 11:15, YaoCL a =E9crit :
> Hi Guillaume
>
> On Fri, Aug 08, 2014 at 16:45, Guillaume Sigoigne <guillaume.sigoigne@n=
omaka.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-finis=
hed and finished product, trade, ...)
>> - raw material lotId can be linked to miscellaneous manufactoried prod=
ucts
> 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 suppl=
iers may contains same lotId.
> I don=92t 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 i=
d.
I'm not totally sure about the relevancy of this solution, but that's=20
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 c=
oil.
>> You have to indicate lotId used during the manufacturing process (prod=
uction 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 scre=
en 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=20
to list lotId in production run screen.
You have several possibilities.
First one should be to print barcode of your lotId (with Interleaved 2=20
of 5 barcode type for example) and use a barcode scanner.
Second one is what you propose, customize production run screen by=20
adding a lookup button on lotId.


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


Regards

Guillaume Sigoigne
Nomaka

>
> Regards
> =97
> 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 =E9crit :
>>> I will track the lotId of raw materials, Is the lotId in InventoryIte=
m only for manufactoried product?
>>> These raw materials be used to make some parts. And I want to known e=
very part belong to which lotId.
>>>
>>> What is the good solution.
>>>
>


--------------040606060202080907050706--