Hi experts,
I have what I assumed was an easy task, but is beginning to look impossible.
I want my sales order work creation to only create for a full PLT and ignore any less than full pallet quantities in the same location with the same inventory status. How can I accomplish this?
We produce in cases, then palletize, so my finished products do have a unit sequence group of Plt-Cases. On my location directive for the sales order pick, I do have restrict by unit checked, but due to unit seq group it is not restricting to full pallets. I have tried adding queries on the work template to using the temp work transactions table to limit by directive unit = PLT with no luck. I have tried others as well and anytime I put a query on the work template I get no work to generate. As mentioned I would think this is a common practice in manufacturing but am not finding any solutions.
We load to a truck directly off the line while we are running, so we do have a custom job to allow SO's to reserve partially and a batch job to release the load to the warehouse runs every one minute picking up recently produced pallets. However, in the warehouse we may have partials for one reason or the other. So when the batch job to release to the warehouse runs it creates work for the partial pallet in the warehouse. I want it to ignore the partials because it doesnt = 1 PLT. I dont want to have to change the quality status on each partial which is my potential work around. I just want the work template/location directive to only generate work for full pallets. Please help.
Thanks.