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