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
 
BOM Import Settings
How does the score system work? 
These settings determine the score provided for each match. 
  • An import record that had 2 AVLs (one already loaded) and an existing customer part number would get a score of 25 and the new AVL would be set to be added on completion. 
  • Another part that matched by MANEX number and description (exact match) would score 70. 
  • Another part that had both AVLs but no other matches would also score 20.
The record with the highest score would be selected by default (or the one matched first if two records had the same highest score) and the system would alert the user to other possible matches.

 
What does match REV sort and overage calculation do? Rev sort (ascending/descending) indicates how to sort multiple records of the same part number. It will pick the first matching record. In other words, other things being equal, do you want it to select the latest revision (descending) or the first revision (ascending).

How does the Skip empty REV field work
In the BOM settings menu user has option to Skip empty Rev field. 

Skipping empty Rev fields means that an empty Rev isn't treated as a rev. It can match any rev.

If you don't check the option, then an Rev is empty( or non-rev) it will only match to an existing part without a rev.

 




Article ID: 5906