ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Utility
DrillDown Icon Sales Management
DrillDown Icon Inventory Management
DrillDown Icon Packing List Management
DrillDown Icon RMA Receiver
DrillDown Icon PO Receiving & DMR
DrillDown Icon Kitting, Allocating & Shortage Mgmt
DrillDown Icon Inventory Control Mgmt (ICM)
DrillDown Icon Inventory Control Mgmt (ICM)
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon Find an Inventory Control Record
DrillDown Icon Find an Inventory Control Record Using the X-Reference Find
DrillDown Icon Add an Inventory Control Record
DrillDown Icon Copy or Edit an Inventory Record
DrillDown Icon Delete an Inventory Control Record
DrillDown Icon Attach a Related Document
DrillDown Icon Reports
DrillDown Icon FAQs
DrillDown Icon ManEx Minutes (ICM)
DrillDown Icon Inventory Handling
DrillDown Icon IPS Upload
DrillDown Icon Lookup Manufacturer Part Number from XL List
DrillDown Icon Inventory Cycle Count
DrillDown Icon Physical Inventory
DrillDown Icon Standard Cost Adjustment
DrillDown Icon Part Manufacturer Setup
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Administration
DrillDown Icon eManEx
DrillDown Icon ManEx Minutes for All Modules
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Find an Inventory Control Record

Entering the Inventory Control Management Module.  Depress Inventory Mgt/Inventory Control Managment/Inventory Control Management. 

 

 

 

The main screen will appear.

 

Inventory Find Prerequistes

In order to Find items with certain characteristics or parameters using the Inventory Find Screen, the items must have been entered in the Item Master with those characteristics. Listed below are the pre-requisites for doing 3 different kinds of Inventory Finds:

  • Internal items must be in the system to be found.Searches for parts between a Starting number and Ending Part Number must include the prefix and any dashes or special characters.
  • A part cannot be found in an “In-Store part find” unless it has been set up with an In-Store warehouse and supplier in the Item Master Quantity Info. screen.
  • A Consigned record cannot be found for an item until the Customer has been entered and the item has been given a Customer Part No. in the Item Master Customer Reference screen.

When the user does an Inventory Find, in order to speed up the process the user may eliminate the quantity display.

Depress the Find button. The following screen will display:

 

Note that the default is for the Summary screen to NOT display the quantity.

 

If the user wants to have the quantity display on the Summary screen, highlight the desired part number and right click your mouse. The quantity will display for the one part number:

 

If the user wants the entire summary screen to display all of the quantities, then select the Display Summary Quantity radio.

Inventory Find Search Field Definitions

  • Internal Inventory – Products, Parts and Assemblies purchased, received, stocked, issued and shipped using standard in-house internal item numbers.These numbers are required and serve as the basis for creation of Consigned and In-Store parts. Just clicking on OK with the default selections shown in the preceding Find Screen will bring up all internal inventory parts in the Item Master Summary screen.
  • Consigned Inventory – these records are created every time a Customer Part Number is entered in the Item Master Customer Reference screen. These records are used to enter Customer requirements (Approved Vendor List) and preferences (choices within the Approved Vendor List) for Manufacturers for a given Part Number.It is also where Customer-owned item inventory levels and locations can be seen.
  • In-Store Inventory – any internal item can be setup with an In-Store Inventory for a Supplier under contract to supply that item. In-Store items are setup in the Internal Inventory Item Master Quantity Info screen and can be viewed individually in that screen or as a group by supplier in the Summary Screen as the result of an Inventory Find by In-Store Inventory.
  • Starting Part Number and an Ending Part Number
    • Enter all prefixes, dashes, spaces and alpha charactersto show the entire number.
    • Enter first and last Part Number of a series for those and all items numbered between.
    • Enter a desired single item in the 1st box and hit return to select only that record.
  • Assigned Buyer will bring up all items assigned to that particular Inventory Buyer.The Buyer assignment is made in Part Class and Type System Setup Defaults or in the Item Master.
  • Part Class and/or Part Type will bring up only those items that match all entries made.Both Part Class and Part Type must be specified to bring up any items.
  • Do not display Summary Quantity radio will by-pass the quantity calculation.
  • Display Summary Quantity radio will open up another selection "Total On Hand Quantities"
    • Total On Hand Quantities will bring up only items with matching inventory quantities.The user may choose from Total Quantity on Hand, Quantity on Hand > 0, or Quantity on Hand = 0.
  • Record Status allows selection of All, Active Only or Inactive Only item records.

Tips on Using the Inventory Find Screen

  • Selection of at least one parameter will reduce the time to retrieve the information.
  • In-Store Inventory searches require that a Supplier Contract be entered in order to select a Supplier.
  • Consigned Inventory searches show Customer-specific information (such as Approved Vendor List information) as well as Consigned Inventory On-Hand Quantities.
  • If no information is selected in a Find operation, try using broader or fewer selection criteria.

Combination Searches

Combinations of search parameters may be made for further filtering of the Inventory Item Master files to see item(s) of interest. For instance, selecting the items on the example screen will find all ACTIVE, In-Store Inventory for "Anixter" with the Class “CABLE”.In-Store Inventory Searches are Supplier specific whereas Consigned Inventory searches require entry of a Customer in order to initiate the search.

 

Inventory Find Example

The screen shown below is to illustrate Inventory Find results from selecting Internal Inventory, a Part Class of CAP-SMT, a type of 0805, Total On Hand Quantities of Qty on Hand = 0, and Record Status of Active Records Only

 

 



The first tab (Summary Tab) is used to display the results of an Inventory Find. The remaining Tabs will then display detail information for any item selected (highlighted) in the Summary screen. If no items have yet been entered in the system or copying an existing part is not needed, it is not necessary to populate the Summary screen by doing an Inventory Find. 

If user has the internal inventory screen open as well as the customers inventory screen open, the customer name will be displayed at the top of the page.  So when switching between the two screens user will easily be able to determine which screen they are in.

 

Article ID: 921