SO Sequencing

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