Quantity Available is not correct in Sage 100 Sales Order Entry

Description

Quantity Available is not correct in Sales Order Entry

Cause 

The setting in Inventory Management Options is set to include Purchase Orders and/or Work Orders.

Resolution

Change the setting in Inventory Management Options to your desired choosing:

1. Open Inventory Management, Setup, Inventory Management Options
2. On the Main tab, click the drop-down for Include in Quantity Available
3. Select the method used to calculate the quantity available:
   • Select Purchase Orders to include quantity on purchase orders in the quantity available calculation
   • Select Work Orders to include quantity on work orders and quantity required for work orders in the quantity available calculation
   • Select POs and WOs to include quantity on both purchase orders and work orders, and quantity required for work orders in the quantity available calculation
   • Select No POs and WOs to exclude quantity on purchase orders and work orders in the quantity available calculation.
4. The quantity available is determined using the following calculation:
   (Quantity on Hand + Quantity on PO + Quantity on WO) – (Quantity on SO + Quantity on Back Order + Quantity Required for WO)