Stock Status

The Stock Status tab displays information about all locations at which a part is stocked.

Tip: You can use the filter to restrict the information that displays to a specific part ID, part suffix, inventory month, keyword, stock status, product category, or part classification, among others. The list of searchable fields on the filter is extensive; use the scroll bar to view them all. If you specify a cross-reference part ID that cannot be found, the applicable part ID displays.

Detail View Header

The fields in the top section of this tab define the data that displays.

Part ID

Identifier of the part currently selected in the grid or that you are defining.

Note: If there is a check in the Enable automatic part numbering field on the Parts Items -> Setup -> Product Categories screen, the part ID is assigned automatically. Its characteristics, if any, are based on information entered in other fields on that screen.

The part ID may only consist of valid bar code characters. This field has a zoom button to the Parts Items -> Cross-references screen, which defines cross-references of part IDs. It also has a list box. The part description displays to the right of the ID. This field is required.

The combination of this part ID and the part suffix must be unique for each part.

To delete a part and all its data from inventory, refer to how to delete a part from inventory.
To delete a part from a specific location, use the Basic Info tab on the Parts Items -> Location Information screen.

Note: You cannot delete a record that has part quantities to be reconciled.

Part suffix

Number associated with the part in the Part ID field, which distinguishes it from other parts with the same part ID.

This applies only if the part ID is a valid part ID.

New part/location/inventory

If you are entering a new part, you can click the New part/location/inventory button to launch the Add New Part wizard. The wizard will walk you through specifying the required data for the Part Primary, Part Location, and Inventory Adjustment screens.

Note: The wizard must be activated before it will launch. Refer to Add New Part Wizard for more information.

Detail View

Data in the fields on the bottom section of this tab are presented in a screen group. Data returned is limited to 10 rows of the most recently updated information in ascending order by location ID. To view more than 10 rows, use the Queries/Reports -> Query/Report Generator screen to create and run a report that includes the information. You can also use Web Modules Reporting, Microsoft Access, or any other reporting tool to create and run reports. Refer the related documentation for these products. All fields are display only.

Stock Status Screen Group Data Table

Location ID

Identifier of the location for which the fields in this row display the inventory status of this part.

Location IDs are defined on the Basic Info tab of the Setup -> Organization Structure -> Locations -> Primary Information screen.

Location name

Name of the location.

Bin ID

Identifier of the bin in which the part is stored.

Note: To define an initial parts inventory and specify the quantity and value of the part initially on hand, or to reduce the values in the following fields to zero in order to delete the part from inventory (either CENTRALLY or BY LOCATION or ENTERPRISE), you must use the Parts Activity -> Adjustments screen.

Quantity on hand

Quantity of this part that is on hand at this location.

Value on hand

Value of the quantity of this part that is on hand at this location.

Note: When you close an internal rebuild order, the value on hand = previous value on hand + internal labor + internal parts + commercial labor and parts + (core value * rebuild quantity).

Qty on order

Quantity of this part that is on order for this location.

Value on order

Value of the quantity of this part that is on order at this location.

Average price

Average price of the part at this location.

Qty out for repair

Total quantity of this part that is out for repair. This field updates when you insert a part ID on the Line Items tab of the Parts Repair -> External Rebuilds screen.

ABC code

Inventory management classification for this part.

Date and time added

Date and time the part was added to inventory at the location ID.

Totals for all locations

Quantity

on hand: Total quantity of this part that is on hand for the entire organization.
on order: Total quantity of this part that is on order for the entire organization.

Value

on hand: Total value of this part that is on hand for the entire organization.
on order: Total value of this part that is on order for the entire organization.

Average price

on hand: Average price of the part that is on hand for the entire organization.