Home

User Manual Status: Q2, 2015 Current Version 6.10

1. ds Priority e mail e Alias UNDESIRED id ACE PREFERRED ASE Advonics Group NORMAL x FourStarBlectronics Fronty overrides for customers In the right hand side of the screen you see a section M a a titled Customer gt Distributor Distributor gt Customer This lets you define customer specific priority overrides An override is simply a case where the priority for a specific customer is different from your priority ABC Components might be one of your preferred suppliers However CustomerA let us say Cyberbrains has had bad experiences with them so they have specifically prohibited them So we will define a customer override for this distributor by selecting ABC Components then selecting Cyberbrains from the customer list and changing the setting to UNDESIRED Priority overrides for customers Distributor Priority A Alias Customer gt Diebita or Distributor m ua 4 Star Electronics UNDESIRED E i o ABC Components PREFERRED Customer Cyberbrains Inc v ACE PREFERRED Distributor Customer Priority Advonics Group NORMAL g 4 Star Blectronics NO_OVERRIDE AED Eectronics UNDESIRED ABC Components Allied Electronics NORMAL ACE NO_OVERRIDE gt Distributor gt Custome
2. REF PAI DO NOTIMPORT CPN y DO NOTIMPORT DONOTIMPORT MPN Manufacturer 7 DO NOTIMPORT CPN y DO NOTIMPORT RefDes y CPN Main Desoription gt Pos PN Index REF DESC TEE E E D REDES BOM correctly Currently no Story was E O 1 Dokuments found by the import tool E i 11 X933 123 J 05 Schematic m2 12 X8484 455 V 05 Assembly Plan m2 20 5 E E 2 30 Assembly m3 40 X000 4550 05 PCB 33333 234 4042 v E 4 110 Q999 123 06 coo CAPACITOR 100u 0050 m4 110 999 123 PANASONIC EEUFC1J1011 ae m4 110 PANASONIC EEUFC1J101 r T r r 1 t m cx CF amp m 4 110 CHEMI CON EGXES00E_ SOE it 999 1 MISHAY 0000000 r O 4 Mino 1999 12 MAL2048 8101E3 St ckliste K1 v TO a VISHAY H i 110 3999 12 MISHAN 148RUS 2222 144 urs m4 110 Q999 1 MISHAY MAL2148 8101 3 coe A i lt 120 Q888 456 01 c002 CAPACITOR SMD 1210 mo a Ref CPN mm Ok Des Gaid m5 120 KEMET C1210C105K5RAC m5 120 2888 45 SAMSUNG CL328105KBH MPN m5 120 156 WISHAY VJ1210Y105KxAA Notice that the color viewer has properly identified Manufacturer name and MPN for the lines where Refdes is blank Also note that the Story is empty This indicates that all issues are properly resolved and you can import that BOM You can now click OK to import the BOM into BOM Connector BOM Data cis ERP MSS PCB PricingDa
3. CIS amp Price Save is used to store your matchups i e between customer part number and j your internal ERP part number as well as your user attributes and prices into the BOM Connector database Refetch ERP Data will run the ERP link in order to update the BOM Connector database with your current ERP data Note in a network based client server environment this needs to occur from the server installed BOM Connector Settings lets you set various BOM Connector options see Chapter XX Production Quantity shows you the pricing information for the currently defined Production Quantities See Chapter 7 M1 a ElS Search Gi Chart Here you select which search mode you want to use for finding the matching part See Chapter 6 BC_PREP Gh Auto Link When parts have been found all 1 1 matches can be assigned automatically See Chapter 6 Indicates that compressed mode is on Hit once to turn compressed mode off the frame will disappear Compressed mode means that all reference designators for a given partnumber are listed together Non compressed mode means each reference designator is listed on a separate line Example Compressed mode on BOM BC Test bcx CPH E RC RetList Description ER Device Type EX Subclass 0 20 500 1 0013 1 148 HC11 5014H IC 74 HC11 0 20 500 1015 2 113 U11 L33940 IC LM3394D o 20 500 1100 1 U61 EEPROM AT24C024N 105C 2 7 IC AT24C02 0 20 500 1112 2 U50 LITE PCASSE PM IC POAISS Pr
4. Router Solutions BOM Connector User Manual 3 BC Link A direct ERP data source link is the backbone of BOM Connector and gives direct access to all necessary ERP data BOM Connector BC LINK includes a connection wizard that allows it to connect dynamically to nearly every ERP System including all SAP versions ERP data is brought smoothly into the BOM Connector backend database so searching and other tasks can be performed without effecting ERP System performance BOM Connector has been tested with many ERP systems including SAP Navision ProAlpha Infour Baan Wise and others However any ERP system that either uses SQL ORACLE Access or an ODBC OLEDB compatible database structure will work The connection to the ERP system is provided by Router Solutions as a standard part of the software delivery It is known as an ETL which stands for extract transform load As the name implies data is extracted from the ERP database transformed to make it better readable and loaded into a BOM Connector backend database Having this backend database means that searches are done offline from the ERP system and thus will not affect system performance It also gives you one central BOM Connector database to store the mapping between customer part numbers CPN and internal part numbers IPN as well as customer specific settings The ETL is adapted specifically for each customer s ERP system and provides the
5. MPN You find this under the icon Click here to bring up the rule editor MPN cleanup MPN Manufacturer Split Y Skip MPNs containing only letters Seperator between MPN and Manufacturer Y Remove special characters brackets dots Seperator between two groups Y Space always splits multiple MPNs Sequence casement Value C Manufacturer MPN O Skip entrys without Seperator between MPN and Manufacturer Preview MPN ManulMPN Manu ok Here are the options and their meaning Skip MPNs containing only letters Since most MPNs contain at least one number this helps the system recognize comments within an MPN field For example the text Alternate often appears in a BOM and usually in the MPN field By activating this option you will ensure that BOM Connector does eliminates this text and does not mistakenly assign it as an MPN Remove special characters Generally speaking proper MPNs do not include hyphens periods parenthesis etc Often however these are in the BOM By activating this feature BOM Connector will remove these and for example ERJ3GE YJ434V will be ERJSGEYJ434V Space always splits multiple MPNs In this example used earlier each MPN was separated by a space Activating this will let the import parser see these as separate MPNs Remove these words Oftentimes the MPN field in the BOM has comments that should be eliminated For example if a field has U
6. Progress Export database file with test data to desktop Cancel Hit OK and this will bring up the BOM Now import the new BOM as described in the Chapter 5 BC IN OUT From the ERP MSS Tab choose COMPARE BOM ERPAMSS PCB Pricing Da tto CC Save L5Y fle Compare BUM Col 66 Router Solutions BOM Connector User Manual Changes to partnumbers IPNs or reference designators are shown with a red X mark 5 40 554 0500000 1 0001 1 X 5 93 010 138 0000 4 0001 1 C1 X 5 93 010 138 0000 4 0002 1 C2 93 010 161 0000 0001 1 C14 93 010 161 0000 0002 1 C3 93 018 803 0000 8 0001 1 C15 93 016 424 0000 3 0001 1 Cl 93 016 402 0000 11 0002 1 C41 93 016 402 0000 11 0003 1 C308 93 016 402 0000 11 0001 1 C32 93 010 169 0000 12 0001 1 C33 5 93 010 1 78 0000 15 0001 1 c39 5 93 010 17870000 15 0002 1 c40 5 93 010 1 78 0000 15 0003 1 C401 93 010 1 78 0000 15 0004 1 C403 5 93 010 1 78 0000 15 0005 1 x C405 93 010 143 0000 16 0002 1 C51 8 4 Compare a New BOM with the Master BOM in MSS This is very similar to the step described above except that it does not require the BC EXCHANGE module It does however require you to install the MSS Process Preparation vPlan plugin delivered with the BOM Connector If this has been successfully installed into your ADD IN repository you can choose MSS IMPORT from the ERP MSS Tab ERPAMS5 PLE Pricing AML otto CEZ Save CSW file Compare BOM Collapse MSS5 mport
7. 15 Router Solutions BOM Connector User Manual Compressed mode off BOM BC T est box a CPN E RE RefDes Description EA Device Type EX Subclass 1 0 20 500 1003 1 048 HC11 5014H IC r4 HC 2 0 20 500 1015 2 UY LM 3394D IC LM 33940 3 0 20 500 1075 2 111 Lm33940 IC LM 33940 4 0 20 500 1100 1 1161 EEPROM AT 24C024N 105C 2 7 IC AT24C02 F 0 20 500 1112 2 U50 POASS5 PY IC PCASSE PY E 0 20 500 1112 2 UE POASSS PY IC PCASSE 7 PY Run BC CHECK see Chapter 8 Run a BOM Connector script GUI LAYOUT lets you turn on off certain windows particularly used for the DCl Octopart Hill window for those not using BC QUOTE 16 Router Solutions BOM Connector User Manual 5 BC IN OUT Reading in a BOM and Exporting is properly are the two most basic functions for which BOM Connector is used Particularly EMS users are confronted daily with a wide variety of BOM shapes and sizes Getting these into a standardized format and ensuring this contents are complete and correct is a key feature of BOM Connector and a big time saver To this end BOM Connector offers one of the industry s most powerful import tools It is the result of countless hours and testing with hundreds of different BOM formats The BC IN routine has been designed for maximum flexibility and intelligence Existing users of BOM Connector will notice that this reader has been significantly improved from Version 6 8 on The main new features are Story con
8. Clicking on this will bring up the MSS Dialog Here you see a list of all your J ASSEMBLIES Simply IPN CPN Revision Description Design Center Group DseGes Choose the one you want to do aa il import If you click on LOAD Mentor 31 03 2010 CAD at the lower left you will nean also import the CAD file see soa Chapter 9 BC CAD 31 03 201C 31 03 20 Once the BOM is loaded you ennai can compare it with the BOM 31 03 201C 31 03 2010 loaded in the BOM Tab by pices choosing COMARE BOM 31 03 2010 v The result is shown the same as described in 8 3 above load CAD Last refreshed at 22 08 2014 12 49 12 refresh vPlan settings Cancel Jas aa PALA an DARAN a 1 Poa are ass Ad An 67 Router Solutions BOM Connector User Manual 9 BC CAD Use BC CAD to directly load CAD Data and insert the information into your BOM CAD data must be either in a CCZ Format or for users of MSS Process Preparation vPlan you can extract the data directly from the database There is a sample CCZ file available called VPLANASSEMBLY CCZ It is located in TESTFILES You Ea CAD Link can load it either via the PCB tab Load File or via the icon If you use the CAD Link icon you will get a list of attributes En _comp_moumnt_bype _ind_onent_req TOL ADD _ PART ADD PART DESC ADD_PART_OTY ALT_SYMBOLS C COMPHEIGHT CustomerP arth umber DESCRIPTION Description Legacy Description Description De
9. NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE Avnet Express Asia Avnet Express Europe ASAP Semiconductor Avnet Express Avnet Express Asia Avnet Express Europe NORMAL NORMAL Bison Technologies NORMAL Braun UNDESIRED Braun Electronic Components NORMAL Braun Electronic Componen NORMAL NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE B D Enterprises B D Enterprises Bison Technologies Bristol Electronics Brooks 4 Maldini C Plus Electronics Chip 1 Exchange Chip One Stop Chip Outpost Classic Components Commonwealth Components Set Distributor Priority Preferred PREFERRED PREFERRED UNDESIRED Normal or Undesired New DCODE Click to add new Distributor Braun Braun Electronic Components Braun Electronic Components LLC Bristol Electronics Brooks 4 Maldini C Plus Blectronics Chip 1 Exchange Chip One Stop Chip Outpost NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 Save Settings Manufacturers the Distributor is authorized to offer Note if this is blank then the Distributor is authorized to offer all manufacturers The first time you run this your list of distributors will of course be empty When you run the Octopart Search once
10. BOM import v Show file selection dialog Or you can select a directory in the second half of the suggestion list to browse for a BOM in that directory Browse to the BOM file CSV or XLS file that you want to read in A demo file is included with the system It is the original BOM which was used to create the BC DEMO project which we worked with in the last Chapter Choose the file called BC DEMO CSV Load this file You will now see a screen with a list of customers such as displayed below note your actual list will be different 7 E Import BOM MSS_TEST2 csv Seasch Filtes w D Kunde Adresse 4004 Cyberbrains Inc 4001 Krantech AG 4003 Lowtech IG 4002 Megatronics Add new customer lt lt lt Go Back Next gt gt gt Cancel The list of customers is part of the BOM Connector concept of Customer Info Set which we will refer to as CIS throughout this manual If your ERP system has CIS information built into it and if this information was properly brought in by the BC LINK module you will see a list of your customers This is done automatically through the BC LINK ETL see chapter 3 3 Configuring the ETL page 10 If the ERP does not include contain customer information or if this was not implemented in the ETL you can use BOM Connector to administer customers Simply choose ADD NEW CUSTOMER and create as many as you wish The demo system includes a small CIS wh
11. So turn it off here At the top of the screen you will see a row of icons LLI Fak 4 EQ CIS search ha Q Start ry Awto Link ri hi gt Ob EXA With BOM Import you can read in any CSV TXT or XLS file This is usually the first step with BOM Connector reading in a BOM file provided by a customer in the case of an EMS company or an internal BOM Pa Open Project lets you open a previously saved BOM Connector session Save Project lets you save a currently open BOM as a BC Connector Project BCX Export BOM let you export your result i e Golden Manufacturing BOM into different formats such as XLS CSV or ERP The exported BOM can be cumulative or flat From the drop down you have two options EMITE UE E da Export BOM to MSS Eh Export BOM Standard export allows you to create choose a template and export to CSV XLS etc Export to MSS Direct export via AssemblyHost Add in to Valor MSS Proess Preparation vPlan 14 Router Solutions BOM Connector User Manual Run BOM Compare this function lets you read in two BOMs and compare them EN CAD LINK runs BC CAD see Chapter 9 which lets you open a CCZ file for CAD viewing and cross link between BOM and CAD When you load a CCZ file the attributes contained in the file will be displayed and you can choose which ones you want added into columns in your BOM This lets you compare the contents of the BOM with information in the design
12. this list will be filled You can add distributors using the ADD DCODE button In order to maintain database integrity with past price quotations it is currently not possible to delete Distributors so take caution when adding them Once it is filled you can start classifying your distributors into three categories PREFERRED for distributors you wish you handle first NORMAL for those with no preference and UNDESIRED for the ones you want to keep our of any best price calculations Note to delete a distributor simply set it to UNDESIRED The ALIAS function is designed used to handle different ways of writing a distributor name For example 4Star Electronics could be written as 4Star or 4SE etc Adding each of these would needlessly fill 99 Router Solutions BOM Connector User Manual the list and run the risk that quotes written in the different formats won t all be considered as coming from the same company To enter an alias simply click on the distributor name and enter the various alias forms Distributor a Priority e mail h d 4 Star Hectronics UNDESIRED T ACE PREFERRED y Advonics Group NORMAL gf If for example FourStarElectronics was already in the list as a distributor though it is only an alias you can select it then right click and select IS AN ALIAS FROM ANOTHER DCODE then choose 4Star and hit OK 4 Star Hectronics
13. 4 RS Compone Murata GRM32RR61E475K 1210 4 7 uF 25V xX5A 10 730 tral Avnet Express Murata GRM32RR61E475K 1210 4 7 uF 25V X5R 10 0 USD 1000 5000 10000 Avnet Expres Murata GAM32RR61E475K 1210 4 7 uF 25V X5R 10 3000 Components Murata GAM32AR61E475K 1210 4 7 uF 25V X5R 10 4 Digi Key Murata GAM32RAR61E475K 1210 4 7 uF 25V X5R 10 1361 USD 1 10 500 Digi Key Murata GAM32AR61E475K 1210 4 7 uF 25V xX5A 10 0 USD 2000 Digi Key Murata GAM32RR61E475K 1210 4 7 uF 25V xX5A 10 1361 USD 1 10 500 Fiirn Terh Murata GRAMA RRAIFAZAK 171047 oF PA KAR 10 1500 56 Router Solutions BOM Connector User Manual First off note that the distributors have been grouped into PREFERRED NORMAL and UNDESIRED For more information on this see the next section Distributor Handling Here the Octopart Search found a match for the Murata parts The price information is displayed However no Scale Price has been highlighted because no Price Group has been selected Now if we select for example Price Group 50 Then suddenly we see QTY 2 highlighted a Q 50 EUR S 50 EUR fm IPN CPN RC E Quantitiy EE Description ES 20 520 1075 1 1 0 C 22UF 16 X5R 20 1210 22U 20 20 Capaci BOM 4AML 20 525 1026 1 1 0 R 40K2 1 0603 40 2K 1 1 Resiste A clara MURATA 23 7562 23 7562 J 12299 20 520 1074 1 1 0 C 4 7UF 25 5R 10 1210 4 7U 10 10 capas INT I pa 02375 20575 1041 1 1 0 LV32 T
14. 41 o 20 575 1035 1 U55 0 20 575 1031 1 UG4 14 20 575 1027 4 03 04 05 06 0 20 520 1007 3 R268 R269 R271 o 20 520 1066 44 R102 R103 R105 A216 R217 R 0 0 02 20 5201062 3 R273 R24 R36 05 20 57 Remove material link o 20520 Copy cell value 296 R 0 20 520 Copy row data 7 20 520 Created material link manually Apply search filter ERP Update 30 12 2013 12 59 Searchmode CIS sear Show CPN in CIS ct E Show in layout ba IPN PRICE Create RefDes No Component User attributes gt Order Delete row Do not use Check with customer on MPN Google search Remove attribute Octopart search My search providers Edit attributes Adding User Savable Notes Entries How to Use This works just like the price information When you read a BOM into BOM Connector you will see a 6 Not l new field automatically added This can either be entered in by hand or you can choose a field to be the NOTE field when you read in a BOM When you do a CIS save simply check the box Save User Notes and this information will be added to the CIS To use these later simply load a new BOM perform the CIS Search as you normally do and go to the CIS tab From here you can either load a price for a single CPN into the BOM or load all To load the note for a single CPN choose it in the list then right click and select Copy Note to BOM Delete Customer Material Copy KIS data Preferred Copy
15. 520 1007 3 4 0 RIK27 10 MPN 1 0 0008 0 0008 Ba 04666 20 520 1008 1 10 R1K7810 Manufacturer 1 0 01 0 01 pa 11070 20520 1018 1 1 0 R8K4510 IPN 1 0 09 0 09 pa 08437 20 50 1100 1 1 0 EEPROMe gt Comment 1 n ANIR name eN NITE RVR 1NA 1 10 141709 Teer You can even edit this information right here by choosing the Scale Price in the right hand window right clicking on it and choosing EDIT Edit manual price BOM details Record MPN RefDes Scale Prices 1 Price Prices Source ERP1 Edit informations l DON 16 SKU Price 1 6 Distributor Created by kdecker o Distributor Since this is a single ERP Price you can SKU Createt at 27 05 2014 05 12 5 MPN only have a single price for minimum quantity of one Manufacturer Edited by enue IPN MPN Edited at gt Comment IPN Decay date 01 09 2014 Order informations Lead time days L 4004 Stock 20 575 1039 Packaging type 03997 Packaging size Currency This brings up the Manual Price Edit Dialog where you can change edit delete or add information This information is then saved into the BOM Connector Pricing Database NOTE BOM Connector calculates the prices based on EITHER the Qauntity Field in the BOM or the Reference Count RC If you do not see prices appear even though you have them available you probably are missing one of these To set which should be used by BOM Connector right click on the field you want to use either RC or QTY and select USE AS C
16. 520 1074 1 0 C 4 7UF 25X5R 101210 4 7U 10 10 Capacitor 4 7uF id GRM32AR61C475KC01L MURATA GRM32RR61E475KA1 2b MURATA 1 Ba 02375 20 575 1041 O Ba 03997 20 575 1039 2 PA 04666 20 520 1008 O Ba 04692 20 575 1045 1 Ba 04970 20 500 1015 lt 1 0 11 32 TSSOP14 65MM 1 0 MDS001 SWITCH 1 0 R 1K78 1 0603 1 78K 1 1 Resistor 4 0 R 511K 1 0603 511K 5 5 Resistor 2 0 LM3394D Ic Nh Bow ERP Update 30 12 2013 12 59 Searchmode DCI search Fr 4 v amp 6 amp 3 Ha MATERIAL TYP 8 DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 WBZ 12299 5 4 7pF 1210 10 254 X5R E 4 74F 1210 y FOD4 7 0 39 951 00 0 Source DISTRIBUTOR SUPPLIER MPN DESCRIPTION STOCK CUR INFO PRICE1 QTy1 PRICE2 QTy2 PRICE3 PKOQTY QTY3 ROHS Preferred oc 4 ACE MUR GRM32RR6E1E475K GRM32RRE1E475KA12L 0 VIELSCHICHT SMD 4 74yF X5R 25V 10 23 7562 1 125908 2500 8 7898 1000 25000 Here a price list provided by ACE has been imported via the DCI and the DCI Search found a match for the Murata part The price information is displayed However no Scale Price has been highlighted because no Price Group has been selected Now if we select for example Price Group 50 Production Quantities Visible Quantity Filter Price per unit Price for all OQ a ERP1 1 USER 100 USER 5000 USER 10000 USER 20000 USER OQOODOODOOL Currency The currency for the total is EUR Then suddenly we see QTY 1 highlight
17. BOM Connector User Manual This is a very useful feature in the BC QUOTE module as it simplifies the part sourcing process To better understand this feature let s do a brief introduction to BOM Connector s distributor management 7 4 3 1 The BOM Connector database includes a list of distributors which you build up The Distributor List Distributor Handling Distributor is available when you click on the tab called lo 7 4 3 2 The Distributor Tab Customer Overrides for Distributor Aliases distributors Distributor email List of Distributors Reload Distributor DistriQutor request Load Distributor request DCI Distributor Distributor Priority 4 Star Electronics UNDESIRED ABC Components PREFERRED Prioritiy overrides for customers Customer gt Distnbutor Distributor gt Customer Customer 234 v Distributor Customer Priority Advonics Group AED Blectronics Allied Electronics Amazon com America Il Area51 Authorized Area51 Recertified Arrow ASAP Semiconductor Avnet Express NORMAL UNDESIRED NORMAL NORMAL NORMAL UNDESIRED UNDESIRED PREFERRED NORMAL NORMAL NORMAL 7 text routersolutions de v test routersolutions de Authorized for Manufacturer Authorized for Manufacturer PANASONIC KEMET ELECTRONIC E Advonics Group ABC Components ACE AED Blectronics Allied Electronics Amazon com America Area51 Authorized Area51 Recertified Arrow UNDESIRED
18. CL32B 105K Dw 120 VISHAY VJ1210Y 105KX 7 130 co03 CAPACITOR 10u0 0063 A E 130 CHEML CON KMF63VB1 MA E 130 NICHICON UPW1J100 W E 130 ELNA RJB 63V100ME3 MA E 130 RUBYCON 1J YXF 1040 As you can see there are many empty CPN fields BOM Connector has highlighted them in red to show that there is a problem here Additionally the Story area displays this You selected a column as CPN column This column contains empty helds with no CPN How should this be solved Copy CPN down Use generic key for every part without CPN Disable rows without CPN Do nothing The first solution is to use the Autofill rules You can either click on ir Select CPN and OK Or you can choose Copy CPN Down from the Story box 28 Router Solutions BOM Connector User Manual Additionally you can right click in the BOM itself CPN Posttion CPN y DONOTIMPORT RefDes H i Pos PN Index REF E z o 2 11 X933 123 J 05 3 12 X8484 455 V 105 120 30 4 40 X000 4550 05 5 110 110 Headline 110 i BOM has no headline 110 110 First row of the data area 110 Last cell of data area 110 Copy valuse down N 110 Copy valuse down grouped by gt pun Activate rows Es Deactivate rows 120 120 7 Create condition PN gt 130 Create condition PN lt gt 130 Crea
19. DEBUG parameter Answer with YES and hit SETTINGS to enter the configuration menu 3 4 Using BC Link for SAP A big plus for SAP users BOM Connector interfaces via standard scripts and BAPI remote function calls so it is always compatible with future versions and no additional costs are incurred on the SAP side 10 Router Solutions BOM Connector User Manual 4 Using BOM Connector 4 1 Start BOM Connector and update from ERP BC BOM Connector Invoke the BOM Connector Exe by clicking on the icon or via ALL Programs BOM Connector Note BOM Connector should automatically starts in English for non German systems If this is not the case simply add a 1033 for language code English in the start properties C Users myname AppData Local Router Solutions BOM Connector bin bomcon exe 1033 Where C Users myname AppData Local Router Solutions BOM Connector bin is the directory from which you are starting BOM Connector Note This icon should have been created by the installer automatically When you start BOM Connector the ETL is automatically invoked and the backend database is updated from the current ERP information If you have been working with BOM Connector for many hours and want to update i e sync with your ERP system simply click on the icon Update Part Data in the action menu Depending on the ETL a login might be required This will vary from customer to cu
20. LM339AD Ic a ma fnm aE a Ts PENNA ANP 4 p 21 Router Solutions BOM Connector User Manual As you can see REFDES CPN DESCRIPTION QUANTITY PACKAGE DEVICE TYPE were all assigned automatically ELECTRICAL VALUE and SUBCLASS are still set to DO NOT IMPORT So these fields if we want them to be imported will need to be assigned manually Let s start with ELECTRICAL VALUE Go the field header and click on the drop down arrow which you see next to it DO NOTIMPORT Y gt Electrical Value This will bring up a drop down list of field assignments Choose CPN Additional Description DONOTIMPORT CF DO NOT IMPORT Do the same for the field SUBCLASS For the field ASSEMBLED you should set this to Additional Field as this has no special function and should be read in as is RefDes Attribute Ref Des Position MPN MPN Manufacturer MPN Manufacturer Split Your BOM should now look like this RefDes CPN z Qua DONOTIMPORT CPNA CPNAdditiona CPN Addtional CPN Ad CPNA CPN Mai MPN MPN Man Additional Field RefDes CPN Quantity Description Package Device Type Electrical Value Tolerance Tolerance Subclass MPN Manufacturer Assembled Mu RefDes 1 E lus 20 500 1003 1 HC11 SO14N Ic 74_HC11 SN74HC11DR TI N 2 lus un 20 500 1015 2 LM339AD lic LM339AD LM339ADT ST MICR 3 Mus 20500
21. Read in a customer BOM clean it up scrubbing and use the various search methods such as SmartSeach CIS Search MPN Search and others to find the best matching part in your ERP system in order to generate what we call a Golden Manufacturing BOM for further processes This is a key feature for EMS suppliers as it is often one of the most time consuming and error prone tasks of the manufacturing process When used early on in the quoting department it can substantially reduce the time per quotation thus having a direct effect on the company s bottom line 2 Use the advanced quoting features to find the best possible price either through a search of your company s distributor list or a search of Online portals such as Octopart These prices can be stored for future use 3 During the manufacturing process BOM Connector can provide one click integration of the project s current BOM into your process engineering and shop floor tools such as the MSS suite of tools from the Mentor Graphics Valor Division This ensures that an incorrect or no longer current BOM does not end up in the manufacturing process 4 Compare different versions of BOMs this includes the following scenarios e New customer BOM with old customer BOM e New customer BOM with the current BOM stored in the in house ERP system i e the golden BOM e New Customer BOM with the BOM stored in Valor MSS Router Solutions BOM Connector User Manual e ERP
22. crucial link between BOM Connector and your material data The ETL has been pre configured on your system and if automated will take place all in the background To launch the connection manually see chapter 4 1 Start BOM Connector and update from ERP page 11 3 1 Required and Recommended ERP Data Fields Your ERP system should have the following fields defined e Customer Name recommended e Customer Number recommended e Internal i e ERP Part Number or IPN for short required e ERP Description Field or Fields required e Manufacturer Part Number or MPN for short recommended e Manufacturer Name recommended e Price recommended 3 2 Optional Data Fields There are no limits to the additional fields you can access in your ERP system and bring into BOM Connector via the ETL Here are some very useful ones e Additional prices e Bulk quantity prices e Storage location e Current supplier e Additional MPN 1 x e Additional Manufacturer Name 1 x e Process Since a well designed ERP link is crucial for the success of BOM Connector this should we discussed in depth with Router Solutions software specialists 9 Router Solutions BOM Connector User Manual 3 3 Configuring the ETL When you have launched BOM Connector you can configure the ETL by holding the CTL key and T Update Parts Data choosing from the Action Menu You will then be asked if you want to run in DEBUG mode Run ETL with
23. full read rights to the internal ERP system A client PC with at least 100MB free disk and 1280 X1024 resolution recommended 1024x768 will also work and a TCP IP connection min 2MBit to the ERP Server 2 2 Installing BOM Connector Because BOM Connector is a client server multi user system users in the different departments quoting Component engineering process engineering production etc all to access the same database and settings Therefore there are two steps to installing BOM Connector 1 Copying the software to the Server 2 Configuring the clients Step 1 Installing on the server Installing BOM Connector to the server is very simple Just create a folder with any name you wish For example servername BOM Connector Now simply copy the entire contents of the CD here Your directory will now look like this de config 17 10 2014 14 58 C Ub db 17 10 2014 14 59 di script 17 02 2014 10 21 E Je vPlanPlugins 17 10 2014 14 58 L di 17 10 2014 14 58 BOM Connector ETL pdf 16 08 2012 09 55 F E BOM Connector Scripting Intro pdf 29 10 2012 17 22 F E BOM Connector Setup pdf 24 06 2011 12 12 F E BOM Connector User Manual pdf 30 09 2014 11 16 F e bomcon ini 21 09 2013 21 30 K _ bomcon_6 6 0_update up 09 10 2014 11 32 L bomcon_setup exe 06 12 2013 10 18 That s all there is to it Step 2 Configuring the Clients The only thing to keep in mind here is that all clients you configure must c
24. the customer of the BOM Connector user Because oftentimes a customer provided BOM does not include the customer s partnumbers BOM Connector has a routine to generate a generic CPN based on CRC32 encoding of the description field For an OEM user of BOM Connector the CPN is identical to the IPN see next IPN Internal Part Number This is your partnumber i e the user of BOM Connector This is the key field in the ERP link For EMS users the correlation between CPN and IPN is extremely important MPN Manufacturer Part Number This is used by both EMS and OEM users of BOM Connector It refers to the actual partnumber published by the manufacturer This is used primarily by BC QUOTE to find and store the various offers AML Approved Manufacturer List Router Solutions BOM Connector User Manual This is often referred to as AVL approved vendor list BOM Connector uses AML to make it clear that these are a list of approved manufacturers as opposed to vendors which can include distributors BOM Connector has functions to import and maintain a list of which manufacturer parts are allowed for a given IPN or CPN Router Solutions BOM Connector User Manual 2 System Requirements and Installation 2 1 Hardware System Requirements BOM Connector is a true client server system with a direct link to the ERP system at its heart Therefore you will need a Windows Server drive with
25. 0 1006 h R 560R 1 0805 562 1 Resistor 560 5 5 Y R268 R269 R271 20 520 1007 4 R1K27 1 0603 1 27K 1 Resistor 1 27K 5 5 Y R306 20 520 1008 1 R 1K78 1 0603 1 78K 1 Resistor 1 78K 5 5 Y R326 20 5201018 1 R 8K45 1 0603 8 45K 1 Resistor 8 45K 5 5 Y R318 20 520 1042 1 R 9K09 1 0603 9 09K 1 Resistor 3 09K 5 5 Y R273 R274 R316 20 520 1062 3 R10K 1 0603 10K 1 1 Resistor 10K 5 5 Y R300 303 20520 1063 la R 10K2 1 0603 10 2K 1 Resistor 10 2K 5 5 Optone Y R194 20 520 1064 1 R 1K 5 0603 1K 5 5 Resistor 1K 5 5 sa ce Raf eN Y R102 R103 R105 R21 20 520 1066 44 R10K 5 0603 10K 5 5 Resistor 10K 5 5 Y R174 R175 R177 R259 20 520 1067 4 R 100K 5 0603 100K 5 Resistor 100K 5 5 an E Y R243 246 R296 299 R 20 520 1068 10 ROR 050 0603 050 MIL Resistor lo 5 5 Y F8 F9 20 520 1069 2 FUSE 4A 0603 4340044 Fuse 4A 74Ab A Y C95 C96 C98 C160 C 20 520 1070 12 C 470NF 16 X5R 10 060 Capacitor 470nF 110 ho Y R222 R223 R225 R26 20 520 1071 7 R1K1 0603 1K 1 1 Resistor 1K 5 5 numberformat Windows settings Y R319 20 520 1072 E R 5K1 10603 5 1K 1 Resistor 5 1K l5 5 Y C255 C256 20 520 1073 12 C10UF 16 XBR 10 1210 Capacitor 10uF ho 10 Y c220 20 520 1074 C4 7UF 25X5R 10121 Capactor Tur hio 10 Y C257 20 520 1075 1 C 22UF 16 XBR 20 1210 Capacitor 22uF 10 10 Special
26. 0603A Specfik genau einhaten R aif ma 0 04 10K 440603 5 50V TK200 Kono R4060 440609A 1206 ARRAY 1206 O YCIG4 Netz R 408604 0 08 10K 0603 0 1 25V TK25 Kono R0603 0603A 2 CRTOBUSBY 1002ELF ERA3AEB1OV R v lt gt lt gt Oct part MPN ERJGEKF1002 PX Gorce SKU DISTRIBUTOR MANUFACTURER MPN CUR INFO PRICE1 EUR QTY PRICEZ EUAJ QTY2 PRICES EUR QTY3 LTD ROHS PADTY A referred ERJSEKF 1002 4 Star Electronics Panasonic ERJ 3EKF10024 Updated 23 04 2015 ERU 3EKFIOO2V MUL Arow Panasonic ERJ 3EKF1002 Updated 23 04 2015 2397737 4 Fanel Panasonic ERISEKFIOO EUR Updated 06 04 2015 25000 903100 4 Newark Panasonic ERJ 3EKF10024 USD Updated 26 03 2015 v ERP UltraSearch ERP Material List This is a direct window into your ERP data 4 3 Using Windows Distributor price information for selected MPN Imported via the Distributor Catalog Importer DCI Or Octopart Info when Octopart search is invoked MPN ERP Box Displays 1 or more MPNs manufacturer names for the selected IPN All windows in BOM Connector are re sizable and with the exception of the BOM and ERP windows can be turned on off at any time To resize simply grab at the horizontal or vertical edge of a window The cursor will change form to a double arrow Now while holding the mouse down slide the window up down or left right Release the mouse button when finished There are two windows which can be hidde
27. 1 1 0 CA7ONF 25 X7R 10 805 470N 10 10 Capacitor 470nF 10 10 The two 470nf capacitors are displayed If we turn on the Sync button then the parts that match are displayed in the ERP window as well 30 Router Solutions BOM Connector User Manual to clear the search click on the off filter 30 M M S 52 CSw vl E 2 69 fea IPN CPN f RC 57 Quantitiy Es Description EX Device Type E Electrical Value E Tolerance 0 20 520 1070 12 12 0 C470NF 16 X5R 10 0603 470N 10 10 Capacitor 470nF 10 0 20 5651027 1 1 0 CATONE 25X7 10 805 470N 10 10 Capacitor 4700 10 RP Update 30 12 2013 12 59 Searchmode CIS Search 470nf v amp 22 11098 ma MATERIAL TYP B DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNL 03096 C0805 0805C S70AF 0805 10 504 x7R E 470n 0805 NF470 0 01 1899 00 04049 C0603 0603C 470NF 0603 10 50 637 NPO E 470n 0603 NF470 0 0025 2606 00 04363 C1206 1206C 470NF 1206 10 16 C 470n 1206 NF470 0 0 0 00 04342 C1206 1206C 4700 1206 10 50V X7R C 470n 1206 NF470 0 01 2000 00 06208 A7ONF AM22 5 275V MKP 470n RM22 5 NF470 0 3 196 00 05905 C0603 0603C 470NF 0603 10 164 x7R E 470n 0603 NF470 0 0045 3885 00 06102 A B709F 1812 10 1004 X7R E 470n 1812 NF470 0 0 07427 C1206 1206C S70NF 1206 50V Z5U E 470n 1206 NF470 0 0 07584 A7ONF 0612 25V x7R c 470n 0612 NF470 0 0 07962 C1206 1206C 700 1206 10 50V x7R 470n 1205 NF470 0 01 1980 00
28. 1100 1 EEPROM AT24C02AN 1 lic aT24CO2 AT24CO2AN10SI2 7 ATMEL 4 Y u50 u76 120 500 1112 2 PCA9557PW lic PCA9557PW AS557PW T PHILIPS 5 lus 20 500 1113 1 LV374 TSSOP20 65MM lic 74LV374 SN74LV374APWR TI N These assignment are very important to subsequent steps See below for a list of field assignments and their meaning Definition of Field Types Here are the available field types DO NOT IMPORT Additional Field CPN Main Description CPN Additional Description CPN Position RefDes RefDes Attribute Ref Des Position MPN MPN Manufacturer MPN Manufacturer Split Assigning this means do not import this field Assigning this means import column as is with same name Internal Part Number i e your part number Quantity see below 22 Router Solutions BOM Connector User Manual Customer Part Number i e the customer s part number Description at least one field should be assigned this These are additional description fields This is the position column in the BOM Reference Designators i e U1 R1 etc Attributes relating to a specific reference see below The position field for uncompressed BOMs Manufacturer Part Number Manufacturer Name Combination field consisting of MPN and Manufacturer see below Here is some further information on these fields types QUANTITY this is the field claimed containing the quantity BOM Connector will add a field RC which
29. 5 5 Key Field s Your customer BOMs do not include the customer part number No problem In such cases BOM Connector creates a virtual part number based on a CRC32 encoding of the Key Field s This is the field you assigned as Main CPN Description as well as those assigned as Additional CPN Description This generated number is then stored in the CIS along with the internal part number you assigned to it and can be re used in subsequent BOMS It is very important that this be done carefully Mis assigning the key field s can cause problems the next time you read in the BOM as the encoding is done EXACTLY according to the data in the fields Thus it is important to assign all relevant information as additional CPN description but NOT irrelevant data for example comment fields with data such as check with distributor Here is a good example REF Description Shape Value Comment R1 SMD Resistor 0603 100K any manufacturer R2 SMD Resistor 0603 10K Vishay R3 SMD Resistor 0603 10K Vishay or other Assigning only DESCRIPTION and SHAPE as Main CPN Description while the next two fields are simply assigned as Additional fields CPN Main Description CPN Addiional Des Additional Field will result in this 31 Router Solutions BOM Connector User Manual CPH RefList EE Description 2 shape EA value EN comment EN value 1 El comment 1 E comment 2 Note that
30. A FS 205291072 GETE 2 295201073 255 756 20 520 1074 C220 Click to add 205201075 257 3 y t t Ww eee one The first time you run this your list of templates will be empty 33 Router Solutions BOM Connector User Manual 5 3 4 Creating a New Template Let us create a new Template Click ADD NEW TEMPLATE BOM Export Name TEST Format The export template is empty To export a column you A have to active the column E F BOM F Tolerance Excel template lt Default gt X E CPN E CustomAttrib E Description F Device Type MPN INT nd E Blectrical Value F IPN E Quantity E Quantity 0 E RefCount Pricing E Subclass E Tolerance F UserNote RefDes Use RefDes format F BAUGRUPPE ee F BEZEICHNUNG2 E BEZEICHNUNG3 To charactar E Description Fl Repeat prefix E DESCRIPTION E IPN E LAGER 7 MAT_ID Export columns Default E MATCH E MATERIAL E Original single price E PRICE E TYP E wez E ZEICHNUNG MPN INT E Manufacturer INT E MPN INT MPN BOM E Manufacturer BOM E MPN BOM Pricing EF Comment E DefaultCurrency F EUR price E EUR total F 1D E Info Create date E Info Created by E Info Decay date Increment by 10 A tebe Cada dd NA AS ste SS gt w MPN BOM Create position number As you can see when you first create a template all fields are off First give your template a name We w
31. ALCULATION QTY RC E Auantitio Al Reflist E 11 Use in SmartSearch Ap Hide in compressed view 11 Add new column 22 Insert column duplicate 11 Hide column 11 Use as calculation qty E AA 54 Router Solutions BOM Connector User Manual 7 4 Searching for Pricing for Various Sources There are three main external sources i e outside the ERP system for obtaining price information a Distributor Catalog b Octopart c Distributor Request Let s go through each of these 7 4 1 Distributor Catalog BC Quote has something called a Distributor Catalog Interface DCI This is a configurable reader for distributor supplied price lists in Excel format The DCI automatically checks a user defined directory for the latest price lists and if the date is newer than the last time it checked it imports all pricing and scale information into the BOM Connector Pricing Database Once this information is available it can be checked via the DCl Search Taking the example we used in the MPN search in the BC PREP section we see DCI search Y Start 5 Auto Link El w Bi PY DF BOM details IPN CPN RC Quantitiy E Description FR Device Type E Electrical Value E Tolerance El TA Record RefDes Scale Prices 2 0 20 520 1075 1 0 C 22UF 16X5R 20 1210 22U 20 20 Capacitor 22uF 10 E BOM AML 0 20 525 1026 1 0 R 40K2 1 0603 40 2K 1 1 Resistor 40 2K 5 A MURATA 1 BA 12299 20
32. Actions The first step here is to assign field names in the BOM to BOM Connector field types This is a very important step Assignments made here will have a major effect on how the BOM is processed Therefore we will describe this in depth The first thing you should notice is the STORY entry on the left hand side of the screen 5 3 What is a Story A story is BOM Connector letting you know what needs to be done to address specifics in the BOM you are reading in and suggest steps to address them If we look at our story now it says There are no assignments for this BOM What to do This is because as you see all fields are set to DO NOT IMPORT So there is nothing for BOM Connector to do The possible solutions for a story are listed below the message in blue boxes In this case there is only one in future cases there will be several The solution listed for the story is 5 3 1 Assigning BOM Fields to BOM Connector Types Normally you should see how many of the fields can be automatically assigned The rest you can assign manually When you click on Autodetect Assignments you will see the following changes RefDes CPN DONOTIMPORT CPN Main Description CPN Addtional Des CPN Addtional Des DO NOTIMPORT y C RefDes CPN Quantity Description Package Device Type Bectrical Valve 4 RefDes u48 20 500 1003 1 HC11 SO14N IC 2 u9 U11 20 500 1015 2
33. BOM Connector Quote from 12 12 2013 CUSTOMER Ll PRICETOTAL PQLIST SA a mal 1 Feel free to modify this adding your company logo etc You can also add different placeholder fields The placeholders you can add are 1 Located at B4 is a placeholder for date The contents are Quote from amp 8 TEXT TODAY TT MM JJJJ You can change the text for example to a local language or the date and time format 2 BOM This specifies where the data should start In the sample it is at B12 If you want your data lines to start further down and a bit more to the right set this for example at C26 CUSTOMER This will insert the name of the customer here PRICETOTAL This will insert the old ERP based pricing here NOTE older versions of BOM Connector only 5 PQLIST This will insert the current Price Group information see chapter 7 BC QUOTE page 52 When you are finished rename it as you wish and place it in the XT directory in the main BOM Connector directory usually located on the server Once you have done this you will see when you hit the dropdown arrow next to EXCEL TEMPLATES Excel template Simply choose the Excel template you want to use by clicking on it 35 Router Solutions BOM Connector User Manual So now let us choose which fields we want to export As you can see the fields you can add are grouped into types The types are BOM these are fields
34. BOM with Valor MSS BOM This is a huge help in determining revision changes and is another key feature for EMS suppliers 5 Provide basic CAD viewing for early phases of the manufacturing process such as quoting or initial job review 6 Extract information from the CAD file and insert it into the working BOM Since often there is information such as technology side and station which is not included in the original BOM These functions are handled by these program modules JURA Y get TER PAL up to date m Cart DIMAS md avatabiity anc enter them nto you qucte Load and view CAD Gata and compare with BOM highly mietiigen search algoritiiens to ind the right part from the ERP System Plan scrub and erhance the BOM Check the contents of a BOM for changes errors or other misting information Cross check between revisions Read ay external BOM such as Cecel CSV HTML ot free teat Export BOMs in any Geseed format Automated Dowr cad of BOMs from your ERP System and upload of the Golden BOM into ERP Drect link to diff rent data sources such a6 ERP technical component database Valor MSS and others 1 2 Defining Basic Terms There are several terms we will use throughout this manual as these are used throughout BOM Connector These are CPN Customer Part Number This concept is a key part of BOM Connector and is used almost exclusively by EMS companies It is the partnumber used by
35. ERP INTERN if it was imported via BC LINK or BOM Connector if it was part of a BOM that was imported LinkSource This specifies where the link to your IPN came from This will either be ERP INTERN if it was imported via BC LINK or BOM Connector if it was assigned by you while working with BOM Connector or INTERNAL if it was created by you using the CREATE MATERIAL feature in BOM Connector more on this later BA These are User Attributes BOM Attribute that you assigned while working with BOM Connector see below CPN This is the customer part number as described above IPN This is your internal part number linked to the CPN as described above Description This is the description field which was in the BOM you imported at the time you saved the data to the CIS Memo You can manually add comments i e Memo to a CPN in the BOM Window while working with BOM Connector These are saved to the CIS if you check the SAVE USER NOTES box when you save In the example above 20 520 1006 has three IPN assignments The first came through from the ERP system via BC LINK Here is was defined that when Cyberbrains uses CPN 20 520 1006 then IPN 11792 should be used Thus the source of the CPN AND the IPN are ERP and they are in green The other two assignments were made while working with BOM Connector Thus the source of the IPN Link is BOM Connector Since the CPN originally came from the E
36. H1546AEF 280hm 350 120mA Solid state relay 504 DF085 diode bridge 800 14 504 You can activate a filter expression from the 504 by double clicking it The filter function works incremental limiting more records with each new input The filter is removed automaticalh you move to another record in the BOM grid The following placeholders are available an can be used in filter expressions any string one char one digit abc one char from the list 46 Router Solutions BOM Connector User Manual Here we have added the filter SO4 in order to shorten our list to only show parts from the ERP system which contain the SO4 As you can see you list has been considerably shortened Choosing an IPN Automatically Adds all Associated MPNs into the BOM fea IPN MPN Code MPN Supplier Ba 21132 873139 CUS_ABB Ba 21132 073139 CUS_ABB Note for this to work your ERP link ETL needs to have been written to properly handle MPNs If this is not the case contact Router Solutions 6 5 Operator Search Even the smartest of searches will not cover all the myriad parts on the market This is why we have built a very powerful Operator search into BOM Connector We call it Operator search because statements like equal not equal contains etc are known as operators in database language There are several instances where the operator search will produce the best results A good examp
37. O SOmW 14 PN9999 R333 SMD jumper 0603 ORO SOmW 15 PN9999 R334 SMD jumper 0603 ORO SOmW 16 PN123 R353 SMD Res 1 2512 1W 10ppm 17 PN123 R354 SMD Res 1 2512 iW 10ppnm 18 PN9999 R356 SMD jumper 0603 ORO 50mW 19 PN9999 R357 SMD jumper 0603 ORO SOmW 20 PN9999 R338 SMD jumper 0603 ORO 50mW 21 PN9999 R366 SMD iumper 0603 ORO 50mW When finished click on OK to import the BOM The columns you defined will be remembered if you try to import the same BOM again If you see in the Fixed Width Editor that the BOM is actually a CSV file and not a fixed width simply click on the CSV button at the top to return back to the CSV settings Set them accordingly and import the BOM 5 2 Importing a BOM Once you have started BOM Connector the first step is to read in your BOM This is by far the most important part of the entire process Therefore it is important to go over this step thoroughly The BOM Import feature is part of the BC IN OUT module and is standard part of every BOM Connector configuration 19 Router Solutions BOM Connector User Manual Actions Click on BOM IMPORT in the action menu BOM import If this is your first time working with BOM Connector you will immediately be in browse mode to select a BOM If you have been working for some time you will see a list of the last 16 depending on resolution BOMs you have read in To load one of these again simply click on it Otherwise to choose a new BOM select
38. OPTIONS If you look at the Special Actions Menu you will see several additional options Options am m Ret PA CPN mo O Des m number ormat Windows settings gt Here is a description This lets you specify if a generic CPN should be created for i parts that do not have on See Section 5 2 Use generic CPN if CPN is 0 The quantity field can be a whole number or a fraction i e 0 3 numberformat Windows settings Since there are two international norms for expressing fractions 5 i e 0 3 or 0 3 you can select which one to use here If you keep it as Windows Settings then BOM Connector will use according to these You can force a different format by selecting it here mm Additional Column Manager This allows you to add columns to the BOM Hit this and it will m bring up the following dialog Columns from BOM This allows you to create columns which are combination of other columns For example lets create a new column which consists of DEVICE TYPE and SUBCLASS To add a new column hit ADD COLUMN Type in TEST as the name of the new column and select the DEVICE TYPE and SUBCLASS columns 26 Router Solutions BOM Connector User Manual Columns from BOM Add column Remove selected column ss c
39. OWN VOLTAGE MA Diode 40 5 BOM AML 10 20575 1032 1 VAM SIP40 Connector ERJ3EKFIOOAV PANASONIC 16 205751035 1 USB VHC112SO1EN Ic 12 205751031 1 U64 TC7SH SC705 Ic 1 205751027 4 03 04 05 06 SCHOTTKY RECT 34 50 Transito 47 20520 1007 3 R268 A269 R271 R1K27 1 06031 27K 1 1 Resistor 5 5 127K 20520 1066 44 R102 R103 R105 R216 R217 R21 P10K 5 0603 10K45 5 Pesistr 5 5 10k ES 20575 1030 4 A70 A71 R73 R257 ROROO3 1 RES250 SMT 0 009 12 1 Resistor 5 5 m J 20 5201068 10 R243 R244 R245 R246 R296 R29 ROR 050 0603 050 MILLI OHMS Resistor 5 5 0 48 20520 1042 1 R318 R 9K09 1 0603 9 09K 122 1 Resistor 5 5 90 A mE 205201018 1 R326 R 8K45 1 0603 8 45K 1 1 Resistor 5 5 845K v Price E gt Columns v Y amp Record J IPN PRICE DESCRIPTION 8 MATCH 8 TYP WBZ _LINKMPN BEZEICHNUNG BAUGRUPPE SUPPLIER MPN REFER al on 0 001 10K 06031 50V 0 1W TK100 Koo R0603 0603F 2 CRCWOSO31OKOFKTABC P2350024110 R E SAMSUNG AI 5 47 x 0 0 10K 06031 50V K010 Bosch R0603 0603A 0 Bosch Gl ckler R ENAT enn 47 0 0 0 10k 06031 75V 0 1 TK100 Koo AGO 0603A R PAP PANAN al om 0 0072 10K 0603 1 SOV TKS0 Koo R0603 0603A 5 MCTOB030C1002FP500 Dini R ee IA a al 1 0 41 10K 0603 1 60V TK50 ThinFim K010 R0603 0603A 0 _CPFOGOGF1OKC1 CPFO6OQF1OKC1 MC R RE IA 3 al mm 0 002 10K 0603 5 50V Kono R0603 0603A i R ni 0 0 0 10K 0603 0 1 75V TK25 Koo R0603 0603A 2 231221671003 AN73F1J10KBTDF RT R aA o 0 0 10K 06030 1 TK10 Kono R0603
40. Price to BOM Copy all Prices to BOM Copy Note to BOM Copy all Notes to BOM To copy all notes to the BOM simply select Copy all Notes to BOM 49 Router Solutions BOM Connector User Manual 6 7 3 Saving Assignments and User Attributes In order to save when you have assigned internal part numbers customer part numbers as well as any user attributes hit the CIS amp PRICE SAVE icon y Update user attributes of linked customer parts in CIS Save customer parts without IPN link Save CPN Memo Save price group data Hint Before clicking the Save Data menu item press and hold the CTRL key to automatically save pour data using the current settings as default OF Cancel You can now choose whether you want to save only the part number correlations you have made or additionally wish to save all user attributes with or without part number correlation 50 Router Solutions BOM Connector User Manual 7 BC QUOTE The BC Quote is a great tool for making quotes To understand the BC QUOTE module it is important to understand the BC concept of pricing The first and most basic source of pricing is your ERP system If that price is accurate enough for quoting then the BC LINK module will import these prices as part of the ETL process and all is fine You can use them without further effort However finding the right price for quotation and part sourcing is normally far more complicated The ERP price is usually
41. R28 SMD jumper 0603 ORO 50mW 4 P N9999 R35 SMD jumper 0603 ORO SOmW 5 PH9999 R36 SMD jumper 0603 ORO SOmW 6 PESS99 R38 SMD jumper 0603 ORO SOmW 7 PN9999 R44 SMD jumper 0603 ORO 50mW 8 PR99993 R48 SMD jumper 0603 ORO 50mW 9 PN9999 R56 SMD jumper 0603 ORO SOmW 10 PN9999 R64 SMD jumper 0603 ORO SOmW Ll PN9999 R84 SMD jumper 0603 ORO 50mW 12 PN9999 R86 SMD jumper 0603 ORO SOmW 13 PN9999 R326 SMD jumper 0603 ORO SOmW 14 PN9999 R333 SMD jumper 0603 ORO 50mW 15 PHSSSS R334 SMD jumper 0603 ORO SOmW 16 PN123 R353 SMD Res 1 2512 1W 10ppnm 17 PN123 R354 SMD Res 1 2512 1W 10ppnm 18 PN9999 R356 SMD jumper 0603 ORO SOmW Now simply use your mouse to click on the end of each column Fixed width format bral isa La ned width format To sanh re column width simply click in the preview window below The marker CSV the beginning of a new column When finished simply click OK ifthi dei is ed a fixed width BOM Sere ack on CSV File to re read as a CSV 1 PN9999 R12 SMD jumper 0603 ORO 50mW 2 PN9999 R16 SMD jumper 0603 ORO 50mW 3 PN9999 R28 SMD jumper 0603 ORO 50mW 4 PN9999 R35 SMD jumper 0603 ORO 50mW 5 PN9999 R36 SMD jumper 0603 ORO 50mW 6 PN9999 R38 SMD jumper 0603 ORO 50mW 7 PN9999 R44 SMD jumper 0603 ORO 50mW o 8 PN9999 R48 SMD jumper 0603 ORO 50mW 9 PN9999 R56 SMD jumper 0603 ORO 50mW 10 PN9999 R64 SMD jumper 0603 ORO 50mW 11 PN9999 R84 SMD jumper 0603 ORO 50mW 12 PN9999 R86 SMD jumper 0603 ORO 50mW 13 PN9999 R326 SMD jumper 0603 OR
42. RP system the source CPN Source remains set to ERP 42 Router Solutions BOM Connector User Manual To Delete a CIS entry simply select it do a right click and choose DELETE CUSTOMER MATERIAL Cyberbrains Inc 4004 de Show all Customer Parts 22 Links 24 y Customer ID Customer Name Pref CPN Source Link Source BA CPN 4004 Cyberbrains Inc C BOM Connectar ROM Connector 20 500 1113 4004 Cyberbrains Inc F BOM Delete Customer Material 4130 4004 Cyberbrains Inc e BOM Copy KIS data 003 4004 Cyberbrains Inc ERP eee 006 4004 Cyberbrains Inc F ERP 006 4004 Cyberbrains Inc ERP Copy Note to BOM 006 4004 Cyberbrains Inc F BOM Copy all Notes to BOM 007 Note you can only delete entries which have been created with BOM Connector ERP entries are deleted or added via the BC LINK ETL process depending on the information in the ERP system This is done to preserve the integrity or the ERP data and its status as master Now back to our exercise 6 2 1 Running the CIS Search The CIS Search runs automatically when you load a BOM if you have the following under SETTINGS in the Action Menu Edit User Attributes Common Settings Search CIS automatically after importing a BUM file When you hit the CIS Search button BOM Connector scans through the currently assigned parts and shows them in the lower window This may be one or may be many By double clicking on the internal part number in the lowe
43. Router Solutions The Evolution of Electronics Manufacturing E User Manual BOM connector Status Q2 2015 Current Version 6 10 Router Solutions BOM Connector User Manual Table of Contents 1 _Ihitroduction 6 BON Connect dotada 1 1 BOM Connector ODvervieW maenna a a A a 1 2 Deining Basic TEMS atari 2 System Requirements and Instala iene ee ed Hardware System RequireMentS cccoooccnccccccnnccconnnnoconcnnnnonnnnnononcnnononnnnnnnonnnnnnancnnononnnnnonaneness 2 2 ASAMNTBOM CIA O endo tackle 2 Bt dl Required and Recommended ERP Data FieldS ccccccccccccnnccnnnnccccnconnccnnnnnonononanncnnnnonoss Oz Optional Data Fields od 3 3 COnigunnd Met tots 3 4 US BOTANA e els is 4 USING BOM Connector ooo ccccecccecesececeseeeeeseecenececeuececenececeneeteeseatanecetaneceteneseneeeeeeneetegeeetseeensness 4 1 Start BOM Connector and update from ERP occcoccnccccccccnccncncnncnnnannnnnnonnnnonncnonanonnnnnnnonos 4 2 The NIS CF WGI AC enuis ii dd dit da io ile dais 4 3 o a a ealsoesae E iceeseente casted 5 BOIN OU as 5 1 ANS FORMAS A StF Reading Ima Fixe Width BO Misas 5 2 INDO FING a BOM ossee eae a Gs Whaea ION oa 5 3 1 Assigning BOM Fields to BOM Connector Types cccccccccccccccccnnnnnnonnncncnnnnnnononononnnnnnnnnnnanos Bice SCUING Conditions ia 5 4 MUON NC IN Se eto e eddie eae 5 4 1 AutoFill Example and Resolving with a CoNditiON oocccccoccnccccnncconnnoconnnonon
44. SSOP14 65MM Ic MIR MURATA ba 03997 20 575 1039 1 1 0 MDSOO1 SWITCH Switch GAMIARDIESIRATA MURATA ba 04666 20 520 1008 1 1 0 R1K781 0603 1 78K 1 1 Resiste pa 04692 20 575 1045 4 4 0 R 511K 1 0603 511K 5 5 Resiste pa 04970 20 500 1015 2 2 0 LM339AD C y gt Ipdate 30 12 2013 12 59 Searchmode MPN Query TY DE SA vl Y O E SUPPLIER MURATA GRM32RRBIE475KA12L 25V x MATERIAL TYP 8 DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 MURATA GRM32RR61C475KCO1L juice DISTRIBUTOR SUPPLIER MPN DESCRIPTION STOCK CUR INFO PRICE1 QTy1 PRICE2 QTY2 PRICES PKQTY QTY3 ROHS E A erred Arrow Murata GRM32AR61E475K 1210 4 7 uF 25 X5R 10 0 4 Brooks amp Mal Murata GRM32AR61E475K 1210 4 7 uF 254 X5R 10 4 Future Electr Murata GRM32AR61E475K 1210 4 7 uF 25 Y X5R 10 D USD 1000 2000 4 AS Compone Murata GAM32RR61E475K 1210 4 7 uF 25WX5R 10 730 tral Avnet Express Murata GRM32AR61E475K 1210 4 7 uF 25 Y X5A 10 0 USD 1000 5000 10000 Avnet Expres Murata GAM32RR61E475K 1210 4 7 uF 25 Y X5A 10 3000 Components Murata GAM32RR61E475K 1210 4 7 uF 25WX5R 10 4 Digi Key Murata GRM32AR61E475K 1210 4 7 uF 25 V X5R 10 1361 USD 1 10 500 Digi Key Murata GRM32AR61E475K 1210 4 7 uF 25 VY X5R 10 D USD 2000 Digi Key Murata GRM32AR61E475K 1210 4 7 uF 254 X5R 10 1361 USD 1 10 500 This tells us that the PRICE2 is the Scale Price that match
45. ails Record RefDes Scale Prices 1 BOM 7 AML A CREWOSOSSBORFREA DALE Edit AML data Copy cell value Octopart Search This will run the Octopart search for that specific MPN You can also run the Octopart search for specific MPNs in your ERP system To do so right click on the MPN in the ERP MPN INT Window SUPPLIER MPN VISHAY CROWO805560RFKEA DALE CRCWOSO5560RFKEA _ SAMSUNG AL2M2FAA1ES Edit AML data Octopart Search all MPNs Octopart Search selected MPN As you can see you can either run the search for the chosen MPN or for all the MPNs which are linked to the IPN by choosing the middle option Octopart Search all MPNs If you click into the Octopart Window area and right click you can Open the Octopart Website and access information available there such as the data sheet for that part 2 50P S BUCHSE SCSI 300n o a 41 155 LT3741 A Add Price to BOM Open Octopart website MPN Trackback gt Distributor data STOCK CUR Copy value PRICE3 Q Copy record A Te EIA O 85000 USD 0 4 0 10000 USD 15000 1 0 20000 USD 5000 0 7153 USD 10 7 4 3 Distributor Request For parts that you can t get a price for using the ERP price the DCI search or Octopart BC QUOTE has a Distributor Request feature This lets you send out an RFQ request for quotation to a list of distributors 98 Router Solutions
46. all parts are given the same generated CPN number This is because the information in DESCRIPTION and SHAPE is identical for all parts This will cause issues in making the proper assignments in BOM Connector Therefore we re import the file with the following settings e Main Description 7 CPN Additional Des CPN Additional Des AUN ee s me CTD IO IO a And we get this after import LPH RerList ES Description ER shape EN value a comment LAC32 9231E8F0 Ra SMD Resistor 06043 TOK Vishay or other CAC32 B4C0 56849 R1 SMD Resistor 0603 100K any manufacturer This is also unsatisfactory because now ALL parts are given a different generated CPN even though R2 and R3 are clearly the same part Therefore we run the importer one more time as such CPN Additional Des Aer And we see this after import ca LPN RetList ES Description EN shape EA value ER comment ER comment 1 CAC 73431205 Fil SMO Resistor DEUS 100K any manufacturer 5 6 Exporting a BOM Note normally you would not export a BOM until you have prepared it properly using the BC PREP and perhaps BC CAD and BC QUOTE modules However we will now proceed first directly to the export module You can return here later once your BOM is complete To export a BOM click on BOM EXPORT The first thing you will see is a list of templates It is important to understand this concept fully 5 6 1 What is a Template Us
47. annnnnnnnnnnnnnnnnnnnnnnnnnnnnnns 55 LAT DLUGA lia ci cd 55 TAL De o a als OS 56 LAS DISMDItoOr Request as 58 Fo A a A E O O E ee eg ee eee eee 63 0 BC CE CC issues sias 65 8 1 Checking the BOWTOFINCOAS IS NOS ci lada 65 8 2 Compare two versions of a BOM iniciada 65 8 3 Compare a New BOM with the Master BOM in ERP ooooccccnnnnnnncccccccccccnccncnnnnncncnnnnnnnnnnnnnnnnnos 66 8 4 Compare a New BOM with the Master BOM in MSS oooooncccnnnncnnncnnonccnnnnnnnnnnnnnccnnnnnnnnnnnnos 67 AAA PPP er eee atte eer aren tae eee a eae 68 TO Oia m4 ws V2 ps Cocker ee eee ee eR eS EATR 69 10 1 Reading From MSS Process Prep vPlan ccccccccocncnnccccconcnncocnnnncnncnonannnnnononancnnnononanenonoss 69 10 2 Writing to MSS Process Prep vPlan ccccccconnconccccconconccononncnnonononnnnnnnonannnnnononancnnnonnnanennnnss 70 Router Solutions BOM Connector User Manual 1 Introduction to BOM Connector 1 1 BOM Connector Overview BOM Connector is a bill of materials preparation handling and quoting tool for EMS and OEM electronic manufacturers Dealing with BOM data is one of the biggest headaches faced by both OEM and EMS manufacturers EMS manufacturers are confronted daily with a wide variety of BOM formats and ever changing content Usually the only rule that applies is there are no rules Matching customer parts to internal parts comparing different BOM revisions and communicating with purchasing are too often d
48. berbrains Inc C BOM Connector BOM Connector 20 500 1130 09748 FET IRF7313 TR 4004 Cyberbrains Inc C BOM Connector BOM Connector 20 520 1003 07781 R 430K 5 0603 430K 1 7 1 yovxtsdfsdf 4004 Cyberbrains Inc C ERP intern BOM Connector 20 520 1006 01095 R 560A 1 0805 562 1 7 1 4004 Cyberbrains Inc C ERP intern BOM Connector 20 520 1006 02751 A 560A 1 0805 562 1 1 4004 Cyberbrains Inc ERP intern ERP intern 20 520 1006 11792 A 5601 1 0805 562 1 1 4004 Cyberbrains Inc C BOM Connector BOM Connector 20 520 1007 14328 Rik2 1 0603 1 27K 1 1 4004 Cyberbrains Inc C BOM Connector BOM Connector 20 520 1008 04666 R 1K78 1 0603 1 78K4 1 7 1 4004 Cyberbrains Inc C BOM Conmector BOM Connector 20 520 1018 11070 R 8K45 1 0603 8 45K 1 1 4004 Cyberbrains Inc C BOM Conmector 20 575 1036 20 575 1036 M x1614EUA In the example above there are several entries for your customer CYBERBRAINS which has the ID number 4004 Here is a description of the fields CustomerID This is the customer number as described above CustomerName This is the customer name as described above Pref If there are multiple IPNs assigned to a given CPN then you can specify here which one is preferred for example 20 520 1006 has three IPNs assigned 01095 02741 and 11792 but 11792 is set to preferred So it will be automatically assigned when you use Auto Link CPNSource This specifies where the CPN came from i e how did it enter the CIS This will either be
49. cause it allows us to make inquiries of pricing from sources in addition to the ERP system for a minimum order of 1 Remember ERP1 is ONLY from the ERP system as source 92 Router Solutions BOM Connector User Manual Let s start with the simple example of using prices from ERP 1 1 In the exercises during the BC PREP section we used the various search routines to find and assign parts from the ERP systems IPNs to the customer parts in the BOM CPNs Some of these parts had prices in the ERP system When you turn on ERP1 as above you will notice that two new columns have appeared and some prices fas E 1 EUR S 1 EUR IPM CPM ba 04970 20 500 1015 0 09 0 09 MM 08437 20 500 1100 20 500 1112 a 11792 20 500 1113 ma 09748 20 500 1130 0 0014 0 0056 B 07781 20 520 1003 20 520 1006 0 0009 0 0027 Ma 14328 20 520 1007 0 0008 0 0008 BI 04656 20 520 1008 0 01 0 01 wa 11070 20 520 1018 E 1 refers to the Price Group of ERP1 S 1 is the Sum which for this particular Price Group is equal to the REFCOUNT The Price Group itself now displays the total NOTE BOM Connector calculates the prices based on EITHER the Qauntity Field in the BOM or the Reference Count RC If you do not see prices appear even though you have them available you probably are missing one of these To set which should be used by BOM Connector right click on the field you want to use either RC or QTY and select USE AS CALCULATION QTY RC A
50. cept to help you through the process Conditions to handle multi use fields Color Viewer for patterns and as an aide for spotting inconsistencies Expanded Settings for dealing with the myriad methods for expressing MPNs reference designators etc Fixed width editor for handling columnized BOMs 5 1 File Formats When you select a file the BC IN BOM reader should usually automatically detect the file type if it is an Excel File or a CSV file Sometimes however due to different extensions or international coding or for fixed width columnized BOMs this doesn t happen properly The FILE FORMAT list on the left hand side of the screen lets you specify what format the BOM you want to read is in Here you can also set options for the CSV reader File format Y Tab Click here to read the BOM in as an Excel file AAA Here you can select which sheet in the Excel file to read in If the E Excel file only contains one sheet it will always be displayed here as default To select a different sheet hit the drop down arrow E and choose the sheet name and hit to reload with the newly chosen sheet Click here z to read the file in as a CSV file NA Here you can set the delimiter for the CSV file Typical delimiters Tab are P space or TAB Simply input the delimiter of your BOM or hit TAB if that is the delimiter Normally if you try reading the BOM in with the wrong delimiter you w
51. ces The name and number for each of them is the manufacturer and MPN For example Manufacturer MPN Panasonic ERJ3EKF5113V Yageo RCO603FR 071K78 The relation between IPN and MPN is 1 n For one IPN there can be n i e 1 or more MPNs associated with it If you look at your ERP window this is displayed as such vl Y O E SUPPLIER MPN INF 4 AVS OS056D475KAT2A MATERIAL TYP 8 DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 07664 C1210 12100 4 7uF 1210 10 50V X7R c 4u7 1210 F004 7 0 13 549 00 ecu ME 04841 C0805 0805C ie 0805 m 6 34 X5R c OE EIA 0 01 993 00 A A 05047 C0603 0603C rea 0603 a S NDC XSA c PETTY F047 0 0088 2533 00 A eee f a fa ue sel SAMSUNG CL214475KOFNNNE 05108 C0805 0805C 4 74F 0805 10 16V X5R c 4u7 0805 yFO04 7 0 02 2549 00 05173 C0805 0805C 4 74F 0805 10 10 X5R c 4u7 0805 yF004 7 0 02 6883 00 06354 C1206 1206C 4 74F 1206 10 50V X5R c 4u7 1206 yFO04 7 0 08 1631 00 NAPAA PASAA MANAF 7uF NANA 110 PAV KAR F dni NANA uFnnd 7 nn The MPN Manufacturer Part Number search can only be used if the BOM provided by your customer contains MPN information or if the customer has provided an AML approved manufacturer list file and you have read this into BOM Connector see Chapter 5 BC IN OUT page Therefore if you receive a BOM from a customer and you need to find the IPN which most closely matches a CPN a logical place to start would be to search for which IPNs u
52. de Check CPN 20 520 1007 BC CHECK has reported that although the Qty field in the BOM specifies 4 there are only three reference designators R268 R269 R271 So there is a mistake in the BOM 8 2 Compare two versions of a BOM To compare two BOMs you must first save them in CSV format Aun BOM Compare Then choose from the Action Menu 65 Router Solutions BOM Connector User Manual Choose BOM1 and BOM2 then choose a key field this is normally either Reference Designator or CPN IPN You will see a report showing all entries that are the same green and all differences yellow as well as all new parts white To make it easier to read turn of the parts which are the same by clicking on the turn off box Compare Compare a new BOM with the master BOM in ERP 8 3 Compare a New BOM with the Master BOM in ERP To run this you need to have the BOM from ERP feature activated as part of the BC EXCHANGE module See Chapter 10 If this is the case then you can choose the ERP MSS Tab and hit LOAD BOM option BOM Data CIs ERP MS5 Load BUM Lo pr BOM Ex port to CL Save CS BOM Header This will bring up a dialog Here you can enter the project number in the ERP system as in this sample from SAP note this dialog will vary depending on your ERP system used Maternal Plant lternative BOM type Valid fram Change No Revision test test 1 Do not resolve chained products Mas number of hierarchy levels 1
53. dit an existing template go back to the template list and click on the edit icon Follow the instructions above as editing a template works the same way as creating a new template 5 7 Using the Export Function 5 7 1 Exporting With Template To export with a template simply click on EXPORT BOM from the main BOM Connector screen Sh Export BOM You will now see a list of templates Choose the template you want to use and click EXPORT at the lower right corner If your export type is EXCEL this will open an instance of Excel and show your exported BOM You will remain in the same screen in BOM Connector 39 Router Solutions BOM Connector User Manual If you click on OK it will export the BOM and return to the main BOM Connector screen Click CANCEL to return to the main BOM Connector screen without exporting 5 8 Viewing the Results The results can be viewed immediately with Excel or in the case of CSV files with any standard text editor 40 Router Solutions BOM Connector User Manual 6 BC PREP Preparing Customer BOMs and Production Planning This module is at the heart of BOM Connector from EMS companies After you have read in the BOM you will note that the search icon at the top of the screen becomes l 2a CIS Search Y Start active These search features form the basis of the BC PREP module They allow you to quickly find the best part in your ERP system to match the part in the BOM i e
54. e Distributor C Plus Electronics 345345 0 5895858 SKU Manutacturer PHILIPS MPN AS557PW T IPN 03964 7 5 QuickPrice Last but not least the newest quoting assistant in BOM Connector is called Quick Price This allows users to get a fast overview of what vendors are currently offering what prices Quick Price is a great way to get the latest pricing on any part The routine looks through all pricing sources ERP system Distributor Catalog via the DCI Distributor Catalog Interface and the online portal Octopart How to Use To use this feature you must have MPNs manufacturer part numbers in your BOM To launch Quick Price just choose it from the search drop down list and click START Note if it is the first time you are launching it you won t need to click START it will launch automatically BOM Data Conditions Q Quickprice Y Start The first dialog asks to identify the MPN field in the BOM MPN search Quickprice Select MPN column MPN_SUPPLIER v Use fault tolerant search Choose the MPN field in the BOM and click OK If you sort the BOM by Number of results you will see what part numbers in the BOM have the most matches in the QuickPrice window 63 Router Solutions BOM Connector User Manual TIA 2 2 3 Click on a part in the BOM and you will see the results for that part in the QuickPrice window 3 3 6 For example if we choose the result with 6 we can see t
55. e accurately you assign these the more accurate and reliable will be the generated CPN For re usability on future BOMs from the same customer this is critical REFDES Attribute In non compressed BOMs i e where each reference designator is a separate entry there are often attributes which are not for the part itself like value tolerance package etc but 23 Router Solutions BOM Connector User Manual rather for each specific reference designator Good examples of this are XY location angle side etc These attributes are only visible in BOM Connector when you are in non compressed mode They disappear in compressed mode i e where each part is listed once and all reference designators belonging to it are grouped together in one field It is therefore very important that refdes attributes and CPN attributes be properly assigned otherwise you will get consistency issues later i e different attributes assigned for the same part MPN MANUFACTURER SPLIT These fields can be very tricky Sometimes the MPN is listed first followed by the Manufacturer name as in ERJ3GEYJ434V Panasonic Other times the field is reversed Panasonic ERJ3GEYJ434V Sometimes the entries are separated with a different character Panasonic ERJ3GEYJ434V Sometimes they contain multiple parts Panasonic ERJ3GEYJ434V Kemet 232270260102 In short the only rule is that there are no rules This is why BC IMPORT has a very flexible rule editor
56. ea behind this is that you can use your experience to tell BOM Connector for the future that for example certain parts are problematic and should not be used The user attributes and their colors are defined by you under the SETTINGS icon They are then stored in the CIS 6 7 1 Creating User Attributes Click on the SETTINGS icon Edit user attributes Common Settings My search providers Colored attributes can be linked to customer parts CPN in the BOM grid E Aid To define an attribute enter the attribute rder No Comporent name into one of the textboxes To delete an attribute simply delete the text Do not use from the textbox Attention IF you remove an attribute it will be deleted heck mth custornerca MEN dl all customer parts in the BOM DE oo Click an entry to edit attribute text 48 Router Solutions BOM Connector User Manual The settings you make will be stored in the CIS and will be available in future whenever you do a CIS Search of use Autolink The colors also appear in the Excel file when exported 6 7 2 Assigning User Attributes Click on a part number in the BOM window Right click and choose User Attributes then select the one you wish to assign BOM Data CIS ERP MSS PCB Pricing Data AML Distributor a i 103 E Za CIS search Y Start Auto Link E as Q 9 S 9 IPN CPN RC RefList TON 20 575 1026 4 CR1 CR2 CR3 CR4 0 20 575 1032 1
57. ecal OK Cancel You see a preview of the newly created column at the right To add this to the BOM click OK Re REFDES Rule Editor BOM Connector can automatically increment reference designators Des Refdes formats can be very simply such as R1 R4 This should clearly be translated as R1 R2 R3 R4 But what about more complicated cases For example R100 R400 This could result in 300 resistors or 4 resistors depending on the numbering These rules are defined here Click on the icon and you see the Refdes Rule Editor RefDes Strategy Default v Refdes Format Explained Examples R100 R104 is R100 R101 R102 R103 R104 RefDes expension char R50 52 is R50 R51 R52 RefDes may be split over multiple cells Replace line breaks with spaces OK Cancel This describes the simple expansion explained above Here you can simply enter the expansion character i e in most cases If you choose Single Digit Increase you can specify that for example R100 R400 should be translated as R100 R200 R300 R400 The expansion will take into account the quantity field and choose the correct digit to expand simply click again to remove the green underline This will then take the first line as a data line and not as a header This specifies that any line not containing a CPN should not be imported This is very useful for A This specifies that the BOM has a header indicated by the green underline To change
58. ed eee PRICEY QTY1 PRICE2 QTY2 PRICES PKOTY QTY3 2300 0 1898 1000 5000 This tells us that the PRICE1 is the Scale Price that matches for this Production Quantity 55 Router Solutions BOM Connector User Manual To select the price simply right click and choose ADD SCALE PRICE The price is added to the SCALE PRICE tab in the BOM Details Window BOM details F Comment i DCI EUR 1 23 ro62 23 562 SKU 2500 12 5908 12 5908 Distributor ACE 25000 8 7838 5 7895 MPN GRM32RR51E475k471 Manufacturer MUR IPN 12299 F Comment GAM32ARBTE4F5KAT y If the price doesn t appear in the BOM it is because there is a better price ii BC QUOTE s best price function has taken it To de activate the other prices simply uncheck them 7 4 2 Octopart Octopart is a web based portal where many distributors post up to the minute pricing The Octopart interface is developed using the Octopart API toolkit To search for prices on Octopart you can P Octopart search O Start choose This brings up the following dialog Select MPN source for search O Search by using a field from the BOM table 8 Search by using MPNs extracted on BOM import MPN_1 n Se ee m aa a aa A a This is almost identical to the dialog in the MPN search described in the BC PREP section except that there is no fault tolerant search MPN information must match exactly The Octopart Search searches through al
59. ency The currency for the total is EUR 51 Router Solutions BOM Connector User Manual 7 2 What are Price Groups Simply put Price Groups are the prices calculated from various sources for a given Production Quantity The Price Group ERP1 is the only one visible the first time you install BOM Connector This is Source ERP and Quantity 1 and thus the most basic type of pricing available You can add delete and change the display of price groups use the icon Currency Select Currency This lets you select the currency you want your Price Group to be displayed in BOM Connector already downloaded the currency cross rates from the European Central bank so all you need to do is click here and choose the currency OK Cancel ECB Update 01 09 2014 15 390 360 79 501 136 970 1 330 200 Add a quantity This is where you add your Production Quantities These are used to calculate the Scale Prices from the various sources Simply click here and you will see this dialog Enter the amount of boards you will produce and click OK Production Quantities Delete a quantity To delete a quantity e hoan Ed simply right click on it and choose DELETE USER USER i ae Once you have entered a few Production ae e Quantities i e 1 50 250 500 your screen ETT USER should look as to the left Currency The currency for the total is EUR We added a Price Group of 1 be
60. ers of BOM Connector normally need to create a multitude of different outputs The output required by the Quoting Dept for example is very different from that required by Production Different fields must be outputted with different headers different formats etc Outputs which are used internally do not required additional graphics such as company logos and address while outputs designed to be viewed by others particularly outside the company definitely do 32 Router Solutions BOM Connector User Manual For this reason we have implemented a wide reaching ability to create store and administer different templates This document is designed to show you how to do this 5 6 2 Template Description When you click on EXPORT in BOM Connector you immediately see a list of templates or none if you have yet to create any 5 6 3 Template Interface Preview window Click to edit Click to delete Template Template new Template 205251006 20 565 1002 20 565 1003 20 565 1006 20 65 1007 20 565 1025 20 65 1027 ROJ RI7S 281 ras RIGE 167 RISA List of Templates 20 500 1005 20 00 1100 2000 1112 205001113 20500 1130 20 420 1003 RISD 186 205201006 R24 209520 1007 R255271 205201003 AE 205201013 RVS 20520 1042 FATE u 205201062 4 205201063 R300309 20 520 1064 RIS x 20 520 1066 R102 106 A215 3 20520 1067 A174 175 R285 3 20 520 1063 RISING RIS 2 20 520 1063 FBS E 20 520 100 C3536 C1016 5 20520 1071 FRI
61. es for this Production Quantity You will also notice that several entries are displayed in red This indicates that either There is insufficient stock The distributor in question requires a minimum order in excess of the Production Quantity The best price is displayed in dark green with next best prices in a scale of green to yellow To select a price for example the price from Digi Key simply right click and choose ADD SCALE PRICE The price is added to the SCALE PRICE tab in the BOM Details Window OCTO EUR USD 1 0 0083 0 32 SKU 490 7219 1 HD 10 0 59621 0 783 Distributor Digi Key AO 0 43859 0 5764 MPN GAM32AR61E 475A 100 0 34859 0 4582 Manufacturer Murata 290 0 29261 0 35428 IPN 12299 F 500 o 0 26445 034734 Comment z If the price doesn t appear in the BOM it is because there is a better price and BC QUOTE s best price I l l function has taken it To de activate the other prices simply uncheck them E In this case the Octopart price is the best one for 1 50 250 and 500 So you shouldn t have to uncheck anything Notice that BC QUOTE s currency calculator has automatically calculated the Euro price for all US Dollar prices 57 Router Solutions BOM Connector User Manual Using the Octopart Interface for Individual MPNs It is often easier to search for prices using the Octopart interface for specific MPNs To do this right click on the MPN in the BOM Details Window BUM det
62. evice Type 3 Electrical Value EN Tolerance EN T A Record RefDes Scale Prices 1 Spee 1 0 C 22UF 16 X5R 20 1210 22U 20 20 Capacitor 22uF 10 10 BOM AML 20 520 1075 0 1 0 20 525 1026 1 1 0 R 40K2 1 0603 40 2K 1 1 Resistor 40 2K 5 5 GRM32RR61E475KA12L MURATA 1 20 520 1074 1 1 0 C 4 7UF 25X5R 101210 4 7U 10 10 Capacior 4 7uF 10 10 1 O Ba 02375 20 575 1041 1 0 L 32 TSSOP14 65MM IC z pues i gt ERP Update 30 12 2013 12 59 Searchmode MPN Query vl Y m SUPPLIER MPN INF MURATA GRAM32RR61E475KA12L 25V MURATA GRM32RR61C475KC01L MATERIAL TYP O DESCRIPTION 6 BAUGRUPPE ZEICHNUNG MATCH PRICE LAGER BEZEICHNUNG3 12299 S 4 7pF 1210 10 254 X5R E 4 74F 1210 WFOD4 7 0 39 951 00 Double clicking on that IPN or by using auto assign creates the link between the IPN and the CPN When you click back on the line in the BOM you will note that the MPN information from the ERP system has been entered in the MPN tab of the BOM Details window and a green check placed next to the matching part This lets you very easily perform AML control BOM details Record RetDes BOM AML GRM32RRETE475E4712L MURATA INT GAM S2AR R61 C4 SE COIL MURATA GRAM32ARE1E475KA12L MURATA Note For this to happen you must make sure the following is set under SETTINGS Settings a Edit User Attributes Common Settings Websearch Settings J Search CIS automatically after loadin
63. files directly from MSS Process Prep vPlan To do this a plug in called AssemblyHost DLL must be registered into your vPlan Add in Repository Once this is done you can read BOMs and CAD files from vPlan by choosing BOM import y gt Show file selection dialog Load BOM from ERP system MSS BOM N Normally your vPlan should be running on the server already If not or if this is the first time you are running this feature you will see the following dialog Save Password vPlan exe Path CA MentorGraphics WalorM551 12 0 Process Preparation ient Plan exe Start vPlan by application Make sure your login and password are correct and the proper path has been defined Hit Start vPlan by Application vPlan will start and BOM Connector will check to see if the AssemblyHost has been added If not you will receive a message Otherwise you will see a list of available assemblies Customer Description Date Created At the bottom of the dialog you will see the options load BOM load CAD Choose which you want by checking the box Then hit OK 69 Router Solutions BOM Connector User Manual 10 2 Writing to MSS Process Prep vPlan To write a BOM to vPlan simply hit a the icon LZ This will bring up the vPlan transfer dialog li ar AssemblyHost BOM A AssemblyHost Server P 127 0 0 1 CalcQuantity NoMapping comment NoMapping As
64. from your BOM MAT these are fields from your ERP system MPN INT These are the Manufacturer and MPN manufacturer part number fields from your ERP system MPN BOM These are the Manufacturer and MPN manufacturer part number fields from your BOM PRICING These are all the different pricing related fields from either ERP or DCI distributor catalog interface or OCTOPART or information manually entered in the SCALE PRICES menu REFDES Note this must be scrolled down to see These are the reference designators out of the BOM Note under FIELD SETTINGS you can specify in what format your reference designators should be exported To add a field into your output simply check the box next to the name You will see the contents of the field appear in the preview window and the name of the field shows up in the EXPORT COLUMNS box Export columns Default hint CPN Not assigned Description IPN Manufacturer BOM MPN BOM Important to note here is that if you check a field and then uncheck it you will get a message whether you want to remove it from the template as well You might for example want it in the template but only want to remove it from the output for this session When the warning message comes Do you want to remove the export column completly from the template The export column is assigned for following customers ASM 4004 Click YES to remove it permanently from the template NO if yo
65. g a CSY file Run SmartSearch automatically after loading a CSY file Y Switch to collapsed view after BOM import Y Add MPN Supplier if IPN is assigned 6 4 SmartSearch The SmartSeach is probably the search most often used by EMS companies and is thus a key function of BOM Connector With this function you can search your ERP system for the part number which best matches a given customer part The search is based on an analysis of the part s description which in turn can be a single field or multiple fields SmartSearch is far more than a combination of SQL statements like contains starts with etc these are done in Operator Search SmartSearch can find similarities in expressions such as 10K and 10 000 Ohm or language differences such as CAP and KON SmartSearch breaks down the entire description field into small parts called tri grams and compares these with each other utilizing its built in smarts Since the tri gram rules are programmable and expandable BOM Connector will get more intelligent with each use Naturally the better the data in the BOM the better the search will go SmartSearch works based on the declared description field or composite field in the BOM and the description field or fields in ERP which have been declared in the ETL These are marked with a red S in BOM and ERP By splitting into individual tri grams a field 100k 0603 1 0 will receive a high matc
66. h to an ERP part with R0603 1 0v H 100kO description The parts with the highest hit rate are displayed first with a hit rate factor You can sort your BOM based on the hit rate factor to see which parts matched up best 45 Router Solutions BOM Connector User Manual Hit rate factor E Description m Nar TOT BET oe 1 ell A e Da ha F o E E UA Price Material Link PartiD RefDes 70CPE 01295 Ha O C357_S04 OPT_PC357_504 Opto 284 100 70CPED1295 H10 PC357_ 285 100 70CPE01027 H11 LED YELLOW 0805 Led Click on the part in the BOM Window the ERP window below will show all parts from best to worst Your best match should be found in the first 10 entries E Fu Price E Meter ehink FF Pato HW ADe Y Description O Name 284 100 OCPEDIZSS H10 OPT_PC357_S04 285 100 7OCPEDIG2 H11 LED_YELLO W_0805 Led 286 100 MCPENIZIO H12 OPT_HCPLOS11_SO8 Opto tsolatoe 287 100 JOCPEDIZ9S H13 OPT_PC357_S04 Opto 288 100 MCPEONIORS 14 LED_GREEN_0905 LEO 289 100 IOCPENIZIO H15 OPT_HCFLOS11_508 Opto Isolator E one T 2 mw ame Pe A MAR TR DESCI DESC DESCI 100 PCISINI Opto coupler 504 100 PCISINT Optocouples SO4 40 SFHESOST opto 3750 MIN 109 SO4 40 VAMP VB357 Amyous CC op on card RoHS VAMP Sx VZ192A 40 FPS 21 Sales package OP T3Care 0083 2 Irvi 1 08GB AC 35 Power USB 2 0 Cable CA 31D mounting teets CR20 PL Taba N In this example you may want to best use the third entry the O
67. he following IPN MPN Hersteller H ndler Beschreibung Wahrung Preis 1 Menge 1 Preis 2 Menge 2 Preis 3 Menge 19683 LM82CIM04 NATIONAL IC LM82 SMT OSOP16125 3 0 3 6 3 C HETA Ep oO 19689 LM82CIMO4x NOPB NATIONAL IC LM82 SMT QSOP16125 3 0 3 6 3 C A57 19689 LMB2CIMOA NATIONAL IC LM82 SMT QSOP16125 3 0 3 64 3 C 157 19689 LM82CIMOA NOPB NATIONAL IC LM82 SMT QSOP16125 3 0 3 6 3 C 1 57 5 13623 LM82CIMO4 NOPB NATIONAL IC LM82 SMT QSOP16125 3 0 3 6 3 C 157 au 0 19689 LM82CIMO4X NOPB NSC ACE Pricefile 15 12 2011_MSEC xlsx LM 82 CIMGAX NOPB GEG NSC EUR Where MPN exact search is the result of the MPN found 1 1 in the ERP system MPN tolerant search is the result of the MPN found using a method that removes spaces hyphens and other characters that often are found in an MPN The new clean MPN is then compared with the ERP system in this case the NOP8 has been considered MPN alternates shows other IPNs in the ERP system where this MPN is also used AVL tolerant search shows the pricing from the Distributor Catalog Octopart Search not shown here is the result of a search in the online portal Octopart 64 Router Solutions BOM Connector User Manual 8 BC CHECK BC CHECK is used for the following tasks Check the BOM for inconsistencies such as quantity field which doesn t match the number of reference designators or BOM parts missing in the CAD file Compare two versions of a BOM Compare a
68. here which production quantities PQ you want to export pricing for v EJ 100 FF 1000 Simply select the PQ in question These will either be placed in columns or rows depending on your settings on the page above Create position number Increment by 10 Export only Parts without IPN ERP Material Create position number Many customers want a position number automatically inserted into the output Check here and specify the increment number to do this The second selection allows you to export only unmatched items from the BOM These are CPNs which you could not match to an IPN in your ERP This is normally used to send information back to component engineering 38 Router Solutions BOM Connector User Manual OUTPUT SORTING Here you can specify certain columns to be sorted Column 1 not sorted 7 Column 2 not sorted y Column 3 not sorted Choose the column name which you want sorted by from the drop down list 5 6 5 Saving and Deleting a Template To save your template simply click on SAVE TEMPLATE Save template This will save it under the name displayed in the NAME box Name test If you want to change the name before you save simply type in the name above To delete a template simply click on DELETE delete Alternatively you can simply choose a template name from the original template list and click on the oe trashcan icon 5 6 6 Editing a Template To e
69. ich you see here Choose your customer For the demo BOM choose Cyberbrains It is very important for the future that you choose the proper customer for each BOM Many steps that you perform such as mapping the BOM fields linking IPN to CPN etc will be saved to the customer name Once the BOM is loaded you will see it as displayed below 20 Router Solutions BOM Connector User Manual BOMField Name How should BC Import interpret it x Ye m DONOTIMPOR DO NOT IMPORT ABS DO NOTIMPORT DONOTIMPORT DONOTIMPORT gt DONOTIMPORT DONOTIMPORT DONOTIMPORT DONOTIMPORT DONC Bee O RefDes j CPN Quantity Description Package Device Type Electrical Value Tolerance Tolerance Sub There are no assignments for this BOM Y Gi What to do Y uae 20 50 1003 1 HC11 SO14N c 74 parecer eee Y u9 Un 20 50 1015 12 LM339AD lic imz au oson N EEPROM ATZACO2ANA 3 Ara e Y U50 u76 20 50 1112 2 PCA9557Pw c PCA Y un 20 50 1113 1 LV374 TSSOP20 65MM c 74LV Y a7 20 500 1130 1 FET IRF7313 TR Transistor_Array IRF7 Y R183186 20 5201003 ja R 430K 5 0603 430K 1 _ Resistor Ja30k 5 5 7 R264 20 52
70. ill call it TEST There are two types of export formats simple CSV and EXCEL More on CSV later Here we will create an Excel file Choose EXCEL with the FORMAT drop down Format EXCEL ww CSV Ll Under Excel settings you can choose an Excel template to use This may cause a bit of confusion so let s look at the difference between BOM Connector Export Templates and Excel Templates What is the difference between a template in BOM Connector and the Excel Template The BOM Connector Export template lets you specify the following e What type of file do want to export i e CSV or Excel e What do want in the output i e what fields 34 Router Solutions BOM Connector User Manual e What should those fields be named i e same name as in the BOM ERP or changed during the output e What sequence do want the fields to be in e The relations of certain elements i e do want my MPNs in different rows or different columns etc NOTE more on this later If the output is an Excel file you probably want to pre create an Excel worksheet with company logo and other information This is done via the Excel Template There is a DEFAULT Template It is called XTDEFAULT XLS It is located in your BOM Connector local directory C Users MYNAME AppData Local Router Solutions BOM Connector where MYNAME is your user name in Windows XTDEFAULT is a simple Excel file which looks like this E ss Router Solutions
71. ill immediately see this e 7 in the BOM preview In this case change the delimiter and hit to reload with the new delimiter 1111 Click here to read the file in as a fixed width columnized BOM 17 Router Solutions BOM Connector User Manual 5 1 1 Reading in a Fixed Width BOM If you choose a fixed width BOM you will normally see a BOM will no settings DO NOT IMPORT Story There are no assignments for this BOM What to do Autodetect Assignments Settings Customer File format PN9999 R12 ime ao geen 3 4 _ Jime Opti gt Ret CPN O Des m Do not generate a generic CPN 11 PNS999 RM 12 PNS999 R86 13 PN9999 R326 numbertormat Windows settings lalola This is a clear indication that the BOM is in fixed width format Hit the Icon You will get a message g Do you want to reload the file in Fixed Width format Hit YES 18 Router Solutions BOM Connector User Manual This will bring up the fixed width editor Be sure to Maximize the window Fine d width format bed is a fixed width format To set a agmi width simply click in the preview window below The marker CSV ents the beginning of a new col When finished simply click OK it thi this i is not a fixed width BOM pr click on csv File to re read as a CSV COMPONENTS 123 456 POS PART REFDES DESCRIPTION i PN9999 Ri2 SMD jumper 0603 ORO SOmW 2 PEHSSSS9 R16 SMD jumper 0603 ORO SOmW 3 PN9999
72. iption MPN BOM A IPN Manufacturer BOM MFG MPN BOM MPN BOM MPN BOM Pricing A i eee Format Options in the Template i e the relations of elements in the output As mentioned earlier there are many Element Settings that you can configure MPN OND MPNBOM Pricing RefDes Use many columns Both ERP INT and BOM manufacturer MPNs can be written out in multiple rows or multiple columns Similarly pricing for example for multiple production quantities PQ can be configured this way In the case of multiple rows which is the normal method for Manufacturer MPN data you can select LEAVE OTHERS EMPTY This will make the output easier to read 37 Router Solutions BOM Connector User Manual The ideal setting for the Reference Designators is USE REFDES FORMAT When you select this you will have certain options Format Short y Separator To charactar J Repeat prefix Format You can choose SHORT or LONG Short will truncate them while LONG will list all reference designators If you choose SHORT which is suggested then there are some rules for the truncation A separator character and a from to character must be given In the example above reference designators will be expressed as R1 R4 R9 R12 If you do not check REPEAT PREFIX then it will be R1 R4 R9 12 LONG form would be R1 R4 R9 R10 R11 R12 Production Quantity If you are using the Scale Pricing feature of BOM Connector specify
73. is a reference count i e a count of all the entities contained in REFDES for that particular CPN This allows you to perform a compare Getting the right quantity from a BOM can sometimes be tricky Often parts belonging to the same partnumber are scattered throughout the BOM with different quantity entries In order to properly get the right quantity information a strategy needs to be set In the Special Actions area on the left hand side of the screen you can see this icon Click here to set a quantity strategy The options are How do you want to use many quantity values for one cpn IMAX VALUE MIN_VALUE FIRST_VALUE LAST_VALUE SUM MAX VALUE Take the largest of the quantity numbers MIN VALUE Take the smallest of the quantity numbers FIRST VALUE Take the first one encountered LAST VALUE Take the last one encountered SUM Add up all quantities encountered to create a total sum In most BOMs either the MAX VALUE or the SUM are the correct options DESCRIPTION Whatever field you set as the Main Description will automatically be set as a SmartSearch field within BOM Connector more on this later If your BOM does not contain CPNs as is often the case then BOM Connector will create a Generic CPN based on CRC32 encoding There is more on this in the next chapter Important here is that this dummy CPN is based on the MAIN and ADDITIONAL CPN Description fields So the mor
74. just a guideline price Proper pricing is based on many different factors such as 1 Quantity which will be ordered Here the rule as always the more you buy the better the price Distributor stock Currency exchange rate Delivery times A e w Y Ability to pre arrange better pricing 6 Etc In short getting the best price normally means tapping in to several sources This blends in perfectly with BOM Connector s overall philosophy of taking information from diverse sources and presenting it in a clear easy to use way saving you the time consuming search efforts 7 1 Taking from ERP System As part of the ETL configuration process it was determined where pricing is to be found in your ERP system You can easily see if this worked by looking in to the ERP window for a PRICE field Note You might have to configure BC once to take this Under SETTINGS CIOMMON SETTINGS you should Use this held to obtain price informations Currency PRICE tl EUR tl see this setting Normally pricing is a straight 1 1 from ERP Sometimes ERP pricing is very Production Quantities detailed and includes scale prices For Visible Quantity Fite Price per unit Price for all this see the section 7 3 What are Scale Prices To use the ERP price in your quotes simply activate the ERP1 Price Group more on Price Groups in a moment E L E w L To do this click on the F icon And check the box next to ERP1 Curr
75. l MPNs in the BOM including those which belong to the linked IPNs Taking the example we used in the MPN search in the BC PREP section we see m IPN CPN RC E Quantity F Description E Device Type Electrical Value Record RefDes Scale Prices 3 Price A m IN a REE ICE E he pr 20 520 1075 1 1 0 C 22UF 16X5R 20 1210 22U 20 20 Capacitor 22uF El BOM AML 20 525 1026 1 1 0 R 40K2 1 0603 40 2K 1 1 Resistor 40 2k EAN RABIA ORA ba 12299 20 520 1074 1 1 0 C 47UF 25X5R 10 1210 4 7U 10 10 Capacitor 4 7uF SNE pa 02375 20 5751041 1 1 0 LV32 TSSOP14 65MM Ic AREA ABIE ASEO MUHATA pa 03997 20 575 1039 1 1 0 MDSOD1 SWITCH Switch A ee pa 04666 20520 1008 1 1 0 R 1K78 1 0603 1 78K 1 1 Resistor 1 78K pa 04692 20 575 1045 4 4 0 R 511K 1 0603 511K 5 5 Resistor 511K pa 04970 20 5001015 2 2 0 LM3394D Ic v Jpdate 30 12 2013 12 59 Searchmode MPN Query TY DE MPN int vl amp OE SUPPLIER MURATA GRAM32RARR61E475KA12L 25 x a MATERIAL TYP 8 DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 8 MURATA GRM32RAR61C475KC01L DESCRIPTION STOCK PRICE1 QTY1 PRICE2 QTY2 PRICES PKQTY QTY3 ROHS CUR SUPPLIER MPN DISTRIBUTOR ered Arrow Murata GAM32RR61E475K 1210 4 7 uF 25V xX5A 10 0 Brooks amp Mal Murata GAM32AR61E475K 1210 4 7 uF 25V X5R 10 4 Future Electr Murata GAM32AR61E475K 1210 4 7 uF 25V X5R 10 0 USD 1000 2000
76. l see RefDes A oF Import row and show assignments The Condition is a simple if then statement In this case we want to say if ASSEMBLED N then do not import Click on the edit icon Choose ASSEMBLED from the drop down list of field names and enter N as the value Click OK This indicates that any entry with Assembled N will not be imported Assembled N m E C Import row and show assignments RefDes 3 CPN Main Description E Quantity r ip pS RefDes CPN Quantity Doc F CPN z Stories are stepa to help you import a BOM correctly Currently no Story was E found by the import tool s A 1 U9 011 201 500 1015 2 LM3394D 2 161 20 5001100 1 EEPROM AT24C02AN 1 Se ea POSE aces 4 Q7 20 500 1130 1 FET IRF7313 TR Testing import 4043 bl z 5 R183 186 205201003 4 R 430K 5 0603 430K 1 If you want to import these entries but with different assignments click the box next to Import row and show assignments more on this later Note that the color viewer has highlighted both entries that correspond to the condition you just defined They are greyed out to indicate that they will not be imported If you want to interactively set certain parts to no import you can simply click on the check box next to the part 25 Router Solutions BOM Connector User Manual 5 4 Import
77. le is when the customer has put manufacturer info like MPN into the BOM data and this data is embedded into fields in the ERP which are not specifically MPN fields Run OPERATOR SEARCH The Conditions Window will appear 2 Operator Search Y Start H Auto Link je Hi BOM MSS2 csv v X pa IPN CPN RC E Quantitiy E Description EN Device Type EN Electrical Value D 0 20 4 0 20 4 0 20 49 Operator Search allows for a comparison of BOM fields and ERP material master The search is executed for each row in the BOM 0 20 oe expressions marked as active are linked by a logical AND Instead of a BOM field you can use a fixed search token 0 a Search Expressions a a MATERIAL equal IPN 0 20 4 0 20 5 0 20 5 0 20 4 1 20 4 0 20 0 20 0 20 4 ERP Update 30 12 2013 12 55 MATERIAL Run Search Cancel For example in our case we have an ERP field called DESC2 which contains vendor information In the BOM there is a PREF MAN field So we will create a condition which says show all parts where DESC2 in ERP is equal to PREF MAN in the BOM In the drop down material field choose DESC2 from the list The operator is equal Now hit the FIELD button and choose the Preferred Manuf from the list of BOM fields You can test the expression with the test expression button When finished click OK Once created you can run this and any other checked condition by clicking on the OPERATOR SEARCH button in the BOM tab 47 Ro
78. lients have access to the directory on the server you copied BOM Connector to To configure a client simply go to the BOM Connector server directory from the client itself and run BOMCON_SETUP EXE The installer will create a local instance under C Users MYNAME AppData Local Router Solutions BOM Connector where MYNAME is your user name in Windows Router Solutions BOM Connector User Manual BC It will also place a BOMCON icon on the desktop PA You can now start BOM Connector on this client When in BOM Connector you can verify that all Prograro Info pointers to the directories are correct by clicking on and then INFO amp UPDATE This brings up the following dialog BOM Connector Version 6 7 14 2006 2014 Router Solutions GmbH Registered License ASI 7 3 User http w toubersolutions de infottroubersolutions de Click here to go to the client directory in Explorer Client C Users kdecker 4ppD atar LocalAouter Solutions BOM Connector o NED Click here to go to the server directory in Explorer Spateminto Check for online update Note If you receive the message below when starting BOM Connector simply cut and Poranenia new tense just copy Gracie vou paste the string you received via email into Load license file the empty window area illustrated to the right by the cursor position You have not installed a software license No further action on licensing is currently required
79. ll store your customer PN internal PN settings Also if you already have some of these stored in your ERP system it will be imported into BOM Connector through the BC LINK ETL see chapter 3 BC Link page 10 Before we run the CIS Search let s take a closer look at the Customer Info Set CIS CIS information consists of CustomerName This is the name of your customer CustomerNumber This is the ID number of your customer often used in the ERP system for billing etc CPN s These are customer specific part numbers IPN s These are the related internal part numbers IPNs for specific CPNs Description The Description field for a CPN 41 Router Solutions BOM Connector User Manual CPN Memo Information added manually in BOM Connector for a specific CPN All the above data can come either directly from the ERP system as part of the BC LINK process or as a result of working with BOM Connector with the exception of the last two fields description and CPN memo This information can only come from working with BOM Connector You can view all CIS information via the CIS Tab BOM Data CIs ERP MSS PCB Pricing Data AML Distributor Cyberbrains Inc 4004 Show all records Back to BOM customer Customer Parts 22 Links 24 Y Customer ID Customer Name Pref CPN Source Link Source BA CPN IPN Description Memo 4004 Cyberbrains Inc C BOM Connector BOM Connector 20 500 1113 11792 L374 TSSOP20 65MM 354543455 4004 Cy
80. luantitio l Refl ist E 11 Use in SmartSearch 2 hy Hide in compressed view 11 Add new column 22 Insert column duplicate 11 Hide column 11 Use as calculation qty E AA Now lets move on to the Scale Prices 7 3 What are Scale Prices Scale prices are simply pricing based on quantities When you select a Price Group for example 50 BOM Connector will multiply the REFCOUNT by the Production Quantity in this case 50 to achieve the total number of components which need to be purchased In the sample BOM for example the part 20 520 1066 has a REFCOUNT of 44 which means the system will look for a Scale Price for 2200 pieces So for example if a distributor is offering three prices for a QTY 1 1000 b QTY 1001 2000 and c QTY 2001 and over then BOM Connector will take price c for this particular part 53 Router Solutions BOM Connector User Manual The Scale Prices for each part are visible in the BOM window under the BOM Details slider If you click on one of the parts with an ERP price visible you will see that one Scale Price has been added If you click on Scale Prices in the right hand window you will see BOM details es E 1 EUR S 1 EUR gt IPN CPN RC E Quantity E Des Price 1 gt 20 575 1039 1 1 0 MDS001 ERP1 EUR 1 0 25 0 25 ba 10048 20 575 1040 1 1 0 AHCTI4T 1 16 1 5 SKU 1 0 0009 0 0035 ba 04692 20 575 1045 4 4 0 R511K10 Distributor 1 0 0009 0 0027 ba 14328 20
81. n and unhidder at any time These are the BOM DETAILS window on the right hand side of the upper BOM WINDOW and the MPN INT Window at the right hand side of the ERP Window 12 Router Solutions BOM Connector User Manual The BOM DETAILS window should look like this BOM details MPN RefDes E UA IFN CPN 20 500 1 003 E AC 1 E Luarntitiy 1 RefList 1148 ES Description HC11 SO14N CPN Memo EA Device Type IC E Subclass 74 HC11 ER Assembled Fl BOM details Record Refllez Scale Prices 2 i AMIA bal Click on the arrow once with the window on and the window turns off Click on the reversed arrow and the window turns on again subclass EA Assembled Fite This window contains three tabs that you will use frequently E 7 RECORD MPN and SCALE PRICES di CO In the RECORD tab you can turn field on off simply by double clicking ss7Pw on the field name Double click on the first eight field names and your 374 N display will look like this 13 Wn om om i on BOM BC Test bcx TY DB BOM details E Device Type F Subclass E Assembled E Tolerance E Tolerance F Electrical Value S Ic 74_HC11 N E UA Ic LM3394D a IPN Ic AT24C02 CPN 20 500 1003 Ic PCA9557PW f AC 1 Ic 74LV374 N Quantitiy 1 Transistor_Array IRF7313 RefList 148 Resistor 5 5 430K FE Description HC11 SO14N Resistor 5 5 560 CPN Memo Resistor 5 5 1 27K E Device Type IC Resistor 5 5 1 78K F Subclas
82. ncnnncnononenonos 5 5 ROY Field S hasies O A east 5 6 EXPO BO to DL WAS TA ee a eaten a ae eae ee ete tees ae 56 2 Template DSS CMP UO POMAR RA O UU en A 534 Crealnga New Template aaa ai oumelinevenhs 565 Saving ana Deleting a Template nai a la ioe 366 Editada Templado OT USNO INS EXDOR FUNCION ur E ida Srt Expono Wilh Template se aeea aTa O a a aa S59 WIEWING Me Result a a atenttonatueadss 6 BEAR E N EN A 6 1 A a a a ecu ckem at tose 6 2 CIS Sealed dada 6 2 1 Running the CIS SearCh oocccccccconccnncccconncnnnoconnnnnnnononnnnnnnonnnnnnnnnnnnnnnnnnnonnnnnnnnnnnnnnnnnnnnonanes 6 3 MPN Sears 6 4 SS A siomentet a a 69 OS os 21 32 Router Solutions BOM Connector User Manual 6 6 RECap Ie Sear Medidas ais 48 6 7 USA dunt aa dheuetainaduwa cen AA E A 48 6 7 1 Creating User Attributes ccccccccncccccccccoococononnnnccnnnnnnnnnnnonononnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnanos 48 6 2 ASsigning USer ADUE S currada a ba 49 6 7 3 Saving Assignments and User Attributes ccccccccccccccccoooococnonanononnnnnnnnnnnnnnnonononnnnnnos 50 E BEQUOTE a ee se ie ee 51 7 1 Taking from ERP SyS EM xtc cceceeus trainee ei ete ees eae Sieh eens act eden uae 51 7 2 What are Price Groups ccccccseesccccceeeeeeeeceeseceeecaeseseeeesseueceessseuaeeeessaeageeeesssaaseeeessaaseeess 52 fa Whatare Scale Prices miii 53 7 4 Searching for Pricing for Various Sources cccccocoocnnccnnnnccconononncnnnnnononon
83. new BOM with the master BOM in ERP Compare a new BOM with the master BOM in MSS 8 1 Checking the BOM for inconsistencies This is done via the Check Icon When you hit this you will see a number of options Select one or more checks to perform Duplicate RetDes thems QuanttpRefCount difference RefDes missing from PCB data Cancel Select the options you wish to check and hit OK Duplicate RefDes Items will report instances where the same RefDes i e R10 is used more than once in the BOM Quantity RefCount difference will compare the Quantity field in the BOM provided you mapped correctly during the BC IN process with the calculated number of reference designator the RC field RefDes missing from PCB data will list all components in the BOM that are not in the CAD data see Chapter 9 BC CAD page 68 For example with the MSS CSV file loaded select the second option Quantity RefCount difference and hit OK You will see a new column inserted into the BOM IPN CPN E AC EJ Quantity RetList BOM Check E Description 1 0 9011 771 73 1 10 Urb Lart SSUP ZU bom 1 20 500 1130 1 1 0 GF FET IRF 313 TR 1 20 520 1003 4 4 0 A183 A184 A195 A186 R 430K 5 0603 430K 12 1 3 20 520 1006 1 1 0 R264 A 5604 1 0805 562 12 1 1 20 520 1007 3 4 0 A268 R269 A271 QuMismateh R1627 1 0603 1 27K 1 4 1 1 20 520 1008 1 1 0 A306 R1K78 1 0603 1 78K 1 27 1 1 1 IRI ini 10 Dooce DorWA A MEN Oo AR 4
84. one manually which is mistake prone and can easily take hours or even days of effort Preparing accurate quotations means constantly checking for current component pricing and delivery conditions A good BOM tool should help with all these tasks BOM Connector is exactly that tool One of the key features of BOM Connector is to help EMS providers speed up the process of preparing customer BOMs This process normally involves a Reading in the myriad formats and contents received into a standard framework b Finding the proper internal part numbers IPN to use for the various customer part numbers CPN in the BOM by searching through the company s ERP parts database c Exporting the results into a standard format BOM Connector can also assist EMS providers to create quotes much faster and more accurately by integrating the various pillars required for the quoting process a customer BOM b b internal ERP system c distributor catalog d online pricing portals such as Octopart and Digikey and last but not least e operator knowledge and experience The more BOM Connector is used the smarter the system becomes In addition both EMS and OEM providers benefit by using BOM Connector to directly link between their ERP system and various process engineering and shop floor management tools such as the MSS suite of tools from the Mentor Graphics Valor Division Here are the primary functions of BOM Connector 1
85. ptocoupler NT Simply double click and the ERP part number for this selection will be added to the BOM vA E Price Total Moateretink Z PaniD Quantity M Descrpsos T Nome 100 70CPEO1055 7 0 TRA_SOT23_BC847_45V_100MA_NPN Transistor NPN 100 POCPEN2120 1 0 FET_STN2NFI0_100V_24_0260 M MOSFET N chen 100 70CPE021 44 10 08G_S642718_S0 Digitol Isolator 100 70CPED1026 1 0 LED_RED_0805 Led 100 20CPEO1027 1 0 LED_YELLOW_0805 Led 100 MCPEOI230 5 0 OPT_HCPLOS11_508 Opto Isolator P eee Mm DA AMA AAA Aa P AMD 202 y ee TH DESCI DESC DESC3 100 PCISIN2T Opto coupler SOSW 100 PC3S7N3 Opto coupler SO4 PLASMA Optocoupler Sv SFHESOST opto 3750V MIN 100 04 In some cases you may get so many suggestions that it is hard to sort through them all In this case simply use the Filter Symbol Help Program Info BOM Data A ClS Search i Operator Search Y Filter Auto Link Compressed E A ua El Price Total Materialik Z PartiD E Quantitiy El Description El Name a 100 70CPE01055 7 0 TRA_SOT23_BC84 _45 _100MA_NPN Transistor NPN 100 70CPE02120 1 0 FET_STN2NF10_100V_24_0 260HM MOSFET N chan 100 70CPE02144 1 0 DIG_SI8421B_508 Digital Isolator 100 70CPEQ O Fulltext Query mo 100 70CPE0 gt 100 4 pa TM a eae Filter Criteria Search field TRI DESCI 504 DESCI 100 PC357N3 Opto coupler 504 100 PC357NT Optocoupler S04 40 SFH6906T opto 3750W MIN 100 504 20 MWv 8232 x Taso4 L
86. r The option is simply the other way around You choose the distributor and can set the override per customer 60 Router Solutions BOM Connector User Manual Customer gt Distributor Distributor Customer Distributor ABC Components w Priority PREFERRED Customer Customer Priority Cyberbrains Inc UNDESIRED hd 234 UNDESIRED ig Lowtech IG NO_OVERRIDE When you have finished making changes be sure to save the Save Settings information to the BOM Connector database with 7 4 3 3 Creating a Distributor Request To create a Distributor Request click on the button DISTRIBUTOR REQUEST This brings up the Distributor Request Dialog Here you see all your distributors listed You can sort this list easily by clicking ca on a column header Normally for a A y A a example you will want to see all your TEES es Suet PREFERRED distributors at the top of ae tet retest de re the screen Check the distributors you Famel Dear Staton forthe attached pane want to send an RFW to Once it is a Regnis filled you can start classifying your a eee il distributors into three categories oe PREFERRED for distributors you wish you handle first NORMAL for those with no preference and UNDESIRED for those you don t want to consider in your quoting To quickly select deselect all use the SELECT ALL box Note that all dist
87. r window you are applying it to the current BOM The assigned part number will be displayed green in the BOM window Price and quantity will be calculated automatically if this information exists Note If you use AUTOLINK this will happen automatically for all parts which are in the CIS If more than one exists the one with the PREFERRED flag will be taken When linking you will see different icons Here are the mappings gt Blue Link means This material has been linked and stored in the CIS Green Link means This material has been linked but not yet stored in the CIS by Red Link means This material has been created by the BOM Connector user via the Manual Material Link feature using the Persistent CIS Option and will be saved in CIS Grey Link means This material has been created by the BOM Connector user via the Manual Material Link using the Temporary Material ID Option and will not be saved in CIS 43 Router Solutions BOM Connector User Manual 6 3 MPN Search The concept of Manufacturer Part Number which we will call MPN from here on in is important to understand An MPN is the number which is used by the manufacturer of the part itself for example let us take a simple 100K resistor Within my company the part number IPN for this part is for example 123 456 But in my approved manufacturer list my company has determined that this part can be purchased from 3 sour
88. revious section 7 4 3 4 BC QUOTE will automatically send out the RFQ via email if this data exists Reading in a Completed a Distributor Request When distributors fill out the Distributor Request and return them you ll probably need to get this information back into BOM Connector oa A LY Ss From the DISTRIBUTOR Tab select LOAD DISTRIBUTOR REQUEST Browse to the file you want to read in select the name of the distributor from where it came Repeat for each returned request That s it Now check your BOM and you will see the Scale Prices for the parts updated where appropriate 62 Router Solutions BOM Connector User Manual TY DF BOM details fas Q 50 EUR S 50 EUR fea IPN CPN RC Quantity EE Description EN 14 Record MPN RefDes Scale Prices 3 Price 1 20 500 1003 1 1 0 HC11 SO14N IC DISTR EUR 1 20 500 1015 2 2 0 LM3394D IC 345345 0 58959 0 5695858 SKU 1 20 500 1100 1 1 0 EEPROM AT24C024N 10SC 2 7 IC Distributor C Plus Electronics 2 20 500 1112 2 2 0 PCA9557PW IC MPN A9557PW T 1 20 500 1113 1 1 0 1374 TSSOP20 65MM IC Manufacturer PHILIPS 1 20 500 1130 1 1 0 FET IRF 313 TR Transis IPN 03964 1 20 520 1003 4 4 0 R 430K 5 0603 430K 1 1 Resiste Comment A an can nan 1 45M M CANAN 1 ANNC 101 49 4 oe Masika MI nmern mM If you EDIT the Scale Price you will see the source is set to Distributor Request Edit manual price Source Distnbutor Request Production City Pric
89. ributor emails are visible You can enter these in the dialog described in the previous section BC QUOTE will automatically send out the RFQ via email if this data exists To make a Distributor Request just follow these simple steps 1 2 Note if you don t wish to use the BC QUOTE email function you can skip steps 2 4 and 5 Select which distributors you wish to email the request to Simply check the box next to the Distributor Name Select an Excel Template if you have one For more information see the section 5 3 4 Creating a New Template Give a primary email address which will be the recipient The entire list of selected distributors will be inserted as bcc on the email so that each recipient will not see to whom the email has been sent The primary email address could for example be your own Enter a subject and standard text for the email Click on the REQUEST Tab This is where you determine the contents of the request i e what parts to you want prices for and what additional information do you want from the distributor You also specify here whether you want the request split by authorizations i e only parts for which a distributor has a Authorization will show up on the request form Select an MPN source this can be either BOM ERP or BOTH Keep in mind that if you haven t assigned IPNs for all CPNs yet then you will only have MPN information from the BOM 61 Router Solutions BOM Connector U
90. s 74_HC11 Resistor 5 5 8 45K E Assembled N Resistor 5 5 9 09K E Tolerance Resistor 5 10K Pel Tolaranra Double click on the field name again to turn it on 13 Router Solutions BOM Connector User Manual In the MPN tab you can see which MPNs for definition of terms see Chapter 1 2 are assigned to the part currently selected in the BOM Window BOM BC Test bcx El e CPN 20 500 1003 20 500 1015 20 500 1100 20 500 1112 20 500 1113 20 500 1130 20 520 1003 20 520 1006 20 520 1007 E RC A Reflist 1 U48 2 U9 U1 1 U61 2 U50 U76 1 u75 107 4 A186 R183 R184 R185 1 R264 3 R269 R271 R268 EE Description HC11 SO14N LM3394D EEPROM 4T24C024N 1050 2 7 PCAS557 PW L 374 TSSOP20 65MM FET IRF7313 TR R 430K 5 0603 430K 1 1 R 5601 1 0805 562 1 1 R1K27 1 0603 1 27K 1 1 CPN Memo E Device Type Ic IC IC IC P Dg BOM details E Subclass E Assembled 74_HC11 N LM3394D AT24C02 PCA9557Pw 7ALV374 N IRF7313 El BOM AML SN 4HC11DR Tl The SCALE PRICES tab will be described in greater detail in Chapter 9 BC QUOTE Hi You can also use the icon Click here and a drop down displays Bi EA BOM Details Simply de check the window you want to turn off and check the window you _ MPN want to turn on It is easy EZ DCl Dctooart For example if you are not using the BC QUOTE module you will have no need for the lower DCI OCTOPART Window
91. scription3 Description4 DEVICE TYPE External Document GEOMETRYNAME InternalPartNumber LOADED ManufacturerP artNumber Package Source OK This lets you select various attributes to insert into the BOM If you do not wish to insert the attributes into the BOM simply leave all unchecked and hit OK The PCB is now visible in the PCB Tab Under CAD Items you can select Components Nets or Test points You will see a list of all items Simply double click to zoom into it Zoom 1 1 This will show the entire board Flip This lets you switch between TOP and BOTTOM views SMD Displays all SMD parts in yellow THT Shows all THT parts in grey Note If you right click on a part in the PCB view and shows SHOW IN BOM you will jump to the BOM view and that part will be displayed Alternatively from the BOM Window you can select a part right click and hit SHOW IN LAYOUT The view will switch to PCB and the component will be shown 68 Router Solutions BOM Connector User Manual 10 BC EXCHANGE Use BOM ERP to directly load BOMS from your ERP system into CAMCAD or vPlan For this to work Router Solutions must configure a so called EBX module Once configured you can read BOMs directly from your ERP system into either the BOM window or especially into the ERP MSS window depending on which one you have activated before running it 10 1 Reading From MSS Process Prep vPlan BOM Connector can read both BOMs and CAD
92. se MPNO01 you would not want the word use to be part of the MPN So you enter it here in the list and it will be eliminated during the read in process Separator between MPN and Manufacturer This is for combination fields It allows you to specify how the MPN and Manufacturer are kept apart This is usually a hyphen or a or a or simply a space Type in the separator here For spaces simply enter a space 24 Router Solutions BOM Connector User Manual Separator between two groups This is for combination fields that contain multiple MPN Manufacturer entries As in the above enter the separator that allows BOM Connector to know where one group ends and the next begins Sequence Choose either MPN Manufacturer or Manufacturer MPN depending on which comes first Skip entries The MPN Manufacturer combination fields often contains long text entries without a corresponding MPN In order to ensure that these don t mistakenly get added to the MPN list select this option 53 2 Setting Conditions As a last step here we see that there is a field called ASSEMBLED When this is set to N then the component is not inserted and therefore should not be imported In order to tell BOM Connector that it should not import certain components based on certain criteria we need to create a so called Condition To do this hit the icon When you do this you wil
93. se the same MPN as the part in question Naturally this requires the customer to provide this information This information is either provided in the BOM itself or through a separate AML List see Chapter 5 BC IN OUT page If this information is not available or is not reliable or if you do not have MPNs in your ERP system or if BC LINK has not interpreted them properly then you must proceed to the next search which we call SmartSearch If however you have this information then the MPN Search is a great way to identify the best available part in the ERP system To run MPN Search simply choose it from the search list You will see this dialog Select MPN source for search O Search by using a field from the BOM table we 8 Search by using MPNs extracted on BOM import MPN_1 1 C Use fault tolerant search You can either choose the MPN_1 field which is the standard MPN field or choose a different field in the BOM The fault tolerant search will give a wider search for example it will include MPNs that almost match or ones that have additional information attached to them such as package type When we run the MPN Search on the sample BOM we get for example a match for CPN 20 520 1074 with IPN 12299 This is because both reference the same MPN from Murata 44 Router Solutions BOM Connector User Manual BOM MS52 csw TY DF BOM details 52 IPN CPN RC Quantitiy EE Description E D
94. semblyHost Server Port 6001 comment 1 NoMapping CPN CPN Refresh Assemblies Cancel CpnMemo NoMapping IPN IPN Assembly oe oe Customer MentorGraphics y Quantity Quantity RefCount NoMapping DesignCenter Mentor y shape NoMapping User Attribute NoMapping Assembly IPN UserNote NoMapping value NoMapping Assembly Revision RefDes A Position NoMapping Export and create Assembly RefDes RefDes MAT s MPN INT R 23 03 2010 Manufacturer INT Manufacturer A89722 _ 30 03 2010 1 MPN INT NoMapping 30 03 2010 1 MPN BOM A 30 03 2010 Manufacturer BOM NoMapping 30 03 2010 MPN BOM MPN 30 03 2010 Pricing v 31 03 2010 31 03 2010 31 03 2010 31 03 2010 Y gt Export in existing Assembly Cancel You can either create a new assembly or export the file into an existing assembly It is important to properly do field mapping Fields should either be mapped to vPlan names or exported as custom fields 70 Router Solutions BOM Connector User Manual For questions please do not hesitate to contact Router Solutions technical support CONTACT ADDRESS Router Solutions GmbH Rheinstrasse 40 42 64283 Darmstadt Tel 06151 59907 0 Fax 06151 59907 15 Email tech routersolutions de 71
95. ser Manual 9 10 11 12 13 14 15 16 17 18 Now choose the parts from the list that you want in the RFQ You can choose these manually by selecting MANUAL and choosing the parts You can also simply specify WITHOUT PRICES and all parts that have no pricing information will be inserted into the Distributor Request If you check Only with MPN then only parts that have an MPN in the BOM or ERP or both depending on your settings in step 8 will be listed in the Distributor Request To quickly select deselect all use the SELECT ALL box Choose SPLIT REQUEST BY AUTORIZATION You can select which information in addition to Description and MPN information will be added to the RFQ by selecting Additional Columns You can select what information you want your distributors to fill out by checking the boxes in Request Columns for Distributors At the very least you should check Price Minimum Quantity in order to establish scale pricing Lead Time and Valid Through Specify what your Production Quantity is for the quote These are the ones you defined previously Now click EXCEL PREVIEW to see what you are about to generate A B C D E F G H J Router Solutions BOM Connector 3 Prices request Request from 02 09 2014 Distritos AAA Currency E LE default currency for the prices in this document as three letter code EUR USD 0 1 Yam BOM Connec
96. stomer but Es Looi here is an example Server Login Benutzername Demo User Kenner Datenbank E Server Demo Server Abbrechen h 4 2 The User Interface Particular emphasis has been made to keep BOM Connector easy to use We at Router Solutions have chosen the standard tabs approach in order to maximize screen utilization Each operation group is located on a specific tab The next page contains a complete overview of the BOM Connector user interface To begin a quick run through of the BOM Connector user interface hit PROJECT OPEN from the left hand ACTIONS Menu see Section 4 4 Browse to the main BOM Connector directory on the server and to the sub directory TESTFILES Choose BC DEMO BCX On the next page you will see a complete description of the screen 11 Router Solutions BOM Connector Search Options Imported BOM Action Icons BOM Data cls ERP MSS PCB icing Data AML Distributor gt O dE E G 4 6 pa E SmartSearch Start AutoLink ii y Click here for BOM UltraSearch User Manual BOM Details window with MPN details pricing Program Info BOM BC DEMO csv 234 4042 0 69 A AS FR Electrical Value Record RefDes Scale Prices 1 a 0 9 5 9 IPN CPN E AC RefList E Description N Device Type N Tolerance EN Tolerance T 20575102 4 CRI CR2 CR3 CRA ZENER DIODE BREAKD
97. ta AML Distibutor Progam Z CIS Search Stat E AutoLink E m TY DF ES J on Soala Piens fe IPN CPN f RC E Quantitiy EE Description E Device Type E Electrical Value E Tolerance E To a DN PANASONIC 1 20 500 1003 1 1 0 HC11 SO14N Ic 1 20 500 1015 2 2 0 LM3394D Ic 1 20 500 1100 1 1 0 EEPROM AT24C024N 10SC 2 7 IC 2 20 500 1112 2 2 0 PCA9557PW IC 1 20 500 1113 1 1 0 LV374 TSSOP20 65MM Ic 1 20 500 1130 1 1 0 FET IRF7313 TR Transistor_Array 1 20 520 1003 4 4 0 R 430K 5 0603 430K 1 1 Resistor 430K 5 5 3 20 520 1006 1 1 0 R 560R 1 0805 562 1 1 Resistor 560 5 5 1 20 520 1007 3 4 0 A1K27 1 0603 1 27K 1 1 Resistor 1 27K 5 5 1 20 520 1008 1 1 0 R1K781 0603 1 78K 1 1 Resistor 1 78K 5 5 1 20 520 1018 1 1 0 R 8K45 1 0603 8 45K 1 1 Resistor 8 45K 5 5 0 20 520 1042 1 1 0 R 9K09 1 0603 9 09K 1 1 Resistor 9 09K 5 5 0 20 520 1062 3 3 0 A10K 1 0603 10K 1 7 1 Resistor 10K 5 5 0 205201063 4 4 0 R 10K21 0603 10 2K 1 1 Resistor 10 2K 5 5 0 20 520 1064 1 1 0 R 1K 50603 1K 5 5 Resistor 1K 5 5 0 20 520 1066 44 44 0 R10K 5 0603 10K 5 5 Resistor 10K 5 5 0 20 520 1067 4 4 0 R 100K 5 0603 100K 5 5 Resistor 100K 5 5 To quickly find parts use UltraSearch as described in Chapter 4 For example type in 470nf ezon v 2 69 en IPN CPN f RC Quantitiy ES Description E Device Type E Electrical Value E Tolerance E Tolera 0 20 520 1070 12 12 0 C470NF 16 X5R 10 0603 470N 10 10 Capacitor 470nF 10 10 0 20 565 1027
98. te condition PN contains m 130 Create condition PN contains nicht EA lian Doing this copies the CPN but creates a new story CPN Position ai CPN E DO NOT IMPORT RefDes y CPN Main Description 7 Pos PN Index REF DESC tl There is a collision between the CPN and the CPN Description s How should this be solved Create new condition row X933 123 J ds area vaout Add another CPN Additional Description Do nothing 234 4042 vil KKK aaa ala a aa a a a aa E 0000000000050 amp WwW why File format rot leet el al CA This is because you now have a collision between CPN and description For the same CPN you have several different descriptions This is because the DESC field is a multi use field Depending on certain criterial this field can be either a description or a Manufacturer MPN field To eliminate this problem you need to create a Condition as we did earlier Except that this time we will not set the parts to No Import but rather we will set a condition that says when REFDES is blank then read in the field as MPN MANUFACTURER Split Click on ha 29 Router Solutions BOM Connector User Manual Activate the row by clicking in the box Now set your field mapping for the condition lines to
99. the customer part This section will look at the different searches in detail 6 1 UltraSearch To turn on off the Ultra Search a Google like Search Window click the Filter icon Use UltraSearch to quickly find parts either in the BOM or the ERP system Here you can type in any search string just as 100K 0805 1 in any sequence You can also use placeholders For example OR followed by nothing or by one or more characters acts as a wildcard 2 followed by a single character followed by a single number A space acts as a typical AND command If you actually want to search for a space then use an underscore This will combine the two strings To make an exact search use quotation marks For example R1 will only search for R1 and will not show R11 R12 etc If you simply type in R1 without quotes then everything starting with R1 will be displayed You can also turn on UltraSearch with CTRL F and turn it off with SHIFT CTRL F The search engine looks through all fields and displays them If you click in the BOM window then it will search through BOM and ERP simultaneously See chapter 5 BC IN OUT page 17 for a concrete example 6 2 CIS Search Re usability is a key concept in BOM Connector What you do today you should not have to do tomorrow This is the idea behind the CIS Search As mentioned earlier CIS is short for Customer Info Set This is where you wi
100. this CPN ee l l m eliminating comment lines and repeating headers in the BOM Autofill Editor The concept of autofill is very important for working with complex BOMs We mie will get into this more in a moment In short this is for empty fields which are placeholders for other information usually in rows above it 27 Router Solutions BOM Connector User Manual 5 4 1 AutoFill Example and Resolving with a Condition If you click on the Autofill icon it will bring up the Autofill dialog lt i lt 3 i lt lt glolojololololojojoloja Simply select the field you want to automatically fill empty lines For example look at this BOM CPN Position CPN DO NOT IMPORT CPN Main Description os N index REF DES MA a 0 Dokuments 2 11 1X933 123 J 05 Schematic 3 12 X8484 455 V 05 Assembly Plan MA E 20 MA 20 Assembly 4 40 x000 4550 05 PCB 33333 5 110 Q999 123 06 coor CAPACITOR 100u 0050 MA E mo PANASONIC EEUFCWI W E no PANASONIC EEUFC1J1 MA E no CHEMI CON EGXE500E A E no VISHAY 2000000 MA E 10 VISHAY MAL2048 8101 DY E no VISHAY 148RUS 2222 MA E 10 VISHAY MAL2148 8101 6 120 coo2 CAPACITOR SMD 1210 DW E 120 KEMET C1210C105K5R DW E 120 SAMSUNG
101. tor ID y Description Md MPN y nu urer gt Quantity gt Price gt Minimum Quantity gt Lead Time Days id unti 3 9C1716161FCBBCDS8EC60B833E22ADAD5 HC11 S01 SN74HC11DR TI 50 4 C245C067A1B95D91232C329FEB8DDF1F R 66K5 1 0603 66 5K 1 1 ERJ3EKF6652V PANASONIC 200 5 8025A7F1BE1A92E3D00283DE7FE443D0 C 470NF 25 X7R 10 805 470N 10 10 GRM21BR71E474KC01L MURATA 50 6 351681F67D37F13FBA07D76772A618F8 R 4K7 5 0603 4 7K 5 5 C1608X7R1H472 TDK 150 7 D5633AF520AD84DB44D7A1379EA91AC2 C 4 7UF 10 X5R 10 805 4 7U 10 10 C2012X5R1A475K TDK 50 8 5368C8721CA4C8C32D0A1A392E697F6A C 1UF 10 X5R 10 0603 1U 10 10 C1608X5R1A105KT000E TDK 100 9 68E140B6D03741FB5009CD2871C9EE4F C 10NF 50 X7R 5 0603 10N 5 5 006035C103JAT2A AVX 200 0 B047B68FA3907B3F15D51147EF635989 LM4040B LIM4040BIM3X 2 5 NATIONAL 50 1 D1C5ED85A5012524495B1B1DDFC94AE5 CONN1X2BERG 146145 1 AMP 100 2 2 A If you are going to handle the emailing on your own simply SAVE the Excel file and email it If you are going to use BC QUOTE s email feature close the file and select SEND E MAIL Note do not just hit OK This registers your settings and closes the window but does NOT create a Distributor Request You will see an email created with text and subject as you entered earlier Click SEND Congratulations You ve just created and emailed an RFQ using BC QUOTE Note that all distributor emails are visible You can enter these in the dialog described in the p
102. u just want to remove it for this session This allows you to specify that a specific column should be in the export but without any data Many customers want to export empty columns to be filled in later In such a case you will see not assigned displayed next to the field name as in the example above If you also wish to remove the field from the list afterwards simply select it in the list above right click and choose DELETE COLUMN FROM TEMPLATE Export columns Default hint Not assi Delete column from template Insert column So now let us change the output names 36 Router Solutions BOM Connector User Manual If you want a field exported to a different name simply choose the field and right click on it Now choose EDIF You will see the following window romar Snort vw i Separator To charactar l _ Repeat prl column name Manufacturer BOM Default rro The column is assigned for these customers Export columns Default ASM CPN ai Description IPN Manufacturer BOM MPN BOM Type in the name of the field as you wish it to appear in the export for example above type in MFG and click OK You will now see the field name as MFG To the left you will see the old name vs new name LJ PRICE Ls Repeat prefix TYP J WBZ _ ZEICHNUNG ERR COMES MPN INT A Export columns hint _ Manufacturer INT CPN Not assigned _ MPN INT Descr
103. uter Solutions BOM Connector User Manual Filter lets you easily narrow the resulting list which depending on your criteria can be very long think of contains 10uF This can result in hundreds of parts listed Using the filter and reduce this substantially With the Compact button you can switch the displayed BOM into non flattened mode which means that each part number will be listed individually followed by a single line containing all the reference designators Note the automatic price and quantity calculation only works in compact mode 6 6 Recap the Search Methods To recap in order to most efficiently search for matches you should use the following sequence 1 CIS Search If you already matched customer part numbers and want to use these hit the CIS search button or Autolink This is the re usability feature described earlier 2 MPN Search Normally the safest way to match is when a customer has given MPNs in the BOM or provided you with an AML list approved manufacturer list often known as AVL 3 SmartSearch If nothing has been stored in the CIS for a given customer part number the interesting work begins Use the SmartSearch to find which ERP part best matches the customer part 4 Operator Search Here you can use other fields in the BOM and ERP system to interactively perform standard SQL type queries 6 7 User Attributes User Attributes let you add information to a given customer part number The id

User Manual Status: Q2, 2015 Current Version 6.10

Contents

Download Pdf Manuals

Related Search

Related Contents