Explanation on Component Availability Inquiry

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


    • Related Articles

    • BMINQMNU Bill of Material Work Order Inquiry

      Work Order Inquiry Application Overview Work Order Inquiry is an interface that provides work order header information as well as current production progress. Current production progress, like Complete Quantity, Scrapped Quantity and Last Production ...

    • BM1601 Bill of Material Feature/Option Configuration Inquiry

      BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...

    • BM0200 Bill of Material Single Level Bill of Material Inquiry

      BM0200 Bill of Material Single Level Bill of Material Inquiry ← Bill of Material / Work Order Plus Single Level Bill Of Material Inquiry Application Overview The Single Level Bill Of Material Inquiry allows you to display a single level bill of ...

    • BM0300 Bill of Material Indented Bill of Material Inquiry

      Indented Bill of Material Inquiry Application Overview The Indented Bill Of Material Inquiry application is used to quickly and easily finds the Bill of Material for an entered parent item. It offers the option of blowing through phantom items ...

    • CPISSULS Customer Order Processing Issue Serial/Lot Component Items

      Issue Serial/Lot Component Items Application Overview After posting invoices to Accounts Receivable which includes a line item which is non-stocked and controlled and has a product structure which contains Serial/Lot components, a record for each one ...