Skip to main content

Item Availability by Item Report

Updated
Applies toInventory ReportsAudienceAll usersLast updatedSeptember 29, 2025

The Item Availability by Item report in GoldFinch provides a comprehensive view of an item's supply, demand, and availability, allowing you to see the data organized by week or by month. This report helps you track inventory movement and project availability for future timeframes.

Running the Report

You can generate the report from two locations:

  • Item List: Access the report directly from the item list.

  • Administration Menu: Navigate to Inventory under the Administration menu to run the report.

Once the report is generated, you can drill down into specific values to see more detailed transactional entries.


Filter Options

Filter Name

Explanation

Inventory Period Type

Choose to display data by Week or Month. The default is set from the Demand Planning Setup screen.

Item No.

Filter the report by a specific item number.

Item Category

Select multiple categories to filter the report.

Field Descriptions

Field Name

Explanation

Qty on Hand

Displays the current on-hand quantity.

(+) Qty on Purchase Orders

Shows the outstanding quantity from purchase orders, distributed across dates based on expected receipt dates.

(+) Qty on Work Orders

Reflects the quantity from open work orders, assigned to dates based on work order end dates.

(-) Qty Forecasted

Quantity from an active Sales Forecast, assigned to date buckets based on forecast dates.

(-) Qty on Sales Orders

Shows the outstanding quantity from sales orders, distributed according to shipment dates.

(+) Qty on Forecast Consumption

Adjusts the forecasted quantity to avoid double-counting with sales orders. The lower of the forecast or sales order quantities is added to the total.

(-) Qty on Component Work Lines

Represents the quantity from component lines in open work orders, distributed by due dates on the work order lines.

Qty Available

This is the total available quantity after considering all the above additions and subtractions. It reflects availability for the selected time frame.

Benefits of the Report

The Item Availability by Item report provides a real-time snapshot of inventory levels, giving you detailed insights into supply, demand, and availability over specific timeframes. This enables you to efficiently manage stock, avoid shortages, and optimize your demand planning strategies

Article Item-Availability-by-Item-Report  ·  Last updated September 29, 2025 · GoldFinch ERP Help Center

Comments

0 comments

Please sign in to leave a comment.