Handling of Serial Numbers for Transportation Split Order Details

During transportation split, when you split a single order detail into multiple loads, the Planned OB Load interface picks the serial numbers randomly as per the planned quantity and updates the serial numbers under the “Required Serial Numbers” column in the Order Detail screen.

Planned Load Order Detail Quantity Update

If you update the planned load ordered quantity for a split order detail, the system takes an extra ordered quantity from the original transportation split order detail and updates the serial numbers based on the quantity.

For example, consider an order (ORD-1) that has 10 units of serial tracking item “SKU-A”. If you perform transportation split for the order detail, assume that the following updates are made in the order detail.

Initial Order Detail:

Order Item Ordered Quantity External Planned Load Number Required Serial Numbers
ORD-1 SKU-A 10 - SRL01, SRL02, SRL03, SRL04, SRL05, SRL06, SRL07, SRL08, SRL09, SRL10

Post Transportation Split (Order Details):

Order Item Ordered Quantity External Planned Load Number Required Serial Numbers Order Sequence Ref Order Sequence
ORD-1 SKU-A 6 - SRL05, SRL06, SRL07, SRL08, SRL09, SRL10 1 -
ORD-1 SKU-A 2 EXPLOAD01 SRL01, SRL02 - 1
ORD-1 SKU-A 2 EXPLOAD02 SRL03, SRL04 - 1

If you update the Planned Load Quantity (EXPLOAD01) to 5. The system updates the serial numbers as mentioned below.

Order Item Ordered Quantity External Planned Load Number Required Serial Numbers Order Sequence Ref Ord Sequence
ORD-1 SKU-A 3 - SRL08, SRL09, SRL10 1 -
ORD-1 SKU-A 5 EXPLOAD01 SRL01, SRL02, SRL05, SRL06, SRL07 - 1
ORD-1 SKU-A 2 EXPLOAD02 SRL03, SRL04 - 1

Order Quantity Update

When you update the ordered quantity for an original transportation split order detail via Order Detail UI or Order Interface, the system updates the ordered quantity and merges the order details with serial numbers.

For example, if you update the ordered quantity for the original transportation split order detail from 3 to 5 in the following table via UI or interface.

Order Number Item Ordered Quantity Required Serial Numbers Status
ORD-1 SKU-A 3 S1, S2, S3 Created
ORD-1 SKU-A 2 S4, S5 Created

On updating the ordered quantity, the system merges the order details along with the ordered quantity and serial numbers.

Order Number Item Ordered Quantity Required Serial Numbers Status
ORD-1 SKU-A 5 S1, S2, S3, S4, S5 Created

Planned Load Order Detail Deletion

If you delete an externally planned load with ordered quantity, the system adds the deleted quantity to the original transportation split order detail along with the serial numbers.

For example, consider an order (ORD-1) that has 10 units of serial tracking item “SKU-A”. If you perform transportation split for the order detail, assume that the following updates are made in the order detail.

Initial Order Detail:

Order Item Ordered Quantity External Planned Load Number Required Serial Numbers
ORD-1 SKU-A 10 - SRL01, SRL02, SRL03, SRL04, SRL05, SRL06, SRL07, SRL08, SRL09, SRL10

Post Transportation Split (Order Details):

Order Item Ordered Quantity External Planned Load Number Required Serial Numbers Order Sequence Ref Order Sequence
ORD-1 SKU-A 6 - SRL05, SRL06, SRL07, SRL08, SRL09, SRL10 1 -
ORD-1 SKU-A 2 EXPLOAD01 SRL01, SRL02 - 1
ORD-1 SKU-A 2 EXPLOAD02 SRL03, SRL04 - 1

If you delete the Planned Load EXPLOAD01 for the order detail, the system updates the serial numbers as mentioned below.

Order Item Ordered Quantity External Planned Load Number Required Serial Numbers Order Sequence Ref Ord Sequence
ORD-1 SKU-A 8 - SRL01, SRL02, SRL05, SRL06, SRL07, SRL08, SRL09, SRL10 1 -
ORD-1 SKU-A 2 EXPLOAD02 SRL03, SRL04 - 1

Reset Planned Load for an Order Detail

When you use the “Reset Planned Load” action button for an Order Detail (requires serial number) that has some already shipped units, the system closes the externally planned load with the quantities that are already shipped and updates the serial numbers under the “Required Serial Numbers” column in the Order Detail screen with the shipped serial numbers. Also, the system creates a new order detail with the remaining serial numbers that are not shipped.

Note: The number of units matches with number of serial numbers.

Example: Consider an order ORD-05 has 5 units of SKU01 which is serial tracked.

Initial Order Detail:

Order Item Ordered Quantity Status External Planned Load Number Required Serial Numbers
ORD-05 SKU01 5 Created REF01, REF02, REF03, REF04, REF05

If 3 units of order detail got allocated and shipped with load EXPLOAD03, the system updates the order detail as follows.

Order Item Ordered Quantity Allocated Quantity Shipped Quantity Status External Planned Load Number Required Serial Numbers
ORD-05 SKU01 5 3 3 Partly Allocated EXPLOAD03 REF01, REF02, REF03, REF04, REF05

If you click Reset the planned load EXPLOAD03, as the order detail is already shipped with 3 quantities, the system creates a new order line for the remaining quantity “2”.

Order Item Ordered Quantity Allocated Quantity Shipped Quantity Status External Planned Load Number Required Serial Numbers
ORD-05 SKU01 5 3 3 Shipped EXPLOAD03 REF01, REF02, REF03
ORD-05 SKU01 5 2 2 Created REF04, REF05