x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion Quantity Available

Quantity Available

Posted By Bob@TED 12 days ago

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

Top Replies

BigLouie 12 days ago +1

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

Parents

0 BigLouie 11 days ago
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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 BigLouie 11 days ago
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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data