1. BOM Import - FAQ
1.1. What do the BOM import settings do?
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 80 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 110. 
  • Another part that had both AVLs but no other matches would also score 80.
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 empty is the Rev ( or non-rev) and will only match an existing part without a rev.

 




1.2. How do I Remove Duplicate AVL's?
If a user sees duplicate AVL's in the BOM import list of parts then it means somehow they were able to get a duplicate manufacturer in the database. We have a built in SP (dbo.InvtMpnCleanRefresh)  to clear that.
It is attached to this article as well.




1.3. Receiving primary Key violation error upon import. What does it mean?

Upon import you may be presented with something similar to the error in image below. Typically means on your import template for this BOM you have the same Manufacturer and MPN combination listed more than once when creating a brand new part. Typically won't see this when system matches to existing part #'s.