Job Pic List

I am modifying the Job Pick List and running into duplicating issues. We have changed the Mtl Seq Group to the part Num. So it now groups by part num. We do this because we could have multiple parts such as a screw under an operation but at various Mtl Seq. It works ok but my Warehouse listing is showing as many times as that part num is in Mtl Seq. So if the Part num is in Mtl Seq 1, 2, and 3 it list the warehouse 3x’s. Also the required qty is adding up then multiplying by how many warehouses are listed on one Mtl Seq. I don’t know if I have explained this well. Here is an example. This part is in 5 different Mtl Seq. Qty should be 41

did you get any further with this?
I have been asked to do something similar by grouping/sorting

Also i need to exclude 3 warehouses but i’m not sure of the crystal syntax…this report doesn’t seem to be driven by a BAQ, therefore will need to be done directly in crystal i guess.

Sorry no and I actually changed companies so not with them anymore. I think they did get it working but I don’t know what they did.

1 Like