Contents of the View Part Inventory Screen
Use the fields and options to configure the View Part Inventory screen.
Search Criteria
Populate any field in this group box to view matching part/project information for that field, and click . For example, if you populate the Description field with C, select the Begins With option in the Part/Project Selection Criteria group box, and execute the query, all applicable inventory parts (that is, inventory parts included in a purchase order, reservation, or other planning capacity) that have a description beginning with the letter C display in the table window.
Field | Description |
---|---|
Part |
Enter, or click to select, the part ID you wish to view inventory information for. If you do not select the Exact Match option in the Part/Project Selection Criteria group box, you can enter a partial part number value and have Costpoint return inventory for all part IDs that meet the selection criteria value. If you leave this field blank, Costpoint will not use part ID as a criterion for selecting which inventory information to display. |
Rev |
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. |
Description |
If you want to narrow your search by the part's description, enter a description in this unlabeled field, select an option in the Part ID/Project Selection Criteria group box to show how you want selections matched, and then click . If you select a specific part in the header screen, the description field automatically defaults. |
Make/Buy |
Use the drop-down list to select the Make/Buy status for the part. If you leave this field blank, both are selected. If you select a status in this field, Costpoint selects only the parts that share the same make/buy code. Make/Buy codes are defined on the Manage Parts screen in Product Definition. If you leave this field blank, Costpoint does not select parts by make/buy code. |
U/M |
This field displays the default or inventory unit of measure for the selected part (if only one part was selected). |
Planner |
Enter, or click to select, the planner ID you wish to view inventory information for. If you specify a planner in this field, Costpoint checks the Planner Assignment value on the Configure Production Control Settings screen to determine how to select inventory rows.
|
Project |
To limit the inquiry to inventory for a particular project, enter, or click to select, the project ID. The project name automatically displays in the unlabeled field to the right. If you do not select the Exact Match option in the Part/Project Selection Criteria group box, you can enter a partial project number value and have Costpoint return inventory for all project IDs that meet the selection criteria value. |
Netting Group |
To limit the inquiry to an inventory for a particular netting group, enter, or click to select, the netting group ID. Netting groups are a group of inventory projects that are planned together. Projects are assigned to netting groups on the Manage Inventory Projects screen in the Inventory module. |
Include Inventory From Other Companies |
This check box displays if you did not select the Separate Items by Company check box on the Corporate Settings block of the Configure Product Definition Settings screen. If you selected the Separate Items by Company check box, this check box is hidden and you only see inventory for the company you are currently logged into. Select this check box to include inventory from other companies (in addition to inventory that is assigned to the company you are currently logged into) in the result set. If this check box is not selected, only those parts for the selected projects that are linked to your company ID display in the result set. |
Suppress Zero Quantity Rows |
Select this check box if you do not want to see inventory records that currently have zero quantities for all inventory, on-order, on-requisition, reserved, and owed. |
Part/Project Selection Criteria
Use the options in this group box to specify how you want your selections to match the part and project fields.
Field | Description |
---|---|
Exact Match |
Select this option to find an exact match for the Part or Project text you entered. |
Begins With |
Select this option to find all items that begin with the Part or Project text you entered. This is the default. |
Ends With |
Select this option to find all items that end with the Part or Project text you entered. |
Contains |
Select this option to find all items containing the Part or Project text you entered. |
Part Inventory Inquiry
This table displays summary-level part information. To inquire at a more detailed level, select the line for which you want additional information and click the appropriate link at the bottom of the screen to expand the inquiry.
Field | Description |
---|---|
Part |
This field displays the Part ID of the inventory record. |
Rev |
This field displays the revision number for the inventory record part. This column is hidden if you entered a Rev in the header. |
Description |
This field displays a description of the inventory record part. |
U/M |
This field displays the default or inventory unit of measure for the selected part. |
Make/Buy |
This field displays the M (Make)/B (Buy) status for the selected part. |
Project |
This field displays the project ID associated with the inventory record. This field does not display if the inquiry was limited to a single project. |
Current Available Qty |
This field displays the current 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. |
Net Available Quantity |
This column displays the net available quantity for this part. Costpoint calculates this value by adding the On Hand Quantity, In Inspection Quantity, In Shipping Quantity, On Order Quantity, On 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. |
On Hand Quantity |
This field displays the quantity of parts for the selected part and project that are in on-hand locations. |
In Inspection Quantity |
This field displays the quantity of parts for the selected part and project, received but not yet accepted or rejected, or that are in a reinspection location. |
In MRB Quantity |
This field displays the quantity of parts for the selected part and project that are in MRB (Material Review Board) locations. |
In Shipping Quantity |
This field displays the quantity of parts for the selected part and project that are in shipping locations. |
On Order Quantity |
This field displays the quantity of parts for the selected part and project that are on open purchase and manufacturing orders. |
Requisition Quantity |
This field displays the quantity of parts for the selected part and project that are on open purchase requisitions. |
Reserved Quantity |
This field displays the quantity of parts for the selected part and project that have been reserved by inventory reservations, manufacturing orders, and sales orders. |
Owed Quantity |
This field displays the quantity of parts for the selected part and project that are owed to it from another project (a transfer reservation). |
Planned Reserved Qty |
This field displays the quantity of parts (for the selected project) for inventory requests that have not been fully approved. |
Planned Owed Qty |
This field displays the quantity of parts (for the selected project) for inventory transfer requests that have not been fully approved. |
On Hold Quantity |
This field displays the quantity of parts for the selected part and project that are in on-hold locations. |
Common Inventory |
This field displays Y (Yes) or N (No) depending on whether this is a company-owned, non-allocated inventory project. |
Commodity |
This field displays the commodity code for the inventory row's part. |
Project Abbrev |
This field displays the project abbreviation associated with the inventory record. This field does not display if the inquiry was limited to a particular project. |
Project Name |
This field displays the project name associated with the inventory record. This field does not display if the inquiry was limited to a particular project. |
Netting Group |
This field displays the netting group ID associated with the project on the selected line. |
Allow Substitutes |
This field displays Y (Yes) or N (No) depending on whether or not substitutes are allowed for the part for the project specified on the row. This is defined on the Manage Parts screen in Product Definition. |
Forecast Qty |
This field displays the sum of open sales and user-defined forecast quantities for the inventory record's part and project. |
Lead Time Days |
This field displays the total lead time that is calculated on the Lead Time subtask of the Planning Details subtask of the Manage Parts screen. This quantity is used as the MPS time fence only if the MPS Time Fence Method is set to Use Part Lead Time on the Configure Master Production Scheduling Settings screen. |
Buyer |
This field displays the buyer ID for the part. |
Planner |
This field displays the planner ID for the part. |
Default Warehouse |
This field displays the default warehouse for the selected part. |
Default Location |
This field displays the default warehouse location for the selected part. |
Order Policy |
The order policy type represents the lot-sizing technique to be used for this part:
|
Multiple Lot Size |
The number displayed in this field is 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. |
Period Order Days |
This field displays the number of shop days for which Costpoint combines net requirements to create a planned order for the selected part. This field displays the planning type for this part:
|
Reorder Quantity |
This field displays the reorder quantity. |
Subtasks
Subtask | Description |
---|---|
Inv Abbrev | Click this link to access the Inv Abbrev subtask, which provides detailed information about inventory abbreviations. |
Proj Loc | Click this link to access the Proj Loc subtask for the selected line. |
Sub Parts | Click this link to access the Sub Parts subtask for the selected line. |
Inv POs | Click this link to access the Inv POs subtask for the selected line. |
Requirements | Click this link to access the Requirements subtask for the selected line. |
Location | Click this link to access the Location subtask for the selected line. |
Planning | Click this link to access the Planning subtask for the selected line. |
Requisitions | Click this link to access the Requisitions subtask for the selected line. |
Forecasts | Click this link to access the Forecasts subtask for the selected part/project. |
Non-Inv POs | Click this link to access the Non-Inv POs subtask for the selected part/project. |
MOs | Click this link to access the MOs subtask for the selected part/project. |
Plnd Orders | Click this link to access the Plnd Orders subtask for the selected part/project. |
Plnd Rqmts | Click this link to access the Plnd Rqmts subtask for the selected part/project. |
ECNs | Click this link to access the ECNs subtask for the selected part/project. |
Part Documents | Click this link to access the Part Documents subtask, where you can view a list of the documents associated with the selected part. |
Proj Sub Parts | Click this link to access the Proj Sub Parts subtask, to view the current information for the substitute part of a selected project. |