Enter, or click to select, a part ID. If you leave this field blank, Costpoint will not use part ID as a criterion for selecting inventory information to display.

Enter, or click to select, the desired revision for this part ID, or leave the field blank to view inventory information for all revisions of the selected parts.

From the drop-down list, select Make or Buy to restrict the selection to make parts or buy parts. If you leave this field blank, Costpoint does not select parts by make/buy code.

This column displays the default or inventory unit of measure for the selected part.

Enter, or click to select, the planner ID you want to view inventory information for. If you specify a planner in this field, Costpoint checks the value in the Planner Assignment group box on Configure Production Control Settings to determine how to select inventory rows.

• If you assign planners by part, it includes inventory information for all parts assigned to the entered planner ID.
• If you assign planners by commodity code, it includes inventory information for all parts that have commodity codes assigned to the entered planner ID.
• If you assign planners by project, it includes inventory information for all projects assigned to the entered planner ID.
• If you assign planners by netting group, it includes inventory information for all projects linked to the netting groups assigned to the entered planner ID.

To limit the inquiry to inventory for a single project, enter, or click to select, the project ID.

If you did not select the Exact Match option, you can enter a partial project number value and have Costpoint return inventory for all project IDs that meet the selection criteria value.

To limit the inquiry to a single netting group, enter, or click to select, the netting group ID. Netting groups are groups of inventory projects that will be planned together.

This check box appears if you clear the Separate Items By Company check box in the Corporate Settings block of the Configure Product Definition Settings screen. (If you select the Separate Items By Company check box, this check box is hidden.)

Select this check box to include inventory from other companies and projects in the inquiry's result set. When Costpoint searches lower levels for inventory, order, requisition, requirement, and part/project information, lower-level rows also display from other companies.

If you clear this check box, only those project IDs that are linked to your user ID and company display in the result set.

Select this check box if you do not want to view parts that currently have zero quantities for all inventory, on-hand, on-req, reserved, and owed. If you clear this check box, parts that have all zero quantities are not excluded from the query.

Select this option to find an exact match for the Part or Project text you entered.

Select this option to find all items that begin with the Part or Project text you entered.

Select this option to find all items that end with the Part or Project text you entered.

Select this option to find all items containing the Part or Project text you entered.

• RMA On Order Qty
• RMA Received Qty
• RMA Accepted Qty
• RMA Rejected Qty

This column displays the part ID of the inventory record.

This field displays the revision number for the inventory record part. This column is hidden if you entered a Rev in the Search Criteria group box.

This column displays a description of the inventory record part.

This field is visible only if the Use Part Data Security Controls check box is selected on the Configure Product Definition Settings screen, which indicates that the assembly part is subject to data security restrictions, as defined in the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR).

If enabled, this field displays one of the following values to indicate whether the part you are accessing is subject to part data security restrictions and whether you have the necessary authorization to access information for that part:

• Unrestricted: The part is not subject to data security restrictions.
• Restricted: The part is subject to data security restrictions and you are authorized to access detailed part information.
• ***UNAUTHORIZED***: The part is subject to data security restrictions and you are not authorized to access or view part information. This value is displayed in red background color.

This column displays the default or inventory unit of measure for the selected part.

This field displays M (Make) or B (Buy) for the selected part.

This column displays the project ID associated with the inventory record. This column does not display if the inquiry was limited to a single project.

This column displays the number of parts for the selected part and project that are available for use. Costpoint calculates this value by adding the On Hand Quantity, In Inspection Quantity, In Shipping Quantity, On Order Quantity, Requisition Quantity, Owed Quantity, Planned Owed Qty, and In MRB Quantity (only if you selected the Incl MRB as Available Inventory check box on the Configure Production Control Settings screen), and then subtracting the Reserved and Planned Reserved quantities.

This column displays the currently available quantity for the part/project combination. It is the sum of on-hand and in-inspection quantities, minus the reserved quantity, for the part/inventory abbreviation combination.

This column displays the quantity of parts for the selected part and project that are in On Hold locations.

This column displays the quantity of parts for the selected part and project that have been received but have not been accepted or rejected or that are in a reinspection location.

This column displays the quantity of parts for the selected part and project that are in MRB (Material Review Board) locations.

This column displays the quantity of parts for the selected part and project that are in shipping locations.

This column displays the quantity of parts for the selected part and project that are on open purchase and manufacturing orders.

This column displays the quantity of parts for the selected part and project that are on open purchase requisitions.

This column displays the quantity of parts for the selected part and project that have been reserved by inventory reservations, manufacturing orders, and sales orders.

This column displays the quantity of parts for the selected part and project that are owed to it from another project (a transfer reservation).

This column displays the quantity of parts for the selected project for inventory requests that have not been fully approved.

This column displays the quantity of parts for the selected project for inventory transfer requests that have not been fully approved.

This column displays the quantity of parts for the selected part and project that are in On Hold locations.

This column displays Y (Yes) or N (No) to indicate whether this is a company-owned, non-allocated inventory project.

This column displays the commodity code for the inventory row's part.

This column displays the project abbreviation associated with the inventory record. This column does not display if the inquiry was limited to a single project.

This column displays the project name associated with the inventory record. This column does not display if the inquiry was limited to a single project.

This column displays the netting group ID associated with the project on the selected line.

This column displays Y (Yes) or N (No) to indicate whether substitute parts are allowed for the part and project on the row.

This column displays the sum of open sales and user-defined forecast quantities for the inventory record's part and project.

This is the total lead time (in days) that is calculated in the Planning subtask of the Manage Parts screen (in Costpoint Product Definition).

This quantity is used as the Master Production Schedule (MPS) time fence only if the MPS Settings – MPS Time Fence Method is set to Use Part Lead Time.

This field displays the buyer ID assigned to the selected part.

This field displays the planner ID assigned to the selected part.

This field displays the default warehouse for the selected part.

This field displays the default warehouse location for the selected part.

This field displays the order policy type. The order policy type represents the lot-sizing technique to be used for this part which can be one of the following:

• Discrete Lot Size: This type has the MPS/MRP processes set the planned order quantity equal the quantity of the net requirements.
• Min/Mult Lot Size: This type requires that the order quantity meet the minimum and multiple lot sizes specified for the part.
• Order to Point: The Inventory Reorder Process will automatically place a purchase requisition for this part whenever the inventory quantity is less than or equal to the reorder point. It will order the quantity necessary to bring the quantity up to the Order to Point quantity. The Order to Point and Reorder Point are defined on the Manage Part Project Data screen in Product Definition.
• Period: This type requires that the lot size equal net requirements for the specified number of calendar or shop days.
• Reorder Point: The Inventory Reorder Process will automatically place a purchase requisition for this part whenever the quantity on hand is reduced to or below a specified level (reorder point level). The Reorder Point Quantity field on the Manage Parts screen will be used as the requisition's order quantity. The Order-To point and Reorder Point are defined on the Manage Part Project Data screen in Product Definition.

This field displays the number by which the lot size must be multiplied if the calculated planned order is to meet the net requirements for the selected part.

This field displays the number of shop days for which Costpoint will combine net requirements to create a planned order for the selected part.

This field dipslays the planning type for this part:

• [None]: The part has not been assigned a planning method.
• MRP: The part will be planned by the Materials Requirement Planning process.
• Reorder: The part will be planned using the Inventory reorder report.
• MPS: The part will typically be planned by the Master Production Scheduling process, but can be planned by MRP if you select the Plan MPS Part Requirements check box on the Configure Materials Requirements Planning Settings screen.

This field displays the reorder quantity for the selected part from the Manage Parts screen in Costpoint Product Definition.

This field is visible if the Include RMA Inventory checkbox is selected.

This field is visible if the Include RMA Inventory checkbox is selected.

This field is visible if the Include RMA Inventory checkbox is selected.

This field is visible if the Include RMA Inventory checkbox is selected.