We are facing an issue where a sales order is processed across two shipments. One of the shipments gets updated to shipped, and the affiliated lines are picked up in our order packing slip batch job and then by order order invoice batch job.
Once the second shipment is processed to Loaded status is where we are facing our issue. The inventory status of the sales order line gets updated to "picked" when a shipment is updated to loaded. When our query runs, the Loaded shipment is getting grabbed by the order packing slip batch job since the sales order already has a Shipped shipment and the inventory transaction is "picked".
This is an issue only if the warehouse makes any processing issue that needs to be corrected, but I'm curious if anyone knows of a better query setting than we are using or if there is a workaround to still only include Shipped shipments under all conditions.
Order packing slip settings:
If you've found this thread useful, dive deeper into User Group community content by role