Solved

Multiple lengths of bar stock material

  • 10 June 2021
  • 3 replies
  • 256 views

Userlevel 2
Badge +3

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 ?

 

icon

Best answer by ShawnBerk 11 June 2021, 05:46

View original

This topic has been closed for comments

3 replies

Userlevel 7
Badge +28

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.

Userlevel 2
Badge +3

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

Userlevel 6
Badge +14

Andy,

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 :grinning:

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.