To add to my earlier Blog on PO Sequencing, I did some study on when all
the SO sequence is generated and what is the Significance of “Order Line
Type” for the SO Line Sequences.
This is what I found-
Note:
There is no “Back Orders Allowed” checkbox in SO Parameters. You can only
Control if Back Orders is confirmed Automatically with “Confirm Back Order
Automatically” flag in SO Parameters.
Generally
when there is only one sequence associated with a SO Line, the sequence number
of SO Line is 0 with Order Line as tdsls.oltp.detail.
Sequence
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
0
|
tdsls.oltp.detail
|
5
|
0
|
Sequences
can be generated in 2 ways-
1.
Split Delivery Line in the Sales Order Planned Delivery Lines (tdsls4101m100)
session. Main Sequence with Line Type as tdsls.oltp.total and its sub
seqences with Line Type as tdsls.oltp.detail (s)
2.
Partial Delivery of SO Line, were new sequence gets generated with Order Line
Type as tdsls.oltp.backorder
Split
Delivery Line in the Sales Order Planned Delivery Lines (tdsls4101m100):
As
soon as you split the SO Line two more sequences are added to your SO Line,
making the total sequences to be 3 (i.e. 0, 1, 2)
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
0
|
not.applicable
|
tdsls.oltp.total
|
5
|
0
|
1
|
warehousing
|
tdsls.oltp.detail
|
4
|
0
|
2
|
warehousing
|
tdsls.oltp.detail
|
1
|
0
|
Now
you can do “Print SO Acknowledgements”/”Release SO to Warehousing” for each
tdsls.oltp.detail sequence separately.
Now
let’s Partially Ship 3 qty from sequence 1
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
Back
Order Qty
|
Backorder
Confirmed?
|
0
|
not.applicable
|
tdsls.oltp.total
|
5
|
3
|
1
|
No
|
1
|
warehousing
|
tdsls.oltp.detail
|
4
|
3
|
1
|
No
|
2
|
warehousing
|
tdsls.oltp.detail
|
1
|
0
|
0
|
No
|
Now we
have to Confirm the Back Order against sequence 1, so that it can be received.
When Back Order is confirmed, the data in the system is as follows:
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
Back
Order Qty
|
Backorder
Confirmed?
|
Linked
Sequence
|
0
|
not.applicable
|
tdsls.oltp.total
|
5
|
3
|
1
|
No
|
0
|
1
|
warehousing
|
tdsls.oltp.detail
|
4
|
3
|
1
|
Yes
|
3
|
2
|
warehousing
|
tdsls.oltp.detail
|
1
|
0
|
0
|
No
|
0
|
3
|
warehousing
|
tdsls.oltp.backorder
|
1
|
0
|
0
|
No
|
0
|
Now I
ship Sequence 3.
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
Back
Order Qty
|
Backorder
Confirmed?
|
Linked
Sequence
|
0
|
not.applicable
|
tdsls.oltp.total
|
5
|
4
|
0
|
No
|
0
|
1
|
warehousing
|
tdsls.oltp.detail
|
4
|
3
|
1
|
Yes
|
3
|
2
|
warehousing
|
tdsls.oltp.detail
|
1
|
0
|
0
|
No
|
0
|
3
|
warehousing
|
tdsls.oltp.backorder
|
1
|
1
|
0
|
No
|
0
|
***********************************************************************************
Let’s
See how sequencing works for Partial Delivery of SO Line, were new sequence
gets generated with Order Line Type as tdsls.oltp.backorder:
Sequence
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
0
|
tdsls.oltp.detail
|
3
|
0
|
I ship
2 Qty:
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
Back
Order Qty
|
Backorder
Confirmed?
|
Linked
Sequence
|
0
|
warehousing
|
tdsls.oltp.detail
|
3
|
2
|
1
|
No
|
0
|
I
Confirm the Back Order:
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
Back
Order Qty
|
Backorder
Confirmed?
|
Linked
Sequence
|
0
|
warehousing
|
tdsls.oltp.detail
|
3
|
2
|
1
|
Yes
|
1
|
1
|
warehousing
|
tdsls.oltp.backorder
|
1
|
0
|
0
|
No
|
0
|
I
Shipped The 1 Qty for Sequence 1
Sequence
|
Delivery
Type
|
Order
Line Type
|
Ordered
Quantity
|
Delivered
Quantity
|
Back
Order Qty
|
Backorder
Confirmed?
|
Linked
Sequence
|
0
|
warehousing
|
tdsls.oltp.detail
|
3
|
2
|
1
|
Yes
|
1
|
1
|
warehousing
|
tdsls.oltp.backorder
|
1
|
1
|
0
|
No
|
0
|
