Enhance Planned Load Interface to Support Splitting or Updating a Backordered Sales Order Line
Four Part Key links the orders in Order Management to multiple systems. Each fulfillment order line is treated as a separate order in WMS. Generally, the combination of 4 Part key is supposed to be unique for each order line. But certain scenarios create multiple order lines with the same 4 Part key. So, we have enhanced WMS-OTM integration to support 4 Part Key duplication for multiple order lines.
The following are the scenarios where Fusion Shipping creates a new order line with a different Ship Request line but the same 4 Part Key.
- When Order Management increases the back order (created due to shorting) quantity, Fusion Shipping creates a new order line with a different ship request line but the same 4 Part Key.
- When Fusion Shipping splits the order coming from Order Management, the WMS receives two Sales Orders with the same 4 part key.
As WMS-OTM integration happens based on the 4 part key, we have enhanced the Planned Load Interface to support the same 4 part key for multiple order details. So that, you can plan multiple order details having the same 4 part key without any error.
If multiple eligible orders or lines are available with the same 4 part key, while planning the load, the system compares and sequences the orders based on the following criteria. So that the system fulfills and ships the orders with the earlier required ship date and higher ordered quantity.
- Ascending sequence of the required ship date of the order
- Descending order of the required quantity (Ordered Quantity)
For example, consider that the following orders are created with the same 4 part key.
Order ID |
Sequence |
SKU |
Ordered Quantity |
External Load |
4 Part Key |
Required Ship Date |
---|---|---|---|---|---|---|
123 | 1 |
ABC |
20 | - |
1.1.2.1 |
06/10/2024 |
124 | 1 |
ABC |
7 | - |
1.1.2.1 |
06/10/2024 |
Assume that you have planned an external load “Load-1” with 22 units (4 part key is 1.1.2.1). For planning the load, the system uses the following criteria.
- The system checks for the ascending sequence of the required ship date. Here, the required ship date is the same for both orders. So, the system goes for the next criteria.
- The system checks for the descending sequence of the ordered quantity. Here, the ordered quantity for Order ID “123” is more. So, the system fulfills the Order ID “123” first.
Post-planning of external load “Load-01”, the system updates the orders as follows.
Order ID |
Sequence |
SKU |
Ordered Quantity | External Load | 4 Part Key | Required Ship Date |
---|---|---|---|---|---|---|
123 | 1 |
ABC |
20 |
Load-1 |
1.1.2.1 |
06/10/2024 |
124 | 1 |
ABC |
5 | - |
1.1.2.1 |
06/10/2024 |
124 | 2 |
ABC |
2 |
Load-1 |
1.1.2.1 |
06/10/2024 |
- Planned Quantity should be less than the required quantity (summed up value) of all eligible orders or order line. If you plan more than the required quantity, the received planned load interface fails.
- If you decrease the planned quantity of a load (spread across multiple eligible orders), the system unassigns the load in the reverse order of the assignment. The system sorts the orders in the descending order of the required ship date and in case of a tie, uses the ascending order of the required quantity.
Steps to Enable
You don't need to do anything to enable this feature.