Status

Updated July 11, 2024

Applies to : Estimating and Order Entry Material (All Component Types that have material)

The Status button will allow the user to view various information about a material that is inventoried and has any transactions against it.

Click the Status button and the system will display the current status of an inventory item. 

All of the fields are for display only and cannot be edited. However, by clicking the ellipses  the user can view even more information about certain aspects of the Items data.

Code : An alphanurmeric entry that is used for the Material Code.

Description : Material description.

Quantity On Hand : Summary of the quantities from all Locations.

Quantity in Default Location : Total of the Material in the Default Location.

Quantity not in Default Location : Total of the Material that is located elsewhere.

Quantity Allocated : Shows the total required to fulfill all Orders that have a Job Status of IN PROCESS.

Quantity Allocated (On Hold) : Shows the total required to fulfill all Orders have a Job Status of ON HOLD.

Requisitions : Shows the total of all Requisitions that have not been converted to Purchases Orders.

Quantity on Order : The summary of all Purchases Orders that include the material Item.

Qty In Production :  Shows the summary of all Orders that use the Material but have not had the Material Deducted in Data Collection.

Qty Available with On Order : Uses the following formula - Qty Available with On Order = (Quantity On Hand) - (Quantity Allocated) + (Quantity On Order).

Qty Available w/o On Order : Uses the following formula - Qty Available w/o On Order = (Quantity On Hand) - (Quantity Allocated).

Unit Cost : The default Estimating Unit Cost that is associated with the Material. NOTE : The Unit Cost my differ on an Estimate or Order from the default value.

Reorder Level : Displays the quantity at which the Material Item will be included when a Reorder Report is generated.

Desired Level : Displays the inventory quantity the system wants to be at.

Reorder Quantity : Formula - If the Quantity On Hand is lower than the Reorder Level then Desired Level - Quantity On Hand.

Last Updated : The date when the default information was modified NOT when the last transaction was recorded.

Last PO Number : Record of the last Purchase Order made for the Material Item.

Last PO Date : Record of the last Purchase Order date made for the Material Item.

Monthly Pur. Avg. : Average purchases over the last 12 months.