I need an ideas regarding my issue. The client wants to monitor their inventory by milimeter. When they buy the item it is in pcs. Consider the following following scenario:
1.) The client bought 2 pcs of rod which is equivalent of 2,000 mm. Means 1,000mm/pc or 1 mtr ./pc if my conversion is correct.
Description: Rod 30X150
2.) The client bought again another Rod. Same Rod but in different length. 1 pc which is equivalent to 2,000 mm. Means 2,000/pc or 2mtr/pc.
Description: Rod 30X300
1.) The UOM is mm. So in my inventory I already have 3,000 mm but I don't know how many pieces..
2.) If I use the item in production and there is a left over how can I handle that? Say I issue 500mm in the production where I get it from 30X15 wrhich brings me a leftover of 500 in the piece and a total of 1,500 for the 30X150 or 3,500 for the overall quantity.
Do you have any suggestion how can I make this process simple? Please help.