Good morning David;
Not sure if this helps or not, but we do a lot of split shipments as well, these are the parameters we use on the packing-slip posting:
Sales Orders.Status = Open order, Delivered
Shipments.Shipment status = Shipped
Shipments.Shipping confirmation date and time = !""
Cuing off the shipment rather than the load may help.
We have a couple of other filters, but they are there for other purposes, not likely pertinent to your scenario.
Order lines.stopped = No
Shipments.Planned Ship Date = (DayRange(-30,0))
Sales orders.Order type=Sales order
(We are on 2012R3, and using Advanced Warehouse)
------------------------------
Adam Pascoe
Bio-techne
Minneapolis MN
------------------------------
Original Message:
Sent: Mar 18, 2020 03:46 PM
From: David Barahona
Subject: Packing Slip Posting considers Picked quantities regardless of shipment status
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:
- Quantity parameter: Picked
- Sales order status: Open order
- Load status: Shipped (this is accomplished off a table join to Load details and then Load)
------------------------------
David Barahona
Implus Corporation
Durham NC
------------------------------