Inventory Levels for Work Orders

These tables describes what happens to Inventory Levels (for both the Finished Good Assembly and the BOM Components) at each stage of the Work Order process.

To replicate these values, make sure you have the Reserved Work Order setting checked to be Excluded from Available (this is done in Administration > System Setup > Inventory & Marketing).

Single Warehouse Work Order

1. Status: Planned

Qty Reserve Value Components Finished Good
Qty Posted no change no change
Qty In Non Posted no change no change
Qty Out Non Posted no change no change
Qty Real Time On Hand no change no change
Qty Reserved Work Order no change no change
Qty Available no change no change
Qty On Work Order no change increased

2. Status: In Process

Qty Reserve Value Components Finished Good
Qty Posted no change
 no change
Qty In Non Posted no change
 no change
Qty Out Non Posted no change
 no change
Qty Real Time On Hand no change
 no change
Qty Reserved Work Order increased
 no change
Qty Available decreased
 no change
Qty On Work Order no change
 no change

3. Status: Picked

Qty Reserve Value Components Finished Good
Qty Posted no change
 no change
Qty In Non Posted no change
 no change
Qty Out Non Posted increased
 no change
Qty Real Time On Hand decreased
 no change
Qty Reserved Work Order decreased
 no change
Qty Available no change
 no change
Qty On Work Order no change
 no change

4. Status: Complete / Ready to Post

Qty Reserve Value Components Finished Good
Qty Posted no change
 no change
Qty In Non Posted no change
 increased
Qty Out Non Posted no change
 no change
Qty Real Time On Hand no change
 increased
Qty Reserved Work Order no change
 no change
Qty Available no change
 increased
Qty On Work Order no change
 decreased

5. Status: Posted

Qty Reserve Value Components Finished Good
Qty Posted decreased
 increased
Qty In Non Posted no change
 decreased
Qty Out Non Posted decreased
 no change
Qty Real Time On Hand no change
 no change
Qty Reserved Work Order no change
 no change
Qty Available no change
 no change
Qty On Work Order no change
 no change
Multi Warehouse Work Orders

Multi-warehouse work orders create automatic warehouse transfers to move inventory between warehouses.

1. Status: Planned

Qty Reserve Value Components Finished Good
Qty Posted no change no change
Qty In Non Posted no change no change
Qty Out Non Posted no change no change
Qty Real Time On Hand no change no change
Qty Reserved Work Order no change no change
Qty Available no change no change
Qty On Work Order no change increased (WIP warehouse)

2. Status: In Process

Warehouse transfer automatically created to move the BOM components from the Component warehouse to the WIP warehouse.

Qty Reserve Value Components Finished Good
Qty Posted no change
 no change
Qty In Non Posted increased (WIP warehouse)
 no change
Qty Out Non Posted increased (Component warehouse)
 no change
Qty Real Time On Hand no change
 no change
Qty Reserved Work Order increased (WIP warehouse)
 no change
Qty Available decreased (Component warehouse)
 no change
Qty On Work Order no change
 no change

3. Status: Picked

Qty Reserve Value Components Finished Good
Qty Posted no change
 no change
Qty In Non Posted no change
 no change
Qty Out Non Posted increased (WIP warehouse)
 no change
Qty Real Time On Hand decreased (WIP warehouse)
 no change
Qty Reserved Work Order decreased (WIP warehouse)
 no change
Qty Available no change
 no change
Qty On Work Order no change
 no change

4. Status: Complete / Ready to Post

Warehouse transfer automatically created to move the completed assembly from the WIP warehouse to the Finished Good warehouse.

Qty Reserve Value Components Finished Good
Qty Posted no change
 no change
Qty In Non Posted no change
 increased (WIP and Finished Good warehouses)
Qty Out Non Posted no change
 no change
Qty Real Time On Hand no change
 increased (Finished Good warehouse)
Qty Reserved Work Order no change
 no change
Qty Available no change
 increased (Finished Good warehouse)
Qty On Work Order no change
 decreased (WIP warehouse)

5. Status: Posted

This step also requires posting the Warehouse Transfers.

Qty Reserve Value Components Finished Good
Qty Posted decreased (Component warehouse)
 increased (Finished Good warehouse)
Qty In Non Posted no change
 decreased (WIP and Finished Good warehouses)
Qty Out Non Posted decreased (Component warehouse)
 no change
Qty Real Time On Hand no change
 no change
Qty Reserved Work Order no change
 no change
Qty Available no change
 no change
Qty On Work Order no change
 no change