NumberCruncher Inventory Management Products | FAQ’s

Home ► Support

Understating Quantities in All Orders

All Orders 4.X

There are different quantities that All Orders works with. The following is a description of how it works. The basis for all quantities in All Orders is derived as follows

Adjustments	+ / -
Work Orders - Finished Goods (Produced)	+
Work Orders - Components (Allocated)	-
Disassemblies - Finished Goods (Produced)	-
Disassemblies - Components (Allocated)	+
Receiving	+
Customer Return	+
Ship Doc	-
Vendor Return	-
Transfer	+ / -

For any items you can view this calculation by printing the Inventory Movement Detail report. We call this quantity 'Sum Qty' meaning the net of all transactions. We adjust this quantity for various purposes as follows:

Note: Many of the values you will see can be viewed on the Inventory Status report.

Inventory List

The column called 'Quantity' is the Sum Qty for all available locations. In other words if any transaction is from a location or bin that is marked as unavailable, it will be excluded.

The column called QB QOH is the quantity on hand in QuickBooks. This quantity is updated during a selective sync of Item Inventory. Why is QB QOH and Quantity different on the Item List ?

Item Info

Available = Sum Qty for available locations minus 'In Production'

In Production = Finished Goods Produced on work order whose status is NOT finished.

Unavailable = Sum Qty for unavailable locations

On Order = Open purchase orders (Ordered - Received) plus finished goods Required on work order whose status is NOT finished (Ordered - Produced)

Required = Open sales orders (Ordered - Shipped) plus components on work order whose status is NOT finished (Required - Allocated)

Reserved = Open sales orders (Ordered - Shipped) plus components on work order whose status is NOT finished (Required - Allocated) that are linked to an open purchase order or work order.

Deficiency = Required minus Available minus On Order minus In Production (Positive only)

Inventory Status Report

Committed = Ship Docs with 'Is Shipped' is No

Allocated = Allocated components on work order whose status is NOT In Production

RMA = Customer Returns with 'Is Received' is No (Unchecked)

In Transit = Receivers or Transfers with 'Is Received' is No

Available to Ship = Available minus 'In Transit' minus 'RMA'

Owned = Sum Qty plus 'Committed' plus 'Allocated' minus 'RMA'

On Hand = Sum Qty plus 'Committed' plus 'Allocated' minus 'RMA' minus 'In Transit'

Quantities used by All Orders in Transactions:

Allocating work orders uses 'Available'

Creating ship docs from sales orders uses 'Available'

When marking a ship doc as 'Shipped' uses 'Available to Ship'

Quantity adjustment uses 'Owned'

1/17/2007