ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon Installation of SQLManex(Server install)
DrillDown Icon Multi-Location Sync(OPTIONAL Module)
DrillDown Icon Add Custom Quickview (test)
DrillDown Icon Introduction to MX
DrillDown Icon Setup/Security/Utilities
DrillDown Icon Product Data Management
DrillDown Icon Bill of Material
DrillDown Icon BOM Reports
DrillDown Icon BOM Import
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields and Definitions
DrillDown Icon How To
DrillDown Icon Limitations to the Reference Designators
DrillDown Icon Limitations to the Different Import Template Types
DrillDown Icon BOM Import - FAQ
DrillDown Icon BOM Import Settings
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Report Manager
DrillDown Icon Tool Box
DrillDown Icon MX FAQ's
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Prerequisites
 
 
To import a BOM, one of the templates below must be used.  
 
 

It is okay if you have blank lines, but they should be subsequent lines of the same assembly, NOT the first line item no.  First priority is the assynum and rev columns in the spreadsheet,.   If you populate that data, in the first item number it will use that as the import record assembly number.  NOTE: If you are entering parts for different customers on the same spreadsheet you MUST enter different assynum and/or rev to distinguish between customer parts.  If assynum is same it will override customer number and use prior customer linked to that assembly number.


If the assynum and rev columns are blank in the first item no (as in item 1 in this bom) THEN the import will use the file name as the assembly number, then, if the rest of the line items have data that is the same, the system will put it on another import record with the listed number.  


 

Font size:  We made it larger so it is easier to read and use on things like a tablet. However, if your screen size is small it may appear too large.   

Article ID: 5490