Edit

Consolidate shipments by using the shipment consolidation workbench

This article presents a scenario where multiple orders are released to the warehouse and then consolidated into shipments later by using the shipment consolidation workbench.

Make demo data available

The scenario in this article references values and records that are included in the standard demo data that is provided for Microsoft Dynamics 365 Supply Chain Management. If you want to use the values that are provided here as you do the exercises, ensure you work in an environment where the demo data is installed, and set the legal entity to USMF before you begin.

Set up shipment consolidation policies and product filters

The scenario that is described here assumes that you turned on the feature, completed the exercises in Configure shipment consolidation policies, and created the policies and other records that are described there. Be sure to complete those exercises before you continue with this scenario.

Create the sales orders for this scenario

Start by creating a collection of sales orders that you can work with. You must work with a warehouse that is enabled for advanced warehouse (WMS) processes. Unless a different warehouse is explicitly mentioned, use that same warehouse for each of the following sets of orders.

Go to Accounts receivable > Orders > All sales orders, and create a collection of sales orders that have the settings that are described in the following subsections.

Create order set 1

Sales orders 1-1 and 1-2

  1. Create two identical sales orders with the following settings:

    • Customer account: US-001
    • Mode of delivery: Airwa-Air
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Sales order 1-3

  1. Create a sales order with the following settings:

    • Customer account: US-001
    • Mode of delivery: 10
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

  4. Add a second order line with the following settings:

    • Item number: A0002 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
    • Mode of delivery: Airwa-Air
  5. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the second order line.

Create order set 2

Sales orders 2-1 and 2-2

  1. Create two identical sales orders with the following settings:

    • Customer account: US-002
    • Mode of delivery: Airwa-Air
  2. Add an order line with the following settings:

    • Item number: M9200 (an item where the Code 4 filter is set to Flammable)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

  4. Add a second order line with the following settings:

    • Item number: M9201 (an item where the Code 4 filter is set to Explosive)
    • Quantity: 1.00
    • Mode of delivery: Airwa-Air
  5. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the second order line.

Create order set 3

Sales orders 3-1 and 3-2

  1. Create two identical sales orders with the following settings:

    • Customer account: US-001
    • Customer requisition: 1
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Sales orders 3-3 and 3-4

  1. Create two identical sales orders with the following settings:

    • Customer account: US-001
    • Customer requisition: 2
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Create order set 4

Sales orders 4-1 and 4-2

  1. Create two identical sales orders with the following settings:

    • Customer account: US-003
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Sales orders 4-3 and 4-4

  1. Create two identical sales orders with the following settings:

    • Customer account: US-004
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Sales orders 4-5 and 4-6

  1. Create two identical sales orders with the following settings:

    • Customer account: US-007
    • Site: 6
    • Warehouse: 61
    • Pool: ShipCons
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Sales orders 4-7 and 4-8

  1. Create two identical sales orders with the following settings:

    • Customer account: US-007
    • Site: 6
    • Warehouse: 61
    • Pool: Leave this field blank.
  2. Add an order line with the following settings:

    • Item number: A0001 (an item that doesn't have a Code 4 filter assigned)
    • Quantity: 1.00
  3. Select Inventory > Reservation, and then, on the Action Pane, select Reserve lot to reserve the order line.

Release the orders to the warehouse

Follow these steps to release each sales order that you created for this scenario to the warehouse.

  1. Go to Accounts receivable > Orders > All sales orders.
  2. Find and select the sales order to release.
  3. On the Action Pane, on the Warehouse tab, select Actions > Release to warehouse to release the selected sales order.
  4. Repeat this procedure for every other sales order that you created for this scenario.

Consolidate the shipments by using the shipment consolidation workbench

Note

This scenario assumes that the orders' outbound shipment processing policy doesn't have Enforce shipment to order matching set to Yes. When that option is set to Yes, you can't consolidate shipments from different orders. Learn more in Outbound shipment processing policies.

  1. Go to Warehouse management > Release to warehouse > Shipment consolidation workbench.

  2. On the Action Pane, select Edit query.

  3. In the query editor dialog box, on the Range tab, select Add to add a row that has the following settings to the grid:

    • Table: Sales orders
    • Field: Sales order
    • Criteria: Enter a comma-separated list of the sales order numbers for each order set that you created for this scenario.
  4. Select OK to save your query and close the dialog box.

  5. On the Action Pane, select Consolidate shipments.

  6. Select all the shipments, and then, on the Action Pane, select Consolidate.

Verify the shipments

Use the following procedure to verify the shipments that shipment consolidation created or updated. Use it to review each order set that you created for this scenario, and then review the following subsections to ensure you got the expected results.

  1. Go to Warehouse management > Shipments > All shipments.
  2. Find and select the shipment you need.
  3. If you used a consolidation policy when you created or updated the shipment, you see it in the Shipment consolidation policy field.

Two shipments should have been created:

  • The first shipment contains three lines and was created by using the CustomerMode shipment consolidation policy.
  • The second shipment, which doesn't use the Airways transportation mode of delivery, was created by using the CustomerOrderNo shipment consolidation policy.

Three shipments should have been created:

  • The first shipment contains Flammable items.
  • Each of the other two shipments contains one line that has the Explosive item.

Two shipments should have been created:

  • The first shipment contains order lines from the sales order where the Customer requisition field is set to 1.
  • The second shipment contains order lines from the sales order where the Customer requisition field is set to 2.

Four shipments should have been created:

  • Lines from two orders for customer US-003 are grouped into one shipment by using the Order pool shipment consolidation policy.
  • Lines from two orders for customer US-004 are grouped into one shipment by using the Order pool shipment consolidation policy.
  • Lines from sales orders 4-5 and 4-6 for customer US-007 are grouped into one shipment by using the Order pool shipment consolidation policy.
  • Lines from sales orders 4-7 and 4-8 for customer US-007 are grouped into one shipment by using the CrossOrder shipment consolidation policy.