Confused about how the sequence numbers
are generated on a PO?
Here is what I found-
Note: Below findings are done when
“Back Orders Allowed” checkbox is selected at PO Parameters.
Generally when there is only one
sequence associated with a PO Line, the sequence number of PO Line is 1 with
Order Line as tdgen.oltp.orderline.
Sequences can be generated in 2 ways-
1. Splitting the PO going to the
"Purchase Order Line Details" session.
2. By receiving a PO partially with the
"Final receipt" flag (i.e. when the Back Order Sequence is created.)
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
1
|
tdgen.oltp.orderline
|
5
|
0
|
Splitting the PO going to the
"Purchase Order Line Details" session:
As soon as you split the PO Line two
more sequences are added to your PO Line, making the total sequences to be 3
(i.e. 0, 1, 2)
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
0
|
tdgen.oltp.total
|
5
|
0
|
1
|
tdgen.oltp.detail
|
4
|
0
|
2
|
tdgen.oltp.detail
|
1
|
0
|
Now you can do “Print PO”/”Release PO
to Warehousing” for each sequence separately.
Now let’s Partially receive 3 qty from
sequence 1 with Final receipt flag and then receive 1 quantitty from sequence 2
with Final receipt flag.
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
Back Order Qty
|
To be Confirmed Backorder Qty
|
0
|
tdgen.oltp.total
|
5
|
4
|
1
|
1
|
1
|
tdgen.oltp.detail
|
4
|
3
|
1
|
1
|
2
|
tdgen.oltp.detail
|
1
|
1
|
0
|
0
|
Now we have to Confirm the Potential
Back Order against sequence 1, so that it can be received.
When Potential Back Order is confirmed,
the data in the system is as follows:
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
Back Order Qty
|
To be Confirmed Backorder Qty
|
Linked Back Order Sequence
|
0
|
tdgen.oltp.total
|
5
|
4
|
1
|
0
|
0
|
1
|
tdgen.oltp.detail
|
4
|
3
|
1
|
0
|
3
|
2
|
tdgen.oltp.detail
|
1
|
1
|
0
|
0
|
0
|
3
|
tdgen.oltp.backorder
|
1
|
0
|
0
|
0
|
0
|
Note there is “Confirm Back Order
Automatically” checkbox to automate the Confirming process of Potential Back
Order.
Data will be updated as below after the
sequence 3 is received.
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
Back Order Qty
|
To be Confirmed Backorder Qty
|
Linked Back Order Sequence
|
0
|
tdgen.oltp.total
|
5
|
5
|
0
|
0
|
0
|
1
|
tdgen.oltp.detail
|
4
|
3
|
1
|
0
|
3
|
2
|
tdgen.oltp.detail
|
1
|
1
|
0
|
0
|
0
|
3
|
tdgen.oltp.backorder
|
1
|
1
|
0
|
0
|
0
|
***********************************************************************************
Let’s See how sequencing works for Partial
Receipt of PO Line is done with Final Receipt Flag Set to Yes:
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
1
|
tdgen.oltp.orderline
|
3
|
0
|
I Receive 2 Qty:
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
Back Order Qty
|
To be Confirmed Backorder Qty
|
Linked Back Order Sequence
|
1
|
tdgen.oltp.orderline
|
3
|
2
|
1
|
1
|
0
|
I Confirm the Potential Back Order:
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
Back Order Qty
|
To be Confirmed Backorder Qty
|
Linked Back Order Sequence
|
0
|
tdgen.oltp.total
|
3
|
2
|
1
|
0
|
0
|
1
|
tdgen.oltp.detail
|
3
|
2
|
1
|
0
|
2
|
2
|
tdgen.oltp.backorder
|
1
|
0
|
0
|
0
|
0
|
*** Se the Total & Backorder type
Sequence that got generated.
I received the Backorder Qty:
Sequence
|
Order Line Type
|
Ordered Quantity
|
Delivered Quantity
|
Back Order Qty
|
To be Confirmed Backorder Qty
|
Linked Back Order Sequence
|
0
|
tdgen.oltp.total
|
3
|
3
|
0
|
0
|
0
|
1
|
tdgen.oltp.detail
|
3
|
2
|
1
|
0
|
2
|
2
|
tdgen.oltp.backorder
|
1
|
1
|
0
|
0
|
0
|
No comments:
Post a Comment