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 Inventory Handling
DrillDown Icon IPS Upload
DrillDown Icon Lookup Manufacturer Part Number from XL List
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To ......
DrillDown Icon Create Excel File for Lookup
DrillDown Icon How to Lookup Mfgr 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
 
How to Lookup Mfgr Part Number from XL List

Enter Inventory Mgt/Inventory Control Management/Lookup Manufacturer Part Number from XL List Module

 

 

The following screen will appear:

 

 

Depress the "Browse for Excel File" to locate the file name created

 

 

Double Click on the File name and the following results appear.  Two XL files are created, one XL file lists the Mfgr Part Numbers found in system, (which is the ones that appear on screen)and the other XL file lists the Mfgr Part Numbers not found.

 

 

 

 

 

 

 

Article ID: 1916