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.
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 ?
Available = Available to Sell.
In Production = Finished Goods Produced on work order whose status is NOT finished.
Unavailable = Qty in unavailable locations or bins
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)
Committed = Ship Docs not checked 'Is Shipped'
Allocated = Allocated components on work order whose status is NOT In Production + Vendor Returns not checked as 'Received' + Inventory allocated to sales order that have not yet been shipped
RMA = Customer Returns with 'Is Received' is No (Unchecked)
In Transit = Receivers or Transfers not checked as 'Received'.
Owned =All Inventory Movement plus 'Committed' plus 'Allocated' minus 'RMA'
On Hand = All Inventory Movement 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'. Available to Ship = Available minus 'In Transit' minus 'RMA'
Quantity adjustment uses 'Owned'