Inquire Material Count and Location Information

Stock Maintenance

InquireMaterial Count and Location Information

This section deals with the Stock Maintenance business component and its activity Inquire Material Count and Location Information.

Inquire Material Count and Location Information – A summary of the activity

With this activity, you can estimate the quantum of a part in stock, in need, under procurement and in-transit. In addition, you can also scan for the part across the organization, may that be on ground in a warehouse or a work center or off ground in an aircraft. You can also determine the quantities lying with repair agencies that are external to the organization. Further, you could fetch the number of mandatory position codes in aircraft that are currently not fitted with the component indicating the impending demand for the part. The number of position codes to which the part is presently attached is also available indicating the current location of various components. All this helps to know the quantities of parts that are due to be received by/returned to/issued by warehouses.

Such all-inclusive information supports material planners in streamlining, planning and executing demand-supply for parts. Thus, delays/bottlenecks for supply of parts are eliminated at the same time as wastages leading to increase in the bottom line of the organization. Precise estimation of the quantum of a part in different transient phases of its life cycle, such as demand, on-order, under-supply and in-use becomes very effortless.

The ‘Serviceable’ and ‘Unserviceable’ quantities of a part are segregated at the first level and then quantity breakup under logically grouped entities and sub-entities representing the following is available:

4 Available in warehouses

4 Requested for purchase

4 Ordered for purchase

4 Received through goods/repair/loan/rental receipts

4 Quarantined

4 Issued to work centers but not attached to aircraft/NHA

4 Returnable Unserviceable parts

4 Returnable against issues

4 In-transit against stock transfers

4 Issuable against exchange purchase orders

4 Attached to position codes in aircraft

In addition to the above, you can also know the number of Mandatory position codes in aircraft to which parts are not attached.

You may select a part under a specific ownership to know the above details.

Special feature: A Google map in the activity shows the geographical location of warehouses. Just a click of the location pin displays Serviceable and Unserviceable quantity breakup of parts currently in stock in the warehouse.

Getting familiar with the pages inside

Go to page…	For…
Inquire Material Count and Location Information	Inquiring count and location details of part
View Quantity Breakup Details	Viewing quantity breakup details for part

Inquiring count and location details of part

This page provides count summary of various physical locations where a part is found.

ØSelect the “Inquire Material Count and Location Information” under the “Stock Maintenance” business component.

The “Inquire Material Count and Location” Information “page appears.

ØEnter/select the following to retrieve the part for which you wish to view count and location details.

Part #	The code identifying the part for which you wish to view the count and location details (Alphanumeric, 40), Mandatory. Ensure that the part number is “Active” as defined in the “Part Administration” business component. The part # must be currently valid and Active as defined in Part Administration. Help facility available
Owned	Select the box to retrieve details of the part that is owned by the organization. By default, this box remains checked, if the process parameter “Default Ownership check-box for Material Count and Location inquiry” under the category “Material Count and Location” in the “Set Inventory Process Parameters” activity of Logistics Common Master is ‘1’or ‘4’.
Supplier	Select the box to retrieve details of the part that is owned by the supplier. By default, this box remains checked, if the process parameter “Default Ownership check-box for Material Count and Location inquiry” under the category “Material Count and Location” in the “Set Inventory Process Parameters” activity of Logistics Common Master is ‘2’ or ‘4’.
Customer	Select the box to retrieve details of the part that is owned by the customer. By default, this box remains checked, if the process parameter “Default Ownership check-box for Material Count and Location inquiry” under the category “Material Count and Location” in the “Set Inventory Process Parameters” activity of Logistics Common Master is ‘3’ or ‘4’.

Note: It is mandatory that you select one of these check boxes: Owned, Supplier or Customer.

Trading Partner #

The number identifying the customer or supplier who owns the part.

Note: 1) This field is mandatory, if you have selected Supplier or Customer check-box. 2) The supplier # or the customer # must be currently valid and Active as defined in Supplier or Customer component.

Help facility available

ØSelect the “Get Details” pushbutton to retrieve count details of the part and alternates that satisfies the ownership criteria.

Material Count Summary

Legend	What it represents
	Part Type
	Part Category
	Stock UOM
	Mfr.

See Legends

Field /quantity consolidation for both Serviceable/Unserviceable parts (popup)

Process parameter under category Material Count and Location in Set Inventory Process Parameters	Process parameter value	Impact in the Material Count Summary multiline
Display 'Spares Due' Sub-Entity under	4 0 for Due In – Others	The quantity issued to AME/SWO as Spare for which stock return not created till now is included in the entity Due In- Others.
Display 'Spares Due' Sub-Entity under	4 1 for Due In - On Orders	The quantity issued to AME/SWO as Spare for which stock return not created till now is included in the entity Due In- On Orders.
Display 'Pending Return' Sub-Entity under	4 0 for Due In – Others	The sum of quantity of the part removed in an AME/SWO or Core Returnable Parts that were issued to AME/SWO for which return is not created till now is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The sum of quantity of the part removed in an AME/SWO or Core Returnable Parts that were issued to AME/SWO for which return is not created till now is included in the entity Due In- On Orders.
Display 'Under Return' Sub-Entity under	4 0 for Due In – Others	The quantity of the part from yet-to-be-confirmed stock returns is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part from yet-to-be-confirmed stock returns is included in the entity Due In- On Orders.
Display 'In Transit' Sub-Entity under	4 0 for Due In – Others	The quantity of the part from yet-to-be-confirmed stock transfer receipts is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part from yet-to-be-confirmed stock transfer receipts is included in the entity Due In- On Orders.
Display 'In Shop Due' Sub-Entity under	4 0 for Due In – Others	The quantity of the Part issued to SWO as Main Core for which return is pending is included in the entity Due In-Others
	4 1 for Due In - On Orders	The quantity of the part issued to a SWO as Main Core for which return is pending is included in the entity Due In-On Orders
Display 'Under Receipt' Sub-Entity under	4 0 for Due In – Others	The quantity of the part from yet-to-be confirmed goods, repair, loan and rental receipts is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part from yet-to-be confirmed goods, repair, loan and rental receipts is included in the entity Due In- On Orders.
Display 'Quarantined Receipt' Sub-Entity under	4 0 for Due In – Others	The quantity of the part quarantined against goods, repair, loan and rental receipts is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part quarantined against goods, repair, and loan and rental receipts is included in the entity Due In- On Orders.
Display 'PO / Release Slip' Sub-Entity under	4 0 for Due In – Others	The quantity of the part for available in authorized PO/release slips for which Goods receipts are yet to be created is included in the entity Due In-Others
	4 1 for Due In - On Orders	The quantity of the part from authorized PO/release slips for which Goods receipt are yet to be created is included in the entity Due In-On Orders
Display 'Third Party Repair' Sub-Entity under	4 0 for Due In – Others	The quantity of the part from repair orders against which repair receipts are yet to be recorded is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part from repair orders against which repair receipts are yet to be recorded is included in the entity Due In- On Orders.
Display 'Loan In' Sub-Entity under	4 0 for Due In – Others	The quantity of the part from loan orders for which loan receipts is yet to be recorded is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part from loan orders for which loan receipt are yet to be recorded is included in the entity Due In- On Orders.
Display 'Loan Out' Sub-Entity under	4 0 for Due In – Others	The quantity of the part sent out by rental orders against which rental receipt is yet to be recorded is included in the entity Due In- Others.
	4 1 for Due In - On Orders	The quantity of the part sent out by rental orders against which rental receipt is yet to be recorded is included in the entity Due In- On Orders

The multiline displays the counts details of the retrieved part and its alternates under specific heads/entities.

Main/Alternate Part #	The user-specified part of which the count and location details are displayed in the page. This field also displays all the Alternate parts for the user-specified (Main) part. Click on the data hyperlink to open the View Part Information page.
Total Qty	The sum of the ‘Serviceable’ and ‘Unserviceable’ WH and Due In-Others Qty
WH	The ‘Serviceable’ quantity of the part in the warehouse.
Due In- Others	The sum of Serviceable quantities of the part: § From yet-to-be confirmed goods/repair receipts § From yet-to-be confirmed loan/rental receipts § From yet-to-be-confirmed stock transfer receipts § From yet-to-be-confirmed maintenance stock returns § Quarantined against goods/repair receipts § Quarantined against loan/rental receipts § Issued to AME/SWO as Spare for which return not created till now § Issued to AME/SWO as Main Core for which return not created till now § Note: This can vary based upon the definition of the options in the Set Inventory Process Parameters activity under the category ‘Material Count and Location’
Due In- On Orders	The sum of Serviceable quantities of the part: § From purchase orders/release slips for which receipts are due. § From repair/loan/rental orders for which receipts are due. § Note: The is can vary based upon the definition of the options in the Set Inventory Process Parameters activity under the category ‘Material Count and Location’
Due Out	The sum of Serviceable quantities of the part § From material requests for which issues are due. § From loan orders for which issues are due.
PR	The sum of ‘Serviceable’ quantities of the part from purchase requests for which purchase orders/release slips have not been created/generated yet.
WH	The ‘Unserviceable’ quantity of the part in the warehouse.
Due In- Others	The sum of Unserviceable quantities of the part: § From yet-to-be confirmed goods/repair receipts § From yet-to-be confirmed loan/rental receipts § From yet-to-be-confirmed stock transfer receipts § From yet-to-be-confirmed stock returns § Quarantined against goods/repair receipts § Quarantined against loan/rental receipts § Issued to AME/SWO as Spare for which stock return is not created till now. § Issued to AME/SWO as Main Core for which return is not created till now. § Note: The above consolidation of quantities an vary based on the definition of the options in the Set Inventory Process Parameters activity under the category ‘Material Count and Location’
Due In- On Orders	The sum of Unserviceable quantities of the part: § From purchase orders/release slips for which receipts are due. § From repair/loan/rental orders for which receipts are due. § Note: The above consolidation of quantities can vary based upon the definition of the options in the Set Inventory Process Parameters activity under the category ‘Material Count and Location’
Due Out	The sum of Unserviceable quantities of the part § From material requests for which issues are due. § From loan orders for which issues are due. § From Exchange Purchase Orders for which Issues are due

PR	The Unserviceable quantities of the part available in purchase requests that are not covered by any purchase order/release slip.
On-Wing	The number of position codes in aircraft to which the part is currently attached.
Off-Wing	The number of mandatory position codes in which the part is not attached in aircraft.
Issue-Not Attached Qty	The quantity of the part issued to AME / SWO, which are not attached to aircraft / NHA till now, if the part is a ‘Component’.
Stock Value	The stock value of the Internal-owned quantity of the part available in the warehouse, if you have checked the Owned check box. Or The stock value of supplier-owned valuated quantity of the part, if you have checked the Supplier check box. Note: if you have selected Customer check box, no value is displayed here.
Part Description	The description of the part.
Mfr. Part #	The manufacturer number of the part.
Mfr. #	The manufacturer of the part.
Prime?	Indicates whether the part is a prime part.

ØClick the data hyperlink in the multiline to open the “View Quantity Breakup Details” page. The “View Quantity Breakup Details” page displays data for the part # & entity combination.

Material Count Breakup

ØUse the Part # drop-down list box to select the part for which you wish to view count details under different sub-entities. You may select ‘All’ from the drop-down list box to view the count details of the main part and its alternates under different sub-entities.

On selection of the part # or entity, the multiline displays the following count details.

Entity	The classification of Serviceable/Unserviceable parts due to be received by/returned to/issued by the warehouse. Due In – Others Due In – On Orders Due-Out
Sub-Entity	The sub-classification of Serviceable/Unserviceable parts that is due to be received by/returned to/issued by the warehouse. Entities & sub-entities matrix
Serviceable	The quantity of Serviceable units of the part under the entity-sub-entity combination.
Unserviceable	The quantity of Unserviceable units of the part under the entity-sub-entity combination.

ØSelect the “View Part Supply Chain Performance” link for details on supply, demand and consumption of parts.

ØSelect the “Inquire Stock Availability” link for details of stock-in-hand in various warehouses of the organization.

Serviceable
Entity	Sub-Entity	What it means………
Due In – Others	Under Receipt	The quantity of the Serviceable part from yet-to-confirmed Goods/Repair/Loan/ Rental receipts
	Pending Return	The quantity of the Serviceable Core part issued to AME/SWO that yet to be returned.
	Spares Due	The quantity of the Serviceable Spare part issued to AME/SWO that is yet to be returned.
	In Transit	The quantity of the Serviceable part from yet-to-be confirmed stock transfer receipts.
	Under Return	The quantity of the Serviceable part from yet-to-be confirmed stock returns.
	Quarantined Receipt	The quantity of the Serviceable part quarantined from Goods/Repair/Loan/ Rental receipts.
Due In - On Orders	PO / Release Slip	The quantity of the Serviceable part from purchase orders/release slips, which is yet to be received.
	Loan In	The quantity of the Serviceable part from loan orders, which is yet to be received.
	Loan Out	The quantity of the Serviceable part from rental orders, which is yet to be received.
	Third Party Repair	The quantity of the part from repair orders yet to be received.
Due Out	Material Request	The quantity of the Serviceable part from material requests, for which issues are due.
Due Out	Loaned - Pending Return	The quantity of part received against loan orders, which is yet to be returned.
Unserviceable part
Entity	Sub-Entity
Due In – Others	In Shop Due	The quantity of the Unserviceable Core part issued to AME/SWO that yet to be returned.
	Pending Return	The quantity of the Unserviceable part from yet-to-confirmed Goods/Repair/Loan/ Rental receipts
	Under Return	The quantity of the Unserviceable part from yet-to-be confirmed stock returns.
	In Transit	The quantity of the Unserviceable part from yet-to-be confirmed stock transfer receipts.
	Under Receipt	The quantity of the Unserviceable part from yet-to-confirmed Goods/Repair/Loan/ Rental receipts
	Quarantined Receipt	The quantity of the Unserviceable part quarantined from Goods/Repair/Loan/ Rental receipts.
Due In - On Orders	PO / Release Slip	The quantity of the Unserviceable part from purchase orders/release slips yet to be received.
Due In - On Orders	Third Party Repair	The quantity of the part from repair orders yet to be received.
Due Out	Material Request	The quantity of the Serviceable part from material requests, for which issues are due.
Due Out	Pending Core - Exch. PO	The quantity of the Unserviceable Core part yet to be issued against Exchange/PBH Exchange purchase orders.

Popup: Grouping sub-entities under entity

Set of process parameters influence the grouping of sub-entities under entities and, thus dictate the consolidation/breakup of part quantities in the “Inquire Material Count and Location Information” activity of Stock Maintenance. Note that this reasoning remains the same way for both Serviceable and Unserviceable parts.

The sub entities that you can include either in Due In – Others or Due In – Orders entities are:

4Spares Due

4Pending Return

4Under Return

4In Transit

4In Shop Due

4Under Receipt

4Quarantined Receipt

4PO/Release Slip

4Third Party Repair

4Loan In

4Loan Out

You can choose to tag sub-entities to either Due In - Others or Due In – On Orders entity by defining process parameters under the category “Material Count and Location” in the Set Inventory Process Parameters in Logistics Common Master as the next table illustrates for you.

Process parameter	Parameter value
Display 'Spares Due' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Pending Return' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Under Return' Sub-Entity under	Enter ‘0’ for ‘Due In - Other Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'In Transit' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'In Shop Due' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Under Receipt' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Quarantined Receipt' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'PO / Release Slip' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Third Party Repair' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Loan In' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’, ‘1’ for ‘Due In - On Orders'
Display 'Loan Out' Sub-Entity under	Enter ‘0’ for ‘Due In - Others’

Viewing quantity breakup details of parts

Page overview

ØSelect the data hyperlink in the multiline under “Material Count Summary” section. OR

ØSelect the data hyperlink in the multiline under the “Due In/Due Out Summary” section.

The “View Quantity Breakup Details” page appears with data for the part # & entity combination. However, you may specify criteria to retrieve breakup details of the requisite part # and entity combination.

ØEnter the following in the “Entity & Part Information” group box.

Entity

Use the drop-down list box to select the entity for which you want the breakup details for the part. The drop-down list box displays the following: Ser: Warehouse

§ Ser-Due In Others

§ Ser-Due In On Orders

§ Ser-Due Out

§ Ser- PR

§ U/s-Warehouse

§ U/s-Due In Others

§ U/s-Due In On Orders

§ U/s-Due Out

§ U/s-PR

§ On Wing

§ Off Wing

§ Issued - Not Attached

§ Spares Due

§ In Shop Due

§ Ser-Pending Return

§ U/s-Pending Return

§ Ser-Under Return

§ U/s-Under Return

§ Ser-In Transit

§ U/s-In Transit

§ Ser-Under Receipt

§ U/s-Under Receipt

§ Ser-Quarantined Receipt

§ U/s-Quarantined Receipt

§ Ser-PO / Release Slip

§ U/s-PO / Release Slip

§ Ser-Third Party Repair

§ U/s-Third Party Repair

§ Loan In

§ Loan Out

§ Ser-Material Request

§ U/s-Material Request

§ Pending Core – Exch. PO

§ Loaned Pending Return

Part #

Use the drop-down list box to select the part # for which you wish to view quantity breakup details. The drop-down list displays the part # selected in the previous page (Inquire Material Count and Location Information), its alternate parts and ‘All’.

Select ‘All’ to view breakup details of the Main part and all its alternates from the drop-down list box.

The “Entity & Part Information” group box displays the following:

Part Description	The description of the part.
Qty	The current quantity of stock of the part.

The “Quantity Breakup Details” multiline displays the following:

Part #	The part for which breakup details are provided in the page. The complete details of the part follow;
Part Description	The description of the part.
Sub-Entity	The sub-classification for breakup of quantities of the part.
Document Type	The type of the reference document
Document #	The document associated with the entity. The possible documents displayed here could be Goods Inward, Issue, Material Request, Purchase Order, Release Slip, Purchase Request, Loan Order, Rental Order and Stock Return. Click the data hyperlink to view details of the document associated with the entity.
Document Status	The status of the document associated with the entity.
Document Date	The date of creation of the document associated with the entity.
Document Priority	The execution priority of the document, such as AOG, General.
Document Sub-Type	The sub-type of the document.
Supplier	The ID of the supplier that owns the parts or is involved in the transaction specific to the entity.
Supplier Name	The name of the supplier that owns the parts or is involved in the transaction specific to the entity.
Customer	The ID of the customer that owns the parts or is involved in the transaction specific to the entity.
Customer Name	The name of the customer that owns the parts or is involved in the transaction specific to the entity.
Mfr. Serial #	The manufacturer serial number of the part as stated in the document
Serial #	The serial number of the part as stated in the document.
Mfr. Lot #	The manufacturer lot number of the part as stated in the document
Lot #	The lot number of the part as stated in the document
Component #	The component # for the part # - serial # combination.
Quantity	The quantity of the part in the warehouse or the qty of the part # - serial # / lot # involved in the transaction.
Condition	The condition of the part # - serial #/lot # in the document, such as New, Overhauled, Serviceable, Unserviceable or Phased-Out.
Value	The value of part.
Currency	The transaction currency for the document.
Warehouse #	The warehouse for the part.
Zone #	The zone in the warehouse in which the part is stored.
Bin #	The bin in the zone in the warehouse in which the part is stored.
Stock Status	The stock status of the part # - serial #/lot #.
Trading Partner Type	The ownership of the part # - serial #/lot #.
Trading Partner #	The owner/trading partner for the part such as customer # or supplier #.
Trading Partner Name	The name of the customer or supplier of the part.
Need Date	The date by which the part is required or must be replenished.
Work Center #	The work center to which the part was issued against the AME Ref. #/SWO or the work center # stated in the document.
A/C Reg #	The aircraft to which the part is currently attached or the aircraft stated in the document.
MR Class	The class of the material request, such as Maintenance or General.
From Warehouse	The warehouse that issues/returns quantities of the part.
To Warehouse	The warehouse that receives the part.
Ref. Document Type	The type of reference document that initiated the procurement/replenishment/stock movement of the part.
Ref. Document #	The code of the reference document corresponding to the Document # displayed. This is entity specific. The possible reference documents would be Shop Work Order, A/C Maint. Exe. Ref. #, Purchase Order, Repair Order, Customer Order, Stock Transfer, Material Request, Issue, Unplanned Issue or Rental Order. Select the link to view details of the reference document.
Ref. Document Status	The status of the reference document such as Draft, Fresh, Confirmed or Authorized.
Ref. Document Date	The date of creation of the reference document.
Pending Return Qty	The quantity of the part returnable to the warehouse against the reference document.
Pending Return Value	The value of the part returnable to the warehouse against the reference document.
Due Days for Return	The number of days after which the part must be returned to the warehouse.
A/C Model #	The model of the aircraft.
ATA	The ATA chapter # associated with the part.
Chapter Description	The description of the ATA Chapter.
Level #	The level in the aircraft from which the component was removed.
Position Code	The position code in the level # from which the component was removed.
Purchase UOM	The unit of measurement in which the part is procured.
Return Basis	The basis for return of the part to the warehouse, such as Core, Excess or Returnable.
Station	The station associated with the document.
Component Replacement #	The identification # for the component replacement transaction.
Maintenance Object #	The component # from the reference Document.
Removed By	The code of the employee who performed the component removal task.
Removed Date	The date of removal of the component from the aircraft/NHA.
Removed From	The aircraft or NHA from which the component was removed.

To view more details on the part:

ØSelect the box for the part in the multiline and then select the relevant link to view the requisite information.

ØSelect the “View Component Replacement Details” link to know the component replacement history of the part.

ØSelect the “View Component Maintenance Log” link to know the component maintenance history of the part.