Scenario 3: Transactional Consolidation Mode
In the Transactional Consolidation mode, the system consolidates order lines that are entered or modified together onto the same shipment.
In this scenario, we have an order where we use the Add mode to enter four order lines. Later, we use the Update mode to add four additional order lines. Because of transactional consolidation, the system assigns a shipment number to each transaction related to the order.
The original shipment number for the Add mode (202) consists of the four order lines that you entered to initiate the sales order. The original shipment number for the Update mode (203) consists of the four order lines that you added to the sales order as a second transaction. The following tables illustrate the details of the original shipment numbers for the Add mode and the Update mode before running the Release from Fulfillment report:
Order Line |
Item |
Quantity |
Shipment Number |
---|---|---|---|
1 |
A |
10 |
202 |
2 |
B |
20 |
202 |
3 |
C |
40 |
202 |
4 |
D |
50 |
202 |
Order Line |
Item |
Quantity |
Shipment Number |
---|---|---|---|
5 |
E |
10 |
203 |
6 |
F |
20 |
203 |
7 |
G |
40 |
203 |
8 |
H |
50 |
203 |
When you run the Release from fulfillment report, the system:
Releases all quantity for order lines 1 through 3
Partially releases quantity for order lines 4 through 6
Does not release any quantity for order lines 7 and 8
The following table illustrates the results of fulfillment processing in the Transactional Consolidation mode:
Order Line |
Item |
Original Quantity |
Original Shipment Number |
Released Quantity |
Unreleased Quantity |
New Shipment Number |
---|---|---|---|---|---|---|
1 |
A |
10 |
202 |
10 |
0 |
N/A |
2 |
B |
20 |
202 |
20 |
0 |
N/A |
3 |
C |
40 |
202 |
40 |
0 |
N/A |
4 |
D |
50 |
202 |
30 |
20 |
204 |
5 |
E |
10 |
203 |
5 |
5 |
205 |
6 |
F |
20 |
203 |
15 |
5 |
206 |
7 |
G |
40 |
203 |
0 |
40 |
207 |
8 |
H |
50 |
203 |
0 |
50 |
207 |
The released quantities for each transaction remain on the original shipment number for the respective mode (202 or 203).
For the Add mode transaction, the system fully releases the quantity for order lines (1-3) and partially releases the quantity for order line 4. The released quantity remains on the Add mode original shipment number (202) and the system creates a new shipment number (204) for the partially unreleased quantity for item D.
For the Update mode transaction, the system partially releases the quantity for order lines 5 and 7. The released quantity remains on the original shipment number (203) and the system creates new shipment numbers (205 and 206) for each partially unreleased order line. The system does not release any quantity for order lines 7 and 8. Because the system did not release any quantity for either order line, the system assigns the quantity for each order line to the same shipment number (207).
The following tables illustrate the contents of the original shipment numbers and the new shipment numbers after you run the Release from Fulfillment report:
Shipment Number |
Item |
Quantity |
---|---|---|
202 |
A |
10 |
202 |
B |
20 |
202 |
C |
40 |
202 |
D |
30 |
203 |
E |
5 |
203 |
F |
15 |
Shipment Number |
Item |
Quantity |
---|---|---|
204 |
D |
20 |
205 |
E |
5 |
206 |
F |
5 |
207 |
G |
40 |
207 |
H |
50 |