Inventory Levels for Work Orders

This article describes what happens to Inventory Levels (for both the 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).

Bill of Materials Components

1. Status: Planned

  • No changes for components.

2. Status: In Process

  • Qty Posted: no change
  • Qty In Non Posted: no change
  • Qty Out Non Posted: no change
  • Qty Real Time On Hand: no change
  • Qty Reserved Work Order: increased
  • Qty Available: decreased
  • Qty On Work Order: no change

3. Status: Picked

  • Qty Posted: no change
  • Qty In Non Posted: no change
  • Qty Out Non Posted: increased
  • Qty Real Time On Hand: decreased
  • Qty Reserved Work Order: decreased
  • Qty Available: no change
  • Qty On Work Order: no change

4. Status: Complete / Ready to Post

  • No changes for components.

5. Status: Posted

  • Qty Posted: decreased
  • Qty In Non Posted: no change
  • Qty Out Non Posted: decreased
  • Qty Real Time On Hand: no change
  • Qty Reserved Work Order: no change
  • Qty Available: no change
  • Qty On Work Order: no change

Finished Good Assembly

1. Status: Planned

  • Qty Posted: no change
  • Qty In Non Posted: no change
  • Qty Out Non Posted: no change
  • Qty Real Time On Hand: no change
  • Qty Reserved Work Order: no change
  • Qty Available: no change
  • Qty On Work Order: increased

2. Status: In Process

  • No changes for finished goods.

3. Status: Picked

  • No changes for finished goods.

4. Status: Complete / Ready to Post

  • Qty Posted: no change
  • Qty In Non Posted: increased
  • Qty Out Non Posted: no change
  • Qty Real Time On Hand: increased
  • Qty Reserved Work Order: no change
  • Qty Available: increased
  • Qty On Work Order: decreased

5. Status: Posted

  • Qty Posted: increased
  • Qty In Non Posted: decreased
  • Qty Out Non Posted: no change
  • Qty Real Time On Hand: no change
  • Qty Reserved Work Order: no change
  • Qty Available: no change
  • Qty On Work Order: no change