Percent Fully Allocated, a property of Sale Order, is
used on the sale order list view as one of the key indicators to track the progress of outstanding orders; It is recommended that a property called Percent Picked is added to the view to enhance this process.
This property is calculated using the following formula :
if it is greater or equal to the Min Allocation % and provided that all other criteria are met then a shipment/picking slip will be created/printed by auto-warehousing.
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 | 0 | 10 | ![]() | |||
3 | C | 10 | 0 | 5 | 5 | ![]() | |||
4 | D | 10 | 0 | 1 | 9 | ![]() | |||
5 | E | 10 | 0 | 2 | 8 | ![]() | |||
Percent Fully Allocated | 1/5*100 = 20% | 10% | Yes | ||||||
|
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 | 10 | Shipment #1 | ||||||||
1 | B | 10 | 0 | 0 | 10 | ![]() | ||||
2 | C | 10 | 0 | 5 | ![]() | |||||
3 | D | 10 | 0 | 9 | ![]() | |||||
4 | E | 10 | 0 | 8 | ![]() | |||||
Percent Fully Allocated | 0/4*100 = 0% | 10% | No | |||||||
|
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 | 10 | Shipment #1 | |||||||
1 | B | 10 | 0 | 10 | 0 | ![]() | |||
2 | C | 10 | 5 | 0 | ![]() | ||||
3 | D | 10 | 9 | 0 | ![]() | ||||
4 | E | 10 | 8 | 0 | ![]() | ||||
Percent Fully Allocated | 4/4*100 = 100% | 10% | Yes | ||||||
|
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 | 10 | Shipment #1 | |||||||
Supplied | Shipment #2 | ||||||||
Supplied | Shipment #2 | ||||||||
Supplied | Shipment #2 | ||||||||
Supplied | Shipment #2 | ||||||||
Percent Fully Allocated | 0% | 10% | No | ||||||
|
Table 2.1 : In this scenario, a simple percent average allocated calculation is used to calculate the Percent Fully Allocated 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 Percent Fully Allocated >= Min Allocation % ?) | |
---|---|---|---|---|---|---|---|---|---|
1 | A | 10 | 0 | 5 | 5 | ||||
Percent Fully Allocated | 5/10*100 = 50% | 10% | Yes | ||||||
|
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 Percent Fully Allocated >= Min Allocation % ?) | |
---|---|---|---|---|---|---|---|---|---|
Supplied | Shipment #3 | ||||||||
Percent Fully Allocated | 0% | 10% | No | ||||||
|