Content Comparison

...

Table 1.1 : Sale order initial state

Order Line

Product

Qty Ordered

Qty On Shipments

Qty Allocated

Qty Back Ordered

Line Fully Allocated

Auto-Warehouse

Min Allocation %

Auto-Warehouse

Produce Shipment/Picking slip

(Is Percent Fully Allocated >= Min Allocation % ?)

1

A

10

0

10

0

2

B

10

0

10

3

C

10

0

5

4

D

10

0

1

9

5

E

10

0

2

8

Percent Fully Allocated

1/5*100 = 20%

10%

Yes

 Note
Order Line 1 is fully allocated; Qty Ordered - Qty Allocated = 0
Order Line 2-5 are not fully allocated; Qty Order - Qty Allocated not = 0
Percent Fully Allocated =  number of fully allocated unsupplied order lines / total number of unsupplied order lines * 100 = 1/5*100 = 20%, thus there will be shipment/picking slip created
Percent Picked = Total Qty Picked (posted shipments) / Total Qty Ordered * 100 = 0/50 * 100 = 0%

Table 1.2 : When the shipment/picking slip are created by auto-warehouse the state of the order can be depicted as follows

Order Line

Product

Qty Ordered

Qty On Shipments

Qty Allocated

Qty Back Ordered

Line Fully Allocated

Auto-Warehouse

Min Allocation %

Auto-Warehouse

Produce Shipment/Picking slip

(Is Percent Fully Allocated >= Min Allocation % ?)

Supplied

A

10

0

Shipment #1

1

B

10

0

10

2

C

10

5

0

5

3

D

10

1

0

9

4

E

10

2

0

8

Percent Fully Allocated

0/4*100 = 0%

10%

No

Note

Order Line Supplied is excluded from the calculation as it is on a shipment
Total Order Line is now 4
Order Line 1-4 are not fully allocated
Percent Fully Allocated = 0/4*100 = 0%, thus there will be no shipment/picking slip created
Info
Percent Fully Allocated calculation is based on the unsupplied order lines as such it can be set back to 0% throughout an order life cycle.
Shipment #1 consists of all items in Order Line "Supplied" and parts of Order Line 2-4
Percent Picked = Total Qty Picked (posted shipments) / Total Qty Ordered * 100 = 0/50 * 100 = 0%; the shipment created is in In Progress status

...

Table 1.3 : Penultimate state of the order can be depicted as follows

Order Line

Product

Qty Ordered

Qty On Shipments

Qty Allocated

Qty Back Ordered

Line Fully Allocated

Auto-Warehouse

Min Allocation %

Auto-Warehouse

Produce Shipment/Picking slip

(Is Percent Fully Allocated >= Min Allocation % ?)

Supplied

A

10

0

Shipment #1

1

B

10

0

10

0

2

C

10

5

0

3

D

10

1

9

0

4

E

10

2

8

0

Percent Fully Allocated

4/4*100 = 100%

10%

Yes

 Note
Order Line 1-4 are fully allocated
Percent Fully Allocated = 4/4*100 =100%, thus there will be shipment/picking slip created   
Percent Picked = Total Qty Picked (posted shipments) / Total Qty Ordered * 100 = 10/50 * 100 = 20%; the shipment created for the supplied line is in Posted status

...

Table 1.4 : Final state of the order can be depicted as follows

Order Line

Product

Qty Ordered

Qty On Shipments

Qty Allocated

Qty Back Ordered

Line Fully Allocated

Auto-Warehouse

Min Allocation %

Auto-Warehouse

Produce Shipment/Picking slip

(Is Percent Fully Allocated >= Min Allocation % ?)

Supplied

A

10

0

Shipment #1

Supplied

B

10

0

Shipment #2

Supplied

C

10

0

Shipment #2

Supplied

D

10

0

Shipment #2

Supplied

E

10

0

Shipment #2

Percent Fully Allocated

0%

10%

No

 Note
Supplied Order Lines are excluded from the calculation
Percent Fully Allocated = 0%, as there are no outstanding unsupplied order lines   
Percent Picked = 50/50 * 100 = 100%; the shipments created are in Posted status

...

Example 2: When there is one order line (or only one remaining order line)

Table 2.1 : In this scenario, a simple percent average allocated calculation is used as opposed to calculate the Percent Fully Allocated calculation and can be which is depicted as follows

Order Line

Product

Qty Ordered

Qty On Shipments

Qty Allocated

Qty Back Ordered

Simple Percent Average Allocated

Auto-Warehouse

Min Allocation %

Auto-Warehouse

Produce Shipment/Picking slip

(Is

Simple

Percent

Average

Fully Allocated >= Min Allocation % ?)
Fully Allocated >= Min Allocation % ?)	1	A	10	0	5	5

Simple

Percent

Average

Fully Allocated

5/10*100 = 50%

10%

Yes

 Note
Order Line 1 is the only single line thus a Simple Percent Average Allocated is used to calculate the Percent Fully Allocated

Simple

Percent

Average

Fully Allocated =  Qty Allocated / Qty Ordered = 5/10*100 = 50%, thus there will be shipment/picking slip created

Percent Fully Allocated = 0%

Percent Picked = 0/50 * 100 = 0%; the shipment created is in In Progress status

...

Table 2.2 : Final state of the order can be depicted as follows

Order Line

Product

Qty Ordered

Qty On Shipments

Qty Allocated

Qty Back Ordered

Simple Percent Average Allocated

Auto-Warehouse

Min Allocation %

Auto-Warehouse

Produce Shipment/Picking slip

(Is

Simple

Percent

Average

Fully Allocated >= Min Allocation % ?)
Fully Allocated >= Min Allocation % ?)	Supplied	A	10	10	0	0	Shipment #3

Simple

Percent

Average

Fully Allocated

0%

10%

No

 Note
Supplied Order Lines are excluded from the calculation

Simple

Percent

Average Allocated = 0%Percent

 Fully Allocated = 0%
Percent Picked = 10/10 * 100 = 100%; the shipments created are in Posted status

...

Version	Old Version 14	New Version Current
Changes made by	Van Ho	Van Ho
Saved on	Feb 15, 2016	Sep 28, 2016

Versions Compared

Key

Example 2: When there is one order line (or only one remaining order line)