Quantity Available

Hello trying to find what table the Available qty is located... Can't find in CI_Item or IM_itemwarehouse 

  • 0

    It's a calculation based on the option selected in Inventory Management Options.  It is not an actual field in a table.

  • 0

    From the Help files:

    Include in Quantity Available

    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.