The "Item Availability by Item" page will show the supply, demand, and item availability by the week or by month.
Run the report from the Item List or from the Administration menu under Inventory.
Drill down on the report values to see detailed entries.
Inventory Period Type
By Week or By Month. The default value comes from Demand Planning Setup, Inventory Period Type.
Filter by Item No.
Choose multiple Categories.
Qty on Hand
Shows the current quantity on hand. (Both Safety Stock and Max fields are from the Item record.)
(+) Qty. on Purchase Orders
Shows the outstanding quantity from purchase orders. The expected receipt dates on the purchase lines are used to place the quantities into each date bucket.
(+)Qty. on Work Orders
Shows the quantity from open work orders. The ending dates on the work orders are used to place the quantities into each date bucket.
Shows the quantity from an active Sales Forecast. The forecast dates are used to place the quantities into each date bucket.
(-) Qty. on Sales Orders
Shows the outstanding quantity from sales orders. The shipment dates are used to place the quantities into each date bucket.
(+) Qty. on Forecast Consumption
In order not to double count the forecasted qty in the report total, GoldFinch will examine the quantity forecasted along with the total quantity from sales orders (not just outstanding quantity). If both of these have a value, the "Qty. on Forecast Consumption" will show the lower value of the two. This will then be added into the calculation to generate the Qty. Available. Read Forecast Consumption to learn more.
(-) Qty on Component Work Lines
Shows the quantity on the component lines from open work orders. The due dates on the work order lines are used to place the quantities into each date bucket.
Reflects the total quantity available for the time frame after all the above additions and subtractions have been made to the quantity on hand.