We are having issues with traceability considering most of the products we sell.
Most of our products are bought with lot numbers, we can use the suppliers lot numbers as ours since those are unique. The problem exists when a product of one lot is partially used and both the used part and restpiece need to be traced.
Example:
wooden sheet are bought by lot, and placed in stock with their lot number. Some sheet are sold by the sheet, some are cut up and pieces sell to different customers.
When one sheet is sold, the inventory drops by one piece, which is correct. If one sheet is only partially sold, the remaining part is held in stock but how do we tell this to the inventory? And how to trace the remaining part, as it is no longer a full sheet?
That is indeed what I am looking for Jaideep. What happens with an already cut sheet that is cut again? Some sheets can be cut up to 10 times before the original sheet is completely gone.
On the positive side, an already cut sheet can not ever become multiple sheets to track.
An already cut sheet may keep the same serial number when it is cut again, though changing its dimensions.
We do not yet use the manufacturing module, time to try it out.
Thank you for the detailed reply. We already tried it that way, but our sheet come in stacks which have the same lot number.
More detailed example:
We buy 5 stacks of sheet. Each stack contains 38 sheet, and each stack gets a unique lot number because every sheet should trace back to their original stack. The products are stored in the inventory by unit, number of pieces.
Partially used sheets should be stored by weight or square meter. Ideally along with the height and width.
@Jaideep how to trace back from serial number (already cut sheet) to lot number (purchase order)?
the Manufacturing Order would have the link to the lot number of the sheet utilized as components.
You can view the traceability report by clicking trackability smart button on product serial number from menu Inventory > products > Lots/Serial Numbers