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.
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 |