Hi community,
We receipt bar stock in multiple lengths (1m, 3m & 6m) but the inventory quantity will be the sum total, If a 2.5m lengthis required this leads IFS to assume we have sufficient stock but the 2.m consists of multiple short lengths
Is there a way to capture the qty in stock by individual length ?
Best answer by ShawnBerk
Yes, with individual part numbers per length. Having the drops as separate pieces won’t be possible under the same part number. IFS will always show the sum of the total length. You could investigate assigning a W/D/R number to each individual piece. This would allow using one part number, but different subsets of the part number. The drawback here is that it would need assigned to each 1m length for example. You wouldn’t be able to show you have qty 3 of 1m pcs and qty 2 of 3m pcs, you would have the following:
1m W/D/R 1m0001
1m W/D/R 1m0002
1m W/D/R 1m0003
3m W/D/R 3m0004
3m W/D/R 3m0005
This has an effect on both MRP and reservations as you have to pick and transact the exact piece you want to move, nothing is automatic. But it would be visible that you have 5 pcs of varying lengths, all of the same material.
Yes, with individual part numbers per length. Having the drops as separate pieces won’t be possible under the same part number. IFS will always show the sum of the total length. You could investigate assigning a W/D/R number to each individual piece. This would allow using one part number, but different subsets of the part number. The drawback here is that it would need assigned to each 1m length for example. You wouldn’t be able to show you have qty 3 of 1m pcs and qty 2 of 3m pcs, you would have the following:
1m W/D/R 1m0001
1m W/D/R 1m0002
1m W/D/R 1m0003
3m W/D/R 3m0004
3m W/D/R 3m0005
This has an effect on both MRP and reservations as you have to pick and transact the exact piece you want to move, nothing is automatic. But it would be visible that you have 5 pcs of varying lengths, all of the same material.
Thanks Shawn,
Iv never actually used this function but i like it and its a good potential solution to this problem and a few others i can think of !!
AndyGrove
+16Andy,
Another option to investigate is to setup the inventory part as lot batch controlled, so basically achieving the same as above, but you can set on the part master form the option to choose one lot per Shop Order. Not sure how planning handles it though.
Anyway, just an idea 
Regards,
Antony
Component Lot Rule:
Select the Component Lot Rule to apply to this part. The component lot rule applies to the Shop Order or the Production Schedule Receipts, and determines whether the lot-tracked components may be issued from only one lot/batch or not. The possible values are:
One Lot Allowed - Only one lot/batch can be issued/used per shop order or production schedule receipt.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
