Skip to content

Explanation on Component Availability Inquiry

Revised Date: 01/07/2021
Version: 7.5 & up

Q. In I/M -> Inquiry -> Stock Status Inquiry, you can press F2=Comp Avail.  Then the Component Availability Inquiry Screen will show up.  In this window, it displays three numbers under the "New Cost/EA" column that corresponds to "Prnt," "Comp" and "Short."  How are these numbers calculated?



A.  "New Cost" represents "Replacement Cost."  The corresponding rows are for:
  • Prnt (Parent) - This means parent item's replacement cost.
  • Comp (Component) - This means the total cost by roll-up of the component's replacement cost.
  • Shrt (Shortage) - This means to roll up the components in stock by using the default costing method (in the above case, the standard cost), then rolling up the components that are in shortage by using the replacement cost.
How Is Replacement Cost Calculated?
The replacement cost is calculated as follows:
  1. If in PO Setup, flag "20. Default FOB Std Cost on PO's?" is set to "Y," the system will use the item standard cost as replacement cost.
  2. If not, the system will look up this item to see if it has the corresponding item vendor record (based on primary vendor in the item master). If the record is found, the system will use the last purchase cost from the item vendor table.
  3. If not, the system will use the last cost of the item master record.
The result of steps 1 through 3 above can be further overridden by the item vendor table's price table if that price table is set up.  Therefore, in this window, you could override the quantity (default 1), which may result in a different replacement cost.

As you can see, the above procedure to determine the replacement cost is quite complicated. This often causes confusion because most of the time the user will assume the "Last Cost" is the replacement cost.

What's The Asterisk (*) To The Right of The  Component?
Sometime you may see an asterisk (*) symbol to the right of each component. See sample screen below:


The asterisk symbol is to remind you that the component cost and replacement cost are different. The component cost can be standard, average or last cost depend on your cost method. Replacement cost on the other hand is determined as described previously.

What's The Asterisk (*) To the Left of The Component?
Sometime you may see an asterisk (*) symbol to the left of each component. See sample screen below:


Most of the time, this position is display with blank. If it should display something, it could be one of the following values:
  • * = Component is not active (i.e. forecast or obsolete) 
  • @ = Component Needed > Qty Available
  • # = Component is not active and Qty Needed > Qty Available

EMK

Feedback and Knowledge Base