Order Fulfillment Worksheet handles orders with lines shipping on different days by allowing filtering and staged pick creation, so only the lines that are actually ready to ship on a given day get picked, while the rest wait until their own ship date arrives.
Filtering to Isolate What Ships Today
When an order contains lines with different shipment dates, an advanced line filter can be set up within the worksheet to exclude lines that are not supposed to ship yet, leaving only the lines relevant to today’s shipping activity visible for allocation and pick creation. This filter can be built once and reused, so it does not need to be manually recreated every time the situation arises.
Removing Allocation for Later Lines
An alternative to filtering is simply removing the allocation for lines that are not ready to ship yet, then creating the pick only for the lines that remain allocated and are due to go out today. This achieves the same practical outcome, ensuring a pick is only generated for what should actually move now, while later lines remain untouched until it is their turn.
Creating Picks in Stages
It is also possible to create a pick for everything on the order at once and then manage the timing of the actual shipment at the warehouse shipment level, holding the later lines until their ship date arrives even though a pick already exists for them. Which of these approaches makes more sense depends on how a company prefers to manage its warehouse floor, whether it wants picks to exist only for what should move today, or whether it is comfortable having picks exist in advance and simply controlling when they actually ship.
How the Worksheet Behaves After Partial Picking
Once a pick has been created for the earlier dated lines on a mixed order, the worksheet updates to reflect the next relevant date for that order. If an order had lines due on two different dates and a pick is created for the earlier date, the worksheet will then show the later date as the operative ship date for that order going forward, since nothing remains outstanding for the earlier date. This keeps the worksheet’s date based sorting accurate as lines are progressively picked and shipped.
Automating This With Scheduled Jobs
For companies that want this handled without manual intervention, a scheduled job can be set up to only allocate and act on lines that are due to ship on the current date, effectively automating the filtering step described above. This is particularly useful for high volume operations where manually applying a filter for every mixed order would be impractical.
Related Tools
Order Fulfillment Worksheet provides the filtering, allocation removal, and staged pick creation options needed to manage orders with multiple ship dates cleanly, along with scheduling capability to automate the process.
In summary, filtering, selectively removing allocation, or staging pick creation are the practical ways to manage an order with lines shipping on different days, and the worksheet automatically shifts its focus to the next outstanding ship date once earlier lines are picked.