hi,
i have 4 departments in my unit, each department has several storage locations, that are numbered. The flow of material is from A department > B department > C Department > D Department.
when A department stores a particular batch 123 in say Storage location A1 which takes about 3 hrs to fill, i want this location to show unavailable for other members in the A department. here in this table i have status column showing โIn Progressโ and โCompletedโ
And when the material from batch 123 is taken from location A1 by B department, i want the location A1 to show Available only after B Department finishes clearing the location where in their table hey have column showing โIn Progressโ and โCompletedโ.
i could be contented by a way if i am able to insert a new column where i am able to display available locations for the user to select the appropriate available location for the next batch of material
How do i achieve this ???
User | Count |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |