Warehouse Inventory Subtask

Use this subtask to view current inventory information by warehouse for the part selected on the main screen grid. If you enter a warehouse ID in the main screen, the inventory information displays for the particular warehouse; otherwise, the information is for all warehouses. This screen displays inventory for the project(s) selected on the main screen, or all projects, depending on the Display Option selected.

Part

This field displays the identifier of the part selected on the Edit MPS Action Messages screen. The part's description displays in the adjacent unlabeled field.

Rev

This field displays the part revision number.

U/M

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

Warehouse

This field displays the identifier of the warehouse for the inventory entered on the header of the main screen.

View All Warehouses

Select this checkbox to view the part's inventory across all warehouses. This option is disabled if no value was entered in the Warehouse field on the header of the main screen.

Project Selection Option

This field displays the value specified for the Project Selection Option on the main screen and may determine the rows that display in the table window (grid) below.

Selected Project

This field displays the ID of the selected project from the main screen header and may determine the rows that are shown in the table window. The project name and abbreviation display in the adjacent unlabeled fields.

On Hand Qty

This field displays the sum of all on-hand quantities in the grid for the selected warehouses and inventory projects.

In Inspection Qty

This field displays the sum of all in-inspection and reinspection quantities in the grid for the selected warehouses and inventory projects.

In Shipping Qty

This field displays the sum of all in-shipping quantities in the grid for the selected warehouses and inventory projects.

Display Option

Use the options in this group box to include only selected inventory projects or all projects in the grid fields. Selecting a new radio button causes the table window (grid) to reload.

View Selected Inv Projects

Select this radio button to view the part's inventory for the inventory projects selected on the main screen. This option is the default.

View All Inventory

Select this radio button to view the part's inventory across all inventory projects.

Inventory Quantities by Warehouse/Inv Abbrev Table Window

This table window displays the details of the inventory for the part according to the viewing criteria selected. Sorting is by project ID, inventory abbreviation code, and warehouse.

Warehouse

This field displays the ID of the warehouse where the inventory is kept.

Inventory Abbreviation

This field displays the inventory abbreviation code that owns the inventory.

Inventory Abbreviation Name

This field displays the name of the row's inventory abbreviation.

Account Type

This field displays the account type of the owning inventory abbreviation: "E" (Expense), "A" (Asset), or "G" (Government Furnished) as set up in the Inventory Abbreviations subtask of the Inventory Projects screen in the Inventory application.

On Hand Qty

This field displays the sum of all quantities of the part/warehouse/inventory abbreviation combination that are in on-hand locations.

In Inspection Qty

This field displays the sum of all quantities of the part/warehouse/inventory abbreviation combination that are in inspection and reinspection locations.

In Shipping Qty

This field displays the sum of all quantities of the part/warehouse/inventory abbreviation combination that are in shipping locations.

In MRB Qty

This field displays the sum of all quantities of the part/warehouse/inventory abbreviation combination that are in Materials Review Board locations. These quantities are considered available for MRP/MPS planning if the Incl MRB as Available Inventory checkbox is selected in Production Control Settings.

On Hold Qty

This field displays the sum of all the quantities of the part/warehouse/inventory abbreviation combination that are in hold locations. These quantities are not considered available for MRP and MPS planning purposes.

Project

This field displays the ID of the project associated with the inventory abbreviation.

Project Name

This field displays the name of the inventory project associated with the inventory abbreviation.

Project Abbrev

This field displays the abbreviation of the project associated with the inventory abbreviation.

Inv Abbrev Active

This field specifies whether the inventory abbreviation is active or not. If set to "Y," you can receive inventory into and issue out of the inventory abbreviation.  If set to "O " (Outgoing Only), you can issue inventory out of the abbreviation, but cannot receive more inventory into the abbreviation.  If set to "N," no inventory can received into or issued out of the inventory abbreviation.

Tables

The Costpoint tables impacted are listed in the following table: