Home

User Manual Status: Q3, 2014 Current Version 6.X

1. INTERNAL if it was created by you using the CREATE MATERIAL feature in BOM Connector more on this later These are User Attributes BOM Attribute that you assigned while working with BOM Connector see below This is the customer part number as described above This is your internal part number linked to the CPN as described above This is the description field which was in the BOM you imported at the time you saved the data to the CIS 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 ERP system the source CPN Source remains set to ERP To Delete a CIS entry simply select it do a right click and choose DELETE CUSTOMER MATERIAL Cyberbrains Ine 4004 Customer Parts 22 Links 24 Show all Customer ID 4004 4004 4004 4004 4004 4004 4004 if Customer Hame Cyberbraing Ine Cyberbrains Ine Cyberbrains Ine Cybe
2. User Manual 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 It will also place a BOMCON icon on the desktop BOM Connector You can now start BOM Connector on this client When in BOM Connector you can verify that all Program Into pointers to the directories are correct by clicking on and then INFOS UPDATE This brings up the following dialog BOM Connector Version 6 7 14 2006 2014 Router Solutions GmbH Registered License ASI 3 User http w toubersolutions de infottroubersolutions de Click here to go to the client directory in Explorer Client C Users kdecker 4ppD latas LocalAouter Solutions B 01m Cormector m s Click here to go to the server directory in Explorer Speteminto Check for online update Note You have not installed a software license If you receive the message below when starting BOM Connector simply cut and le ae o a e home tle pasis yaar paste the string you received via email Load license fle into the empty window area illustrated to the right by the cursor position No further action on licensing is currently required 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
3. 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 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 orde
4. i e what fields 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 19 Router Solutions BOM Connector User Manual 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 I Router Solutions BOM Connector Quote from 12 17 2013 CUSTOMER o PRICETOTAL sel hc ad lc lel fm asl Ml aid Y gt al 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 exampl
5. templates It is important to understand this concept fully 5 2 1 What is a Template Users 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 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 2 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 17 Router Solutions BOM Connector User Manual 5 2 3 Template Interface Click to edit Click to delete Preview window Template Template BOW Export E N List of Templates Click to add new Template 295451002 AREA 205510 AS 20 545 1006 AGE 167 RIH 05451007 Aa HARS cre 045107 Em SA DE AP DT DHE The first time you run this your list of templates will be empty 5 2 4 Creating a New Template Let us create a new Template Click ADD NEW TEMPLATE 18 Router Solutions BOM Connector User Manual Preview The export templ
6. 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 10 You can select which information in addition to Description and MPN information will be added to the RFQ by selecting Additional Columns 11 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 12 Specify what your Production Quantity is for the quote These are the ones you defined previously 13 Now click EXCEL PREVIEW to see what you are about to le HA Router Solutions BOM Connector Prices Fequest Request from 07 09 2014 Disrbutor HA Curang QE deal currency dos le presion hee decanen aa three letter code EURUSD 0 i inpia a Manutacturor fa OA EAN Pa E SSE SEZADADE pai Soun SHMHCTOR m IE CAPCIS TA IASS RPERSFEDADOF IF R EERS 1 0607 66 Gee tte 1 ERERFGGS2Y PAHASOMG AA PIBE LASSE 300E E00 CAT NE 250710 BOS 47001058100 Beni MURATA 50 A hie tera A o KenL CSG IAT _ 150 SAF SOUADEADBACDTATITIEAD AC CA TUF 10 XER 10 805 4 7110 4 40 CAREAT 50 ERIN DICMCCIIONA IASUREGITFES CUE 100657 10 060 104109 10 CORR TATE TOE TOK 100 ERE OEA POCO STC SCEA CONF S0 ATR 5 0607 PH SSDT DOBLES TELLA TRA ANN 200 BM TB64FA3S078371505117EF635989
7. Cells Leave others empty z The ideal setting for the Reference Designators is USE REFDES FORMAT When you select this you will have certain options 22 Router Solutions BOM Connector User Manual Format Shot Separator To charactar Y 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 here which production quantities PQ you want to export pricing for YEN 100 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 A 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 infor
8. H3 OPT_PC357_504 Opto 284 100 70CPE01295 H10 OPT_PC357_S04 Opto 205 100 OCPEOO2 H11 LED ELLO 0005 Led 29 Router Solutions BOM Connector User Manual 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 m El Eu El Bice Me erobHink F PardHD Al Redes Descnpioa C Mame 209 w merens H9 OPT_PCIS _SO4 Opa 204 100 ILPENIA HTO OFT Plas S04 pta 85 100 TUCPEDI iT Hij LED YELLCOA 0806 Lod 06 100 OCPEOIZI Hz OFT _HOCPLGS11_ S09 Opa olyg 207 100 ICPENIZSS H13 DPT_PC357_S04 Opa 00 100 TICPEDIOOS Hid LED GREEN 0S0 LEO 209 100 ILPEDI 30 H15 DFT_HCPLE511_S508 pie holalor AO PRES AE at pia a CBS A TR DESC DES DESG 100 POSNET Opio coupler 504W 100 PC357N3 Opit coupler 504 100 PEINT Optocoupler SCM 40 SFHSSOST opto 3750 MIN 100 504 40 VAMP VETS Arrbus OC opica card RoHS VAMP tne WZI82A 40 PPS 21 Sales package CP TICs ane eE 4 35 Power USS 20 Cable C4 31 D mounting teats CA20 PL Tahe In this example you may want to best use the third entry the Optocoupler NT Simply double click and the ERP part number for this selection will be added to the BOM E E Y El Bice Tom Maie sHink Fl Pami 21 Quantity NM Dese pion D Hama T FOCPED OSS 70 Tha SOT BOHM _45V_100Ma_NPH Tranmestee HPH 100 MEPE02120 10 FET_STHEMFI0_100w_24 _0 260HM MOSFET MN chen 16 TOCPER 44 1 0 Da Siban S03 gial coleta 100 FOICPED
9. LAG A EE NATIONAL 50 DICREDBSALO AARE BODE CARS COMMUGBERG 146148 1 AMP 100 3601072571 DE FEE TMF ESF CDF E 20006 1020 P 74140 06 27 ee ae VUSPZTDMACI SANTO 50 PR ROSS ACCE PAE ERA IAE AA EPA AMALIA LA A Gaaner En 14 If you are going to handle the sinaing on your own simply SAVE the Excel file and email it 15 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 16 You will see an email created with text and subject as you entered earlier Click SEND 17 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 previous section BC QUOTE will automatically send out the RFQ via email if this data exists 7 4 3 4 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 M 1 From the DISTRIBUTOR Tab select LOAD DISTRIBUTOR REQUEST 2 Browse to the file you want to read in 3 Select the name of the distributor from where it came 4 Repeat for each returned request 5 That s it 6 Nowcheck your BOM and you will see the Scale Prices for the parts updated where appropriate BOM details fas Q 50 EUR S 50 EUR fe IPN CPN RC Quant
10. 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 _ _ _ _ ____ _ Q ___ Delete Customer Material Copy KIS data Preferred Copy 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 6 6 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 SAVE from the actions menu Save Data 7 Update User Attributes of linked customer parts in CIS 7 save customer parts in CIS that are currently not linked to an ERP Material a e 33 Router Solutions BOM Connector User Manual 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 34 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 you
11. alias forms Priority e mail a UNDESIRED ACE PREFERRED NORMAL Advonics Group 43 Router Solutions BOM Connector User Manual 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 FourStarElectronics will now be displayed as an Alias of 4 Star Electronics Distributor Priority e mail e Alias UNDESIRED by ACE PREFERRED y 45E Advonics Group NORMAL E FourStarHectronics Priority overrides for customers In the right hand side of the screen you see a z section 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 Frioritiy overrides for customers Distributor Priority e Alias Cutan gt Distr Distributor gt as 4 Star Electronics UNDES
12. in the BOM it is because there is a better price and BC QUOTE s best l l w price 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 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 BOM details Record RelDes Scale Prices 1 BOM 7 AML A CREWOSUSSBURFRES 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 MPH INFE VISHAY CACWOSUSS6U0R PRES DALE CACWOSU5560R FREES SAMSUNG ACM APART oan Edit AML data Octopart Search all MPNs Octopart Search selected MPN ri m hal Pp 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 41 Router Solutions BOM Connector User Manual If you click into the Octopart Window area and r
13. it is the first time you are launching it you won t need to click START it will launch automatically BOM Data Conditions O Duickprice i Start The first dialog asks to identify the MPN field in the BOM MPN search Quickprice mS Select MPN column MPN_SUPPLIER Use fault tolerant search Ok Cancel 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 mE Click on a part in the BOM and you will see the results for that part in the QuickPrice window nw w Ww NE 47 Router Solutions BOM Connector User Manual For example if we choose the result with 6 we can see the following E AVL tolerant search 1 LM82CIMOQ4X NOPB ACE Pricefile 15 12 2011_MSEC xlsx LM 82 CIMGAX NOPB GEG NSC IPN MPN Hersteller Handler Beschreibung Wahrung Preis 1 Menge 1 Preis 2 Menge 2 Preis 3 Menge El MPN exact search 1 19689 LM82CIMOA lt NATIONAL IC LM82 SMT GSOP16125 3 0 3 6 3 C i 157 LSS EJ o 0 E MPN tolerant search 1 19689 LM82CIMO4X NOPB NATIONAL IC LM82 SMT GSOP16125 3 0 3 6 3 C i ADE E oO 0 E MPN alternatives 3 19689 LM82CIMOA NATIONAL IC LM82 SMT GSOP16125 3 0 3 6 3 C 0 a 19689 LM82CIMO4 NOPB NATIONAL IC LM82 SMT GSOP16125 3 0 3 6 3 C 0 0 19689 LmM82CIM0OAXNOPB NATIONAL IC LM82 SMT QSOP16125 3 0 3 6 3 C 0
14. minute pricing The Octopart interface is developed using the Octopart API toolkit To search for prices on Octopart it Octopart search Sy Start you can choose This brings up the following dialog Select MPM source for search O Search by using a field from the BOM table koa Search by using MPNs extracted on BOM import MPN_7 1 ma M ee m a a ea a a Pee ed 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 all MPNs in the BOM including those which belong to the linked IPNs 39 Router Solutions BOM Connector Taking the example we used in the MPN search in the BC PREP section we see User Manual fa IPN CPN El RC El Quantity EE Description FR Device Type Electrical Value Record RefDes Scale Prices 3 Price oat 7 S E E EN l Bd E 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 40K21 0603 40 2K 13 1 Resistor 40 2K MU GRM32ARETES 5KAT2L MUERTA PA 12239 20 5201074 1 1 0 C 4 7UF 25X5R 10 1210 4 7U 10 10 Capacitor 47uF e ees pa 02375 20 575 1041 1 1 0 LV32TSSOP14 65MM Ic i GRM32RR61C475KCOIL MURATA va 03997 20 575 1039 1 1 0 MDSOO1 SWITCH Switch GRM32AR61E475KAT2L MURATA a 20 5201008 1 1 0 R 1K78 1 0603 1 78K 1 1 Resistor 1 78K pa 04692 20 575 1045
15. oO 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 48 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 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 When you hit this you will see a number of options This is done via the Check Icon Select one or more checks to perform Duplicate RetDes items QuanttpRefCount difference RefDlez 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
16. 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 9 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 which 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 can assign BOM fields to field types with BOM Connector will understand 14 Router Solutions BOM Connector User Manual E Import BOM MSS_TESTZc5w Ah i sml Y Colum Reference CPN RefDes Tolerance Device Type Electrical Value Manufacturer MPN Tolerance Subclass CPN CPN 20 500 1003 U48 Ic Tl SN74HC1IDR 74_HC11 REFDES REFDES 20 500 1015 U3 11 Ic ST MICR LM3394DT LM3394D TOLERANCE OTHER DATA 20 500 1100 U61 Ic ATMEL AT24C024N10S12 7 AT24C002 DEVICE TYPE OTHER DATA 20 500 1
17. 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 Queckiy pet accurate Up lo dale component pies and jvailability and enter them into your quote Load and view CAD data and compare with BOM Highhy intelligent search algorithms to find the right part from the ERP System Plan scrub and enhance the BOM Check the contents of a 604 for changes errors or other missing information Cros check between revisions Read any external BOM wach as Excel CSV HTML of free feat Export BOWL in any dermed format Automdied Downidsd of OAs trom your ERP Syiterm and upload of the Golden BOM info ERP Direct link to dterent data surte such a ERP techincal Component daliga Valor M55 and others 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 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 Connect
18. this column as is with the same name MEN Assigning this means do not import this field MANUFACTURER This is a special field type with notes that will be stored in the CIS Manufacturer Part Number Manufacturer Name QUANTITY this is the field claimed containing the quantity BOM Connector will add a field RC which 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 PRICE price in the BOM If the names in the BOM are similar these will be assigned automatically Otherwise you will need to use the drop down menu for this When you click on a field in the list that field will be displayed in the preview area to the right Note to use the preview area effectively it might be necessary to expand its size Drag the window by clicking and holding the mouse on the lower right corner In addition you can enter a name for the field directly into the box by clicking on it and then typing TEST The mapping of BOM field names to BOM Connector field types as well as these user defined field names will all be stored per customer and available later With the ADD NEW BOM DATA COLUMN button you can create a new composite field This will combine several fields into one The FIRST ROW CONTAINS FIELD NAMES box should be checked if the field names are in the proper row 15 Router Solutions BOM Connector User Manual DELETE RECOR
19. 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 52 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 RefList BOM Check EE Description 1 2d 9011 7173 1 1 0 Ub AE SSUPZU boMM 1 20 500 1130 1 1 0 07 FET IRF 313 TR 1 20 520 1003 4 4 0 A183 A184 A185 A186 R 430K 5 0603 430K 1 27 1 3 20 520 1 006 1 1 0 R264 A S60R 1 0805 562 1 4 1 1 20 520 1 007 3 4 0 A268 R269 R271 QtyMismatch R1K27 1 0603 1 27K 1 4 1 1 20 520 1008 1 1 0 A306 R 16781 0603 1 78K 1 27 1 1 1 IAI ini 10 Duc DOr AR AACN Oo ARR dee d7 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 49 Router Solutions BOM Connector User Manual Aun BOM Cormpare Then choose from the Action Menu 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
20. window you can use the arrow to the left of it BOM details Record Refllez Scale Prices 2 PP Li ANA 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 11 Router Solutions BOM Connector User Manual Hi JE You can also use the icon Click here and a drop down displays a r BOM Details Simply de check the window you want to turn off and check the window you e MPH want to turn on It is easy DCI Octopart 4 2 1 Ultra Search 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 tK followed by nothing or by one or more characters acts as a wildcard followed by a single character FP 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 wi
21. 00 Fi 0002 1 C3 93 018 803 0000 8 0001 1 C15 5 93 016 42470000 3 0001 1 C17 5 93 016 40270000 11 0002 1 CH 5 93 016 40270000 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 93 010 1 78 0000 15 0002 1 C40 5 93 010 1 78 0000 15 0003 1 C401 93 010 1 78 0000 15 0004 1 C403 93 010 178 0000 15 0005 1 Xx 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 ERPYMS5 PLE Pricing AML otto CEZ Save CSW fle Compare BOM Collapse MS55 mport Clicking on this will bring up the MSS Dialog IPN a CPN Description Design Center Group 4 071 176_ELA5000_V0 4A Mentor Mentor Mentor Mentor Mentor Mentor Mentor Mentor Mentor Mentor Mentor Mentor Y load CAD vPlan settings M A a Pa arn aa Ad Am Last refreshed at 22 08 2014 12 49 12 Conc Date Crea 25 02 2014 31 03 201 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201C 31 03 201 v gt refresh Here you see a list of all y
22. 02 A 4709F 1812 10 1004 X7R C 470n 1812 NF470 0 0 07427 C1206 1206C 470NF 1206 50v Z5U C 470n 1206 NF470 0 0 07584 S70NF 0612 25 x7R C 470n 0612 NF470 0 0 07962 C1206 1206C S70nF 1206 10 50V X7A C 470n 1206 NF470 0 01 1980 00 16 Router Solutions BOM Connector User Manual 5 1 Key field 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 This is normally the description information This is then stored in the CIS along with the internal part number you assigned to it and can be re used in subsequent BOMS This Key Field consists of Description or multiple other fields To set the Key Field just click on the Box with the Key symbol All fields containing the Key symbol will be encoded together to create a virtual CRC32 part number It is very important that this be done carefully Misassigning 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 5 2 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
23. 1 1 4004 Cyberbrains Inc C BOM Connector BOM Connector 20 520 1007 14328 Rik2 1 0603 1 27K4 1 1 4004 Cyberbrains Inc C BOM Connector BOM Connector 20 520 1008 04666 R 1K78 1 0603 1 78K 1 7 1 4004 Cyberbrains Inc C BOM Conmector BOM Connector 20 520 1018 11070 R 8K45 1 0603 8 45K 1 7 1 4004 Cyberbrains Inc C BOM Connector 20 575 1036 20 575 1036 M x1614EUA In the example above there are number 4004 several entries for your customer CYBERBRAINS which has the ID 25 Router Solutions BOM Connector User Manual Here is a description of the fields CustomerlD CustomerName Pref CPNSource LinkSource BA CPN IPN Description Memo This is the customer number as described above This is the customer name as described above 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 This specifies where the CPN came from i e how did it enter the CIS This will either be ERP INTERN if it was imported via BC LINK or BOM Connector if it was part of a BOM that was imported 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
24. 112 US50 76 Ic PHILIPS AS557PW T PCA9557 ELECTRICAL VALUE OTHER DATA 20 500 1113 U75 IC Tl SN74LV374APWR 7414374 MANUFACTURER OTHER DATA 20 500 1130 07 Transistor_Anay INTL RCTFR F7313 TR IRF7313 MPN OTHER DATA 20 520 1003 R183 186 5 Resistor 430K PANASONIC ERJ3GEYJ434Y TOLERANCE OTHER DATA 20 520 1006 R264 5 Resistor 562 PANASONIC ERJSEKF5S620 SUBCLASS OTHER DATA 20 520 1007 R268 271 5 Resistor 1 27 PANASONIC ERJSEKFI271 QUANTITY QUANTITY 20 520 1008 R306 5 Resistor 1 78k PANASONIC ERJSEKFI781V 5 DESCRIPTION DESCRIPTION 20 520 1018 R326 5 Resistor 8 45k PANASONIC ERJSEKFS451V 5 20 520 1042 R318 5 Resist 9 09h PANASONIC ERJ3EKFI9091V 5 20 520 1062 R273 316 5 Resistor 10k PANASONIC ERJ3EKF1002Y 5 20 520 1063 R300 303 5 Resistor 10 2k PANASONIC ERJ3EKF1022V 5 20 520 1064 R194 5 Resistor 1K PHILIPS 232270260102 20 520 1066 R102 103 R216 221 R226 230 R262 5 R 10k PHILIPS 232270260103 Y Fist row contains field names Table macro Delete records without CPN Create neve BOM data column lt lt lt Go Back Cancel Available field types are CPH Customer Part Number i e the customer s part number IPN Internal Part Number i e your part number REFDES Reference Designators i e U1 R1 etc ne HHA Quantity see below PRICE Description at least one field needs to be assigned this CURRENCY PRICE only required for BOM which contain a price Currency only required for pricing BOMs Position field a Assigning this means import
25. 1E475K 1210 4 7 uF 25V X5R 10 USD 2000 4 RS Compone Murata GRM32RAR61E475K 1210 4 7 uF 25V X5R 10 730 tral Avnet Express Murata GRM32AR61E475K 1210 4 7 uF 25V X5R 10 aa USD 10000 Avnet Expres Murata GRM32AR61E475K 1210 4 7 uF 25V X5R 10 3000 Components Murata GRM32RRGIE475K 1210 4 7 uF 25V X5R 10 4 Digi Key Murata GRM32AR61E475K 1210 4 7 uF 25 Y X5A 10 1361 USD 500 Digi Key Murata GRAM32RR61E475K 1210 4 7 uF 25 Y X5R 10 ETA USD Digi Key Murata GRM32RR61E475K 1210 4 7 uF 254 x5R 10 1361 USD 500 This tells us that the PRICE2 is the Scale Price that matches for this Production Quantity 40 Router Solutions BOM Connector User Manual 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 70053 0 92 SKU 490 2218 1 HD 10 0 59621 0 783 Distributor Digi Key AO 0 43599 0 5754 MPN GRM32RRE1E475 51 100 0 34559 0 4582 Manufacturer Murata 290 0 29261 0 3848 IPN 12299 F AOU 0 26448 0 34734 Comment W If the price doesn t appear
26. 20 500 1100 1 1 0 EEPROMe Comment 1 name name a NIR SAFE ANA 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 37 Router Solutions BOM Connector User Manual Edit manual price BOM details Record MPN RefDes Scale Prices 1 Price Prices Source ERP1 Edit informations l 1 6 SKU Price 1 6 Distributor Created by kdecker FE 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 Edited by Manufacturer IPN Edited at Comment Comman Decay date C 01 09 2014 Order informations Lead time days L 0 4004 Stock 0 20 575 1039 Packaging type 03997 Packaging size 0 Currency EUR 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 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 automatical
27. 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 PY DE MPN int vl Y uy SUPPLIER MPN MURATA GRM32ARE1E475KA12L 254 j MATERIAL TYP B DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 8 MURATA GRM32RR61C475KCO1L urce DISTRIBUTOR SUPPLIER MPN DESCRIPTION STOCK CUR INFO PRICE1 QTY1 PRICE2 QTY2 PRICE3 PKQTY QTY3 ROHS a A a Arrow Murata GRM32RR61E475K 1210 4 7 uF 25 VY X5R 10 0 4 Brooks amp Mal Murata GRAM32AR61E475K 1210 4 7 uF 25 X5R 10 4 Future Electr Murata GRM32RR61E475K 1210 4 7 uF 25V X5A 10 0 USD 1000 2000 4 RS Compone Murata GRM32RR61E475K 1210 4 7 uF 25V X5A 10 730 tral Avnet Express Murata GRAM32RR61E475K 1210 4 7 uF 25V X5R 10 0 USD 1000 5000 10000 Avnet Expres Murata GRM32RR61E475K 1210 4 7 uF 25 X5R 10 3000 Components Murata GRM32RR61E475K 1210 4 7 uF 25 V X5R 10 4 Digi Key Murata GRM32RR61E475K 1210 4 7 uF 25V X5A 10 1361 USD 1 10 500 Digi Key Murata GRM32RR61E475K 1210 4 7 uF 25 VY X5R 10 0 USD 2000 Digi Key Murata GRM32RR61E475K 1210 4 7 uF 25V xX5R 10 1361 USD 1 10 500 Enmn Terh Mirata RAMS2RREAI1F APAK 1710 4 7 aF PAV KAR 10 1500 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
28. 5KAT24 MATERIAL TYP DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH PRICE LAGER BEZEICHNUNG3 07664 C1210 1210C 4 7uF 1210 10 SOV X7R c 4u7 1210 F004 7 0 13 549 00 o ee lee 04841 C0805 0805C EE 0805 Ti 6 34 X5R c TEE TEN 0 01 393 00 A nee 05047 C0603 0603C ET 0603 T 6 3VDC XSA c T 0603 YE 0 0088 2533 00 ee AR i np oa ue late i SAMSUNG CL214475KOFNNNE 05108 C0805 0805C 4 7uF 0805 10 16V X5R c 4u7 0805 pF004 7 0 02 2549 00 05173 C0805 0805C 4 7uF 0805 10 10V X5R c 4u7 0805 pF004 7 0 02 6883 00 06354 C1206 1206C 4 74F 1206 10 50V X5R c 4u7 1206 pF004 7 0 08 1631 00 NAJA rnans MANAF 7uF NANA 110 PAV XAR cr az NANA uFnna 7 nn 27 Router Solutions BOM Connector User Manual 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 use 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
29. 60 0606 13 1504 TRIO A SIRDS SEO 0 0008 4583 00 IO ERA ELA f SAMSUNG ARCANA E 1 13 i CL LM i Mutuas Site yok mu Scie Sot MIDA SEIS O 15 4 00 1El 5 46 BELA m TESOP2ALTESOP ZO LIA Tssa u LTIMATES LTAM 00 NE m Ad A o 500 Sawa SU DIS TFBUTIA SUPPUEH WFH DESCAIPTIOH STOCK CUR Price Freire a Olle ES in Wet Did CPES CHA ana A 001 057 550 oo UD G roups CADASIL E Estados dd Hals Vol Dale CRA DEDO FOW Ge 0905011251 Sen lk fei CIA TIA himi ap Wp Da CAFES CADA Tam A 01040 DE 10000 Let y ES Mosa Vou Cooke CRD DER POW Sere 808 01128 a S0000 ih EIFI H Webas Duda CROWD Cro a E 0125 560 PE GD La briva R 1 Webs Dala CADRE Danes CE 011 311 BED 00 z ail ETE 012001255 0 Costa FE Fie CABDMOCONECTIOR amg lfeMT heey Ea apr ahia ERP UltraSearch ERP Material List MPN ERP Box Displays 1 or more This is a direct window Distributor information into your ERP data for selected MPN a A aeamiliad Imported via the selected IPN Distributor Catalog Interface DCI Octopart Info when Octopart search is invoked All windows 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 edge 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 To hide the BOM DETAILS
30. Bristol Electronics Brooks 4 Maldini C Plus Electronics Chip 1 Exchange Chip One Stop Chip Outpost Component Electronics Component Sense 24 v Customer Priority Dachs NORMAL NO_OVERRIDE New DCODE Save Settings Set Distributor Priority Preferred Normal or Undesired Click to add new Distributor The first time you run this your list of distributors will of course be empty When you run the Octopart Search once 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 the list and run the risk that quotes written in the different formats wont all be considered as coming from the same company To enter an alias simply click on the distributor name and enter the various
31. DS WITHOUT CPN will eliminate dummy information like text lines so that these do not get interpreted as parts When completed hit OK and the BOM will be imported BOM Data cis ERP MSS PCB PricingData AML Distributor Program CIS Search Stat amp Auto Link E Bl BOM details Record RefDes BOM AML Scale Prices Y E 98 IPN CPN f AC Quantitiy EE Description E Device Type E Electrical Value E Tolerance E To 1 20 500 1003 1 1 0 HC11 SO14N IC a PARAS ONIE 1 20 500 1015 2 2 0 LM3394D IC 1 20 500 1100 1 1 0 EEPROM 4T24C024N 1050 2 7 IC 2 20 500 1112 2 2 0 PCA9557PW IC 1 20 500 1113 1 1 0 L 374 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 R1K27 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 A 9K09 1 0603 9 09K 1 7 1 Resistor 9 09K 5 5 0 20 520 1062 3 3 0 R10K 1 0603 10K 1 1 Resistor 10K 5 5 0 20 520 1063 4 4 0 R10K21 0603 10 2K 1 7 1 Resistor 10 2K 5 5 0 20 520 1064 1 1 0 R 1K 5 0603 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 UltraSea
32. 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 Quantity F ERP LI 1 50 Then suddenly we see QTY 2 highlighted a Q 50 EUR S 50 EUR IPN CPN RC E Quantity E Description EN Record RefDes Scale Prices 3 Price 20 520 1075 1 1 0 C 22UF 16X5R 20 1210 22U 20 20 Capaci BOM AML 20 525 1026 1 1 0 R 40K2 1 0603 40 2K 1 1 Resiste GRM32AR61E475KA12L MURATA 23 7562 J 12299 20520 1074 1 1 0 C 47UF 25X5R 101210 4 7U 10 10 Capas INT 3 02375 20 575 1041 1 1 0 LV32 TSSOP14 65MM Ic AAA MAA J 20 575 1039 1 1 0 MDS001 SWITCH Switch GRM32AR61E475KAT2L MURATA 20 520 1008 1 1 0 R 1K78 1 0603 1 78K 1 1 Resiste 20 575 1045 4 4 0 R 511K 1 0603 511K 5 5 Resiste 20 500 1015 2 2 0 LM3394D Ic gt Jpdate 30 12 2013 12 59 Searchmode MPN Query P DE MPN int vl Y O E SUPPLIER MPN MURATA GRM32RR61E475KA12L 25V W MATERIAL TYP 8 DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 8 MURATA GRM32RR61C475KC01L urce DISTRIBUTOR SUPPLIER MPN DESCRIPTION STOCK CUR INFO PRICE1 aTY1 PRICE2 QTY2 PRICES PKOTY QTY3 ROHS E A T Arrow Murata GAM32AR6E1E475K 1210 4 7 uF 25 X5R 10 T Brooks amp Mal Murata GRM32AR61E475K 1210 4 7 uF 25 Y X5R 10 4 Future Electr Murata GRM32AR6
33. IRED aa HA SN ABC Components PREFERRED Customer Cyberbrains Inc v ACE PREFERRED E Distributor Customer Priority Advonics Group NORMAL hi 4 Star Electronics NO_OVERRIDE AED Electronics UNDESIRED r ABC Components Allied Electronics NORMAL ACE NO_OVERRIDE The option is simply the other way around You choose the distributor and can set the override per customer Customer gt Distributor Distributor gt Customer Distributor ABC Components w Priority PREFERRED Customer Customer Prionty Cyberbrains Inc UNDESIRED 234 UNDESIRED Lowtech IG NO OVERRIDE 4 4 When you have finished making changes be sure to save the Saye Settings information to the BOM Connector database with l f 44 Router Solutions BOM Connector 7 4 3 3 Creating a Distributor Request User Manual To create a Distributor Request click on the button DISTRIBUTOR REQUEST This brings up the Distributor Request Dialog Distributor E Mail Exod Template Pio Distribuidor E ha A cima PRON tesi Eroutersalutons Ma retciplent o daib a rane kan deckeritcamced da Herwark kmandeckenves El Subpect RFG E Mail conde o e Dear Sire AS Components dedo eset Pliget peowdde a quotation for the alttachod parts ature Eecirorics testi roulersckutions eae Kavin Cheech sity Bozal preview send mel OR Cancel Here you see all your distributors listed You can sort this list easily by click
34. L 32 TSSOP14 65MM IC n ee aa ERP Update 30 12 2013 12 59 Searchmode MPN Query O ES SUPPLIER MPN INF MURATA GRM32RRETE475KA12L 254 MURATA GRM32RR61C475KC01L MATERIAL TYP 8 DESCRIPTION 6 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 8 12299 S 474F 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 Relfllez Scale Prices 2 BOM AML GRAM32ARETE475RAT ZL MURATA E INT GAMS2ARETCAFSECOTL MURATA GAM32AR51E45 67 L MURATA 28 Router Solutions BOM Connector User Manual Note For this to happen you must make sure the following is set under SETTINGS Settings p_a lt Edit User Attributes Common Settings Websearch Settings 4 Search CIS automatically after loading a CSW file M Run SmartSearch automatically after loading a CSW file W Switch to collapsed view after BOM import Z Add MPN Supplier if IPM is assigned 6 3 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 yo
35. 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 rn 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 BOM details RC E Quantitiy EE Description E Tolerance Record RefDes Scale Prices 1 1 0 C22UF 16 x5A 20 1210 22U 20 20 Capacitor 22uF 10 10 pa IPN FR Device Type CPN F Electrical Value epee 0 20 20 1075 1 0 20 525 1026 1 1 0 R 40K2 1 0603 40 2K 13 1 Resistor 40 2K 5 5 GRM32RR61E475KAT2L MURATA 1 20 520 1074 1 1 0 C 47UF 25 5R 101210 4 7U 10 10 Capacior ATE 10 10 1 O Ba 02375 20 575 1041 1 0
36. Number 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 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 M 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 LY374 TSSOP20 65MM 354543455 4004 Cyberbrains Inc C BOM Conmector BOM Connector 20 500 1130 09748 FET IRF 7313 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 A 560A 1 0805 562 1 7 1 4004 Cyberbrains Inc C ERP intern BOM Connector 20 520 1006 02751 A 5604 1 0805 562 1 1 4004 Cyberbrains Inc ERP inter ERP intem 20 520 1006 11792 R 560A 1 0805 562
37. O26 10 LED RED 0805 Led 100 MCPEDIOG 1 0 LED YELLOW OBIS Lod 100 CFEM 50 DPT HORLO 1 S09 Opio Holabos eM A once ESPERE pa TH DESCI DESC DESC 100 PCH IMT Opis coupler 504 100 PEII Opio coupler SOM 100 POINT Oprlocoupler 504 40 SPHEMIET opto 3750 MIN 100 304 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 7 SmbalHeig Program inte BOMDea Conditions as ERPBOM POBLeyot K SmanSearch M CiS Search IK OperatorSearch Y Fito Auto Link Compressed Ky E ua Fl Prhe Total Motenablink F PertD ES Quenttiy Descnpton Ni Name 100 7OCPEN1NSS 7 0 TRA_SOT2 3_BC847_45V_100MA_ NPN Transistor NEN 108 70CPE0 2120 LO FET_STN2NFIO_100V_2A_0 260HM MOSFET N chan 100 70CPEN2 144 10 DIG _5184218_5 A Isolator 100 TOCPE q f gt ulltext Query 100 70CFE ame 100 70CFE Matching records in Material Grid 6 32904 mm Fiber Criteria Search bold TRI DESCI 304 DESCI a 100 PC357N3 Opto coupler S04 a UCN You cae activene a ter expression from tho 100 PC3S7NT Optocoupler 04 1 Soa by double chciong il The hler tuncton works 4 SFHBSUBT opto 3750Y MIN 100 SO4 incremental limiting more records with encha 20 MBA Taso4 mew input The fiter is removed emome call i A on 2 n te relay SO you move to another record in the BOM grid LH bo Z8onm 350 1 mee Solid state relay 504 The following pleceholdors are evelable as DFUSS diode bndge BODY 1A S04 c
38. Router Solutions The Evolution of Electronics Manufacturing K User Manual BOM connector Status Q3 2014 Current Version 6 X Router Solutions BOM Connector User Manual Table of Contents 4 2 3 4 5 BOM Comectior MOVETEC W uua dida 4 System Requirements and InstallatiON ooccccccoocnnncnnconnnnnnnnononancnnnnononnnnnnnononnnnnnnononccnnononanenos 6 2 1 Hardware System Require Me nits ccccccccsseseccecceseecececeeeeeeeecseeeeeeseseeaeeeeeessaeeeeesssageeeeseeas 6 2 2 Installing BOM CGOmector M x8c sec et concer e E A E 6 A ec aoa a aO 8 3 1 Required and Recommended ERP Data FieldS ccoooonccnncccnocccnccnnnanccnncnnnncconcconnnnconnnos 8 3 2 Optional Data He lOs cai cl ota cba cid 8 3 3 Contouring MS ETE o o cena leo 9 3 4 CA dr ooo Pe e aa E sat sesedabets 9 Usa BOM COMMECIO Mi dci dia 10 4 1 Start BOM Connector and update from ERP ooocccnccnccnccnnncccnoncnnnonnnancnnnoononnconnnononncnnononnns 10 4 2 The user Menace id 10 7 Utra Seaia a a eee ee Pe eee en 12 4 3 TASACIONES 13 BEAN Old crio ros 14 5 1 A O E Get nae E A EE A O E anne ing O AE A E E E O OA 17 5 2 EXPONO A BON orenen o A N 17 521 Whatiia Template tinta A tt 17 D22 Template DescipUO sida dde odias 17 52 3 Template Merna eeen a a iaa 18 5 2 4 Creating a New Template usnanica ia Ei 18 520 Saving ana Deleting a Template cta a 24 526 Editing a TEMPS ii AS EAS oe 24 5 3 Using the Export F
39. UNCTION occcccccconccnncccconcnnncnnnoncnnnnonnnncnnnonnnnnnnnnnonnnnrnnnnnnnnnnnnnnnnnnrnnnnnnnanennnns 24 Doe jEXDORING With Templa lE asar dro To a oca vaa 24 5 4 VIEWING Me Resulta diia dls 24 BO PREP aa as eae eats eel uae O IN 25 6 1 CIS SOC serch laa et cle aaa alee ed de ance ic ate hel de a ee ears 25 611 Running te CIS Se aia dde iii 27 6 2 AN A A A O 27 6 3 S mane ains side 29 6 4 Operator o eCe see aan aces visa wien Gepost ee alae eae a 31 6 5 Recap the Search Methods si aceen teen AE AA ees A ies we 32 6 6 USerAanabules did eine 32 6 6 1 Creating User Attributes occcccccconnconocononnconcnononnnnnononancnnnononancnnnnnnnnncnnnnnnnnnrnnnnonannrannnnnnns 32 662 Assigning User AttriDUtTES caia hdd aeea a a aaa Sie ee eects 33 6 6 3 Saving Assignments and User Attributes ooccccccoconconccccconcnnncnnnancnnnonnnnncnnnnonanncnnnnnnnns 33 OG Gt cele teenie o a a A 35 7 1 Taking tom ERP SYSE Menase ii id 35 7 2 What are Price Groups ccccccococccnnccccnnncnncncnnncnnnononancnnnononnnnnnnnnnnnnrnnnnnnnnnrnnnnrnnnnrnnnrnnnnnnnnrnnmanens 35 7 3 Wharare SCale PCOS e 37 2 Router Solutions BOM Connector User Manual 7 4 Searching for Pricing for Various Sources 0oocccccccococccnncccnoncnnnonnnancnnnononancnnnnononnnnnnnnnnanennnnnnnns 38 TAA DISWIDUIOF Catalog asics het do ee 38 A2 Oelse eiii 39 TAS BIisStibttor Requests iia 42 Ao o N 47 o o airas Ne Orie wer ene ee ee Mer een een eee ee p
40. Y3 ROHS EZ Preferred c ACE MUR GRM32RR6IE475K GRM32RR61E475KA12L 0 VIELSCHICHT SMD 4 7 pF X5R 25V 10 237562 1 125908 2500 87898 1000 25000 38 Router Solutions BOM Connector User Manual Here a price list provided by ACE has been imported via the DCI and the DCl 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 Price Groups Quantity F ERP F 1 50 Then suddenly we see QTY 1 highlighted C PRICE 1 Fine PRICE Oye PRICES PRET Ts 2900 1000 5000 This tells us that the PRICE1 is the Scale Price that matches for this Production Quantity 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 Record MPA RelDez Scale Prices 3 Price TF Comment DCI EUR Za robe ea fub2 SKU 2900 12 5905 12 5908 Distributor ACE 25000 grogg 8 0098 MPH GRM32 RRE1E475k47 Manufacturer MUR IPN 12299 Comment GRMS2ZRARBIE475RAT y dll If the price doesn t appear in the BOM it is because there is a better price and BC QUOTE s best w price function has taken it To de activate the other prices simply uncheck them Ica 7 4 2 Octopart Octopart is a web based portal where many distributors post up to the
41. an be used in titer pressions any sing ana char one digit abc ono char torn the list 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 30 Router Solutions BOM Connector User Manual Choosing an IPN Automatically Adds all Associated MPNs into the BOM IPN MPNiCode MPN Supplier ba 21132 873139 CUS_ABB ba 21132 973139 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 4 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 example 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 Start E Auto Link w H BOM MSS2 csv vi amp ea IPN CPN RC E Quantitiy EE Description ER Device Type 2 Electrical Value E T Ope
42. ate is empty To export a column you have to active the column Excel settings Excel template lt Default gt Element Relations MPN INT MPN BOM E UserNote MAT E BAUGRUPPE E BEZEICHNUNG2 E BEZEICHNUNG3 F Descripti E DESCRIPTION E IPN E LAGER E MAT_ID E MATCH E MATERIAL E Original single price T PRICE E TYP E WBZ E ZEICHNUNG MPN INT E Manufacturer INT E MPN INT MPN BOM E Manufacturer BOM E MPN BOM Pricing E Comment E DefaultCurrency E EUR price E EUR total F 1D E Info Create date E Info Created by E Info Decay date Increment by Fleta Cit d in Create position number 10 As you can see when you first create a template all fields are off First give your template a name We will 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 CSV EXCEL p 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
43. ators 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 pr a A A AA ALA AT A E L a F EA Sa oe al Export columns Default hint CPN Not assigned Description IPN Manufacturer BOM MFN 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 ts assigned for following customers ASM 4004 Click YES to remove it permanently from the template NO if you 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 So now let us change the output names lf you want a field exported to a diff
44. by a single line containing all the reference designators Note the automatic price and quantity calculation only works in compact mode 6 5 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 6 User Attributes User Attributes let you add information to a given customer part number The idea 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 SETTINGS They are then stored in the CIS 6 6 1 Creating User Attributes Hit SETTINGS in the action menu P7 BOM Connector zz D 3 BOM Connector O ES o a o O T Pab
45. d what additional information do you want from the distributor e mail settings Request MPN source BOM Q ERP BOM amp ERP Select BOM parts O manual all 6 without prices without IPN Only with MPN MPN HC11 SO14N SN74HC11DR LM339AD LM339ADT EEPROM AT24C02AN 105C 2 7 AT24C02AN10512 7 PCA9557PW A9557PW T LV374 TSSOP20 65MM SN74LV374APWR FET IRF7313 TR F7313 TR R 430K 5 0603 430K 1 1 ERJ3GEYJ434V R 560R 1 0805 562 1 1 CRCWO805560RFKE R1K27 1 0603 1 27K 1 1 ERJ3EKF1271V R 1K78 1 0603 1 78K 1 1 ERJ3EKF1781V R 8K45 1 0603 8 45K 1 1 ERJ3EKF8451V gt L L L L L L L L L L A y 3 ditional Columns Package Device Type Electrical Value Tolerance NOOO Request columns for distributors D Price Minimum Quantity Lead Time Days valid until SKU ordering number a a al a asks for production quantity O 1 50 O 250 CO 500 45 Router Solutions BOM Connector User Manual 8 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 9 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
46. e 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 35 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 nextto EXCEL TEMPLATES Excel template Simply choose the Excel template you want to use by clicking on it 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 from your BOM MAT these are fields from your ERP system 20 Router Solutions BOM Connector User Manual 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 M 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 design
47. e BOM and return to the main BOM Connector screen Click CANCEL to return to the main BOM Connector screen without exporting 5 4 Viewing the Results The results can be viewed immediately with Excel or in the case of CSV files with any standard text editor 24 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 erie a C15 Search gt Start 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 the customer part This section will look at the different searches in detail 6 1 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 will 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 9 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 Customer
48. erent name simply choose the field and right click on it Now choose EDIF You will see the following window 21 Router Solutions BOM Connector User Manual Fromat Short Separator To charactar L Repeat pr Manufacturer BOM _ A Default totes AAA The column is assigned for these customers Export columns Default ASM CPN ae 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 PRICE a e Le Repeat prefix L WEZ Aea A E OR O ZEICHNUNG Export columna MPN CNT e Export columns Default hint Manufacturer INT CPN Not assigned L MPN INT Description MPN BOM A sed Manufacturer BOM MFG ma MPN BOM MPN BOM as Pricing A pl OTE 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 MN CN MPN BOM Other Cal Reines 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 Other
49. ete Mee en ree NE ere 49 8 1 Checking the BOM for INCONSISTenNCIBS cccccconccncccoccncccnncnnnonanoncononcnnononcnnonnannnnonancnronanrnncnnos 49 8 2 Compare two Versions Of a BOM 0 pater aani eaa Enea aeaa ar akkaa aaea aa 49 8 3 Compare a New BOM with the Master BOM in ERP ooocccccccccnccnncccccnncnnnccnonncnnncncnancnoncnonos 50 8 4 Compare a New BOM with the Master BOM in MSS ooooccnnccccnnccnnncnncnccnnncnnonncnnnnnnnancnnnnnnnns 51 SRR A eres Omer et rrert em enc Sen ere ates ere nen ene a oh een ee ete ee eee eee ere ene eres 52 10 BC EXCHAANGE chats acca eaten Sb abcess ace Gaga cree tance ate nae ee earnest ee nea 53 Router Solutions BOM Connector User Manual Introduction to BOM Connector 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 done 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
50. h the PREFERRED flag will be taken When linking you will see different icons Here are the mappings 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 PA 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 M user via the Manual Material Link using the Temporary Material ID Option and will not be saved in CIS 6 2 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 sources 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 e OE SUPPLIER MPN INF 2 AVX O8056D47
51. he total Price Groups Quantity Price rit 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 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 MSS2 csyv BOM details E 1 EUR S 1 EUR gt IPN CPN El RC E Quantity 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 AHCT14 T J 16 1 6 SKU 1 0 0009 0 0035 ba 04692 20 575 1045 4 40 R511K10 Distributor 1 0 0009 0 0027 ba 14328 20 520 1007 3 4 0 RIK27 1 OF MPN 1 0 0008 0 0008 Ba 04666 20 520 1008 1 10 R1K7810 Manufacturer 1 0 01 0 01 ba 11070 20 520 1018 1 1 0 R 8K4510 IPN 1 0 09 0 09 ba 08437
52. ight click you can Open the Octopart Website and access information available there such as the data sheet for that part 2 SOP 5 BUCHSE SCSI 417155 LT3741 a Add Price to BOM Open Octopart website MPN Trackback E a STOCK CUR Copy value PRICES G Copy record 0 65000 USD pees ua 0 4 a 0 10000 USD 0 0037 1 0 20000 USD 0 7153 USD 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 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 Distributor Handling The BOM Connector M database includes a list of distributors which you build up The Distributor List Distributor is available when you click on the tab called k 42 Router Solutions BOM Connector User Manual 7 4 3 2 The Distributor Tab Customer Overrides for Distributor Alias es distributors Distributor email List of Distributors BOM Data Ns cnpwss N rca PriciyData AML Distributor Program Info Reload Distributor Wistributor request Load Distributor request Distributor Distributor Priority Alias Prioritiy overrides for customers C
53. ing on a column header Normally for example you will want to see all your PREFERRED distributors at the top of the screen Check the distributors you want to send an RFW to 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 those you don t want to consider in your quoting Note that all distributor 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 Note if you don t wish to use the BC QUOTE email function you can skip steps 2 4 and 5 2 Select which distributors you wish to email the request to Simply check the box next to the Distributor Name 3 Select an Excel Template if you have one For more information see the section 5 2 4 Creating a New Template 4 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 an
54. it is always compatible with future versions and no additional costs are incurred on the SAP side 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 obomcon 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 customer but E Server Login here is an example Benutzername Demo User kenno Datenbank a Server Demo Server Abbrechen 4 2 The user interface Particular emphasis has been made to keep BOM Connect
55. itiy FE Description EN 14 Record MPN RefDes Scale Prices 3 Price 1 20 500 1003 1 1 0 HC11 5014N IC DISTR EUR 1 20 500 1015 2 2 0 LM3394D IC 345345 0 58959 0 5895858 SKU 1 20 500 1100 1 1 0 EEPROM AT24C02AN 105C 2 7 IC Distributor 2 20 500 1112 2 2 0 PCA9557PW IC MPN 1 20 500 1113 1 1 0 LW374 TSSOP20 65MM IC Manufacturer 1 20 500 1130 1 1 0 FET IRF 313 TR Transis IPN 1 4 4 0 R 430K 5 0603 430K 1 7 1 Resistc Comment m 1 20 520 1003 an can anne J di 7 5 4 J i J 45 n crean 4 na Measicto 46 Router Solutions BOM Connector User Manual If you EDIT the Scale Price you will see the source is set to Distributor Request Edit manual price Source Distnbutor Request Production Gity Price Distributor C Plus Electronics E SKU Manufacturer PHILIPS MPN Ag557PW T IPN 035964 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
56. l ERP part number as well as your user attributes into the so called CIS customer info set Update Parts 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 Run BOM Compare this function lets you read in two BOMs and compare them 13 Router Solutions BOM Connector User Manual 5 BC IN OUT Once you have started BOM Connector M the first step is to read in your BOM The BOM Import feature is part of the BC IN OUT module and is standard part of every BOM Connector configuration Click on LOAD BOM DATA in the action menu If you have been working with BOM Connector for some time you will see a list of the last 16 depending on resolution BOMs you read in Show file selection dialog To choose a new BOM select PE ee _ Or a directory in the second half of the suggestion list 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 called MSS2 CSV Load this file You will now see a screen with a list of customers E7 Import BOM MSS_TEST2 csv Search Filter w ID Kunde Adresse 4004 Cyberbrains Inc 4001 Krantech 4G 4003 Lowtech IG 4002 Megatronics Add new customer lt lt lt Go Back Next gt gt gt Cancel The list of customers is
57. ly 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 Stat Auto Link El w Ed AA BOM details pa IPN CPN RC Quantitiy EE Description EN Device Type F Electrical Value E Tolerance E T4 Record RefDes Scale Prices 2 0 20 520 1075 1 1 0 C 22UF 16 X5R 20 1210 22U 20 20 Capacitor 22uF 10 10 E BOM AML 0 20 525 1026 1 1 0 R 40K2 1 0603 40 2K 1 0 1 Resistor 40 2K 5 5 ARA ALEA 1 B3 12299 20 520 1074 1 1 0 C 4 7UF 25X5R 101210 4 7U 10 10 i 4 7uF 10 10 SAN 1 ba 02375 20 575 1041 1 1 0 LV32 TSSOP14 65MM GRM32RR61C475KCOIL MURATA 0 ba 03997 20 575 1039 1 1 0 MDSOO1 SWITCH GRM32RR61E475KAT2L MURATA 2 ba 04666 20 520 1008 1 1 0 R 1K781 0603 1 78K 1 1 Resistor 0 pa 04692 20 575 1045 4 4 0 R 511K 1 0603 511K 5 5 Resistor 1 ba 04970 20 500 1015 2 2 0 LM3394D Ic lt ERP Update 30 12 2013 12 59 Searchmode DCI search r 4 v amp 6 amp 3 3 MATERIAL TYP DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNUNG3 8 WBZ 12299 S 4 74F 121010 25V X5R c 47uF 1210 pF004 7 0 39 951 00 0 Source DISTRIBUTOR SUPPLIER MPN DESCRIPTION STOCK CUR INFO PRICE1 QTY1 PRICE2 QTY2 PRICES PKQTY QT
58. mation back to component engineering OUTPUT SORTING Here you can specify certain columns to be sorted Column 1 not sorted Column 2 not sorted hi Column 3 not sorted 23 Router Solutions BOM Connector User Manual Choose the column name which you want sorted by from the drop down list 5 2 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 Mame 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 a ul trashcan icon 5 2 6 Editing a Template gq To edit 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 3 Using the Export Function 5 3 1 Exporting With Template To export with a template simply click on EXPORT BOM from the main BOM Connector screen Es 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 If you click on OK it will export th
59. nnector and update from ERP page 10 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 Router Solutions BOM Connector User Manual 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 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 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
60. or 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 E de db 17 10 2014 14 59 Le script 17 02 2014 10 21 de vPlanPlugins 17 10 2014 14 58 D at 17 10 2014 14 58 BOM Connector ETL pdf 16 08 2012 09 55 F 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 H bomecon ini 21 09 2013 21 30 K _ bormcon_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 clients 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 Router Solutions BOM Connector
61. or 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 M user interface 10 Router Solutions BOM Connector User Manual Search Options Imported BOM BOM Details window with MPN details pricing UltraSearch Action Menu l baih Fis BE sa t Cintas i Phe a Erie trih H 2 content CIC wl G Y 00 2i Reed MPH Fett Seale Pesas fi e Eee Be p EX SB SA z I 2 EL te AN tfh lA Guy reception E Tere Da Teeter 2 m Ea e EL ALI E coun 1 20001009 1 1 0 HON SOM ap s cra OF y La 2005001015 e 20 LHD ia Seve Data i i AFAA 1 10 LLP aT DADA T l Unas Pam Cinta 205001112 E 20 PASES 1 APSE 1 10 LEA DPSS eel E sem 1 BO 1 10 FER ETS ustol 1er ll By Ren Boe 1 E di 4 4 0 MAJA 13241 Y A Fem Gt pe pa EGO ADOS 1 1 0 A SOR OSCE 5 5 nfo 1 AHAH J 40 FIRST od Seek 3 E ESOS 1 s 1 LO A REPS 0003 1 FAY Cu l lares C popin ine 1 AA A 10 Ae 0010 145 51 40 1 7 a parma B bo Svea i i AE Soe ns Go a E aE aira E E Md E e Linked 0 m gt d c ER A FRR HPN Ke i T VGHey DAD WTRDSSEIAFEES EO Dibr Prater l MATEFRAL nF a A DESCAFTON B EMIGANFPE D ZENHRMG MAICH PRICE LAGER GEZEMHHUHG 0 sia po Fria g 1 gt i EWR te ISOS DEIA 5
62. osyX D gt m Da 11 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 32 Router Solutions BOM Connector User Manual 6 6 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 PF BOM Connector 25 38 X Qose BOM File T Quantity Fl Oescnpton Name Cl mms O THT O Smt 9 0 OPT_PCIS7_SO4 Opto 7 x PC357 x Ex 4 70 TRA_SO DODAT Mi SOMA MINA Trensistor NPN 7 BCI47B ES CAMCAD Linh 1 0 FET_S Remove Material Link JOSFET N channel 1 x STN2NF10 0 DIG 14 val hotal tsolator 1 5164218 w ye Date 0 LEDR C bd ML200LTT O LEL bd ML210YTT fe Parts D A M Link Apan s 0 OF ipio CPLIGTII E Settings f Eh Run Bom User Attributes Do not use f wn BOM Compare TA DESCI 5 DESCI 100 sosa cuen Delete Row eR BOM Properties See data PE 96 80947 NPN ga Google Search i n Cust 1D 80030 CAF trat as nger me AATAS s 3 659 thn e EO E 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 new field automatically added els 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
63. our ASSEMBLIES Simply choose the one you want to import If you click on LOAD CAD at the lower left you will also import the CAD file see Chapter 9 BC CAD Once the BOM is loaded you can compare it with the BOM loaded in the BOM Tab by choosing COMARE BOM The result is shown the same as described in 8 3 above 91 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 poan EAD 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 A _comp_mount_type _ind_onent_req TOL ADD_PART ADD_PART_DESC ADD_PART_OTY ALT_SYMBOLS COMPHEIGHT CustomerP art umber DESCRIPTION Description Legacy Description Description2 Description3 Descriptions DEVICE TYPE External Document GEOMETRYNAME InternalPartNumber LOADED ManufacturerPartNumber Package Source DK 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 Componen
64. r ERP system lf 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 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 A A 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 itin 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 Use this held to obtain price informatico Currency PRICE w EUR h should see this setting Normally pricing is a straight 1 1 from ERP Sometimes ERP pricing is very detailed and includes scale prices For this see the section 7 3 Wha
65. r 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 Router Solutions BOM Connector User Manual e New Customer BOM with the BOM stored in Valor MSS e ERP 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
66. rator Search allows for a comparison of BOM fields and ERP material master The search is executed for each row in the BOM A All search expressions marked as active are linked by a logical AND Instead of a BOM field you can use a fixed search token too Search Expressions MATERIAL equal IPN B O O 0 O O O OOOO O O O ERP Update 30 12 2013 12 5 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 31 Router 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
67. rbrains Ine Cyberbraing Ine Cyberbrains Inc Cyberbrains Ine Pref CPN Source Link Source BA CPH C BOM onnector ROM Connector 230 500 1113 C BOM Delete Customer Material 4130 BOM Copy KIS data 4003 a ERP 1006 ERP Copy Note to BOM 1006 dl BOM l Copy all Notes to BOM 4 007 J 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 26 Router Solutions BOM Connector User Manual 6 1 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 lower 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 wit
68. rch as described in Chapter 4 For example type in 470nf BOM MSS2 csv vi amp 2 69 6 5 IPN CPN f RC E Quantitiy E Description FR Device Type EA Electrical alue EA Tolerance E Tolera 0 20 520 1070 12 12 0 C 470NF 16 X5R 10 0603 470N 10 10 Capacitor 470nF 10 10 0 20 565 1027 1 1 0 C470NF 25 X7R 10 805 470N 10 10 Capacitor 470nF 10 10 The two 470nf capacitors are displayed 2 69 If we turn on the Sync button then the parts that match are displayed in the ERP window as well to clear the search click on the off filter JOM MSS2 csv 470nf vi Y 2 69 IPN CPN f RC a Quantitiy e Description EA Device Type EN Electrical Value EN Tolerance 0 20520 1070 12 12 0 C AONE 165A 10 060 470N 10 10 Capacitor ATO 10 o 20565 1027 1 1 0 CAPONE 25X7 10 805 470N 10 10 Capacitor 4700F 10 lt RAP Update 30 12 2013 12 59 Searchmode CIS Search 470nt v 22111098 ow MATERIAL TYP 6 DESCRIPTION 8 BAUGRUPPE ZEICHNUNG MATCH 8 PRICE LAGER BEZEICHNL 03096 C0805 0805C 470NF 0805 10 504 X7R C 470n 0805 NF470 0 01 1899 00 04049 C0603 0603C 470NF 0603 10 50 63 NPO C 470n 0603 NF470 0 0025 2606 00 04363 C1206 1206C 470NF 1206 10 16V C 470n 1206 NF470 0 0 0 00 04342 C1206 1206C 470NF 1206 10 50V X7R C 470n 1206 NF470 0 01 2000 00 06208 470nF RM22 5 275V MKP C 470n RM22 5 NF470 0 3 196 00 05905 C0603 0603C 470NF 0603 10 16V X7R C 470n 0603 NF470 0 0045 3885 00 061
69. t are Scale Prices To use the ERP price in your quotes simply activate the ERP1 Price Group more on Price Groups in a moment To do this click the box next to ERP1 at the lower left of the screen Price Groups Quantity Price Unit AR FIA A AL LL 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 via these icons Price Groups eo 1 35 Router Solutions BOM Connector User Manual qa Select Currency This lets you select the currency you want your Price Group to be displayed in BOM Connector M 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 ay Change sum total Click here to change between displaying only the per board price and the total price which is calculated by multiplying the per board price by the Production Quantity PQ Delete a quantity Once you have added Production Quantities you can delete them here Add a quantity This is where you add your Production Quantities These are used to calculate the Scale Prices from the vario
70. th 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 14 for a concrete example 12 Router Solutions 4 3 The Action Menu Actions Load BOM File Close BOM File Esport BOM CAD Link De YY x Save Data e Update Parts Data Settings Aun BOM Compare BOM Connector User Manual With Load BOM File you can read in any CSV or XLS file This is usually the first step for an EMS reading in the customer BOM file The file must contain at least Reference Designators or Part numbers IPN and have at least one description field Close BOM File removes the currently loaded BOM file from memory to let you read in a new one Note reading in a new BOM will erase the existing BOM from memory Export BOM let you export your result i e Golden Manufacturing BOM into different formats such as XLS CSV HTML or for SAP users a direct SAP project creator The exported BOM can be cumulative or flat CAD Link 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 added into columns in your BOM This lets you compare the contents of the BOM with information in the design save Data is used to store your settings i e the correlation between customer part number and your interna
71. 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 ERPMm55 Load BOM Copy BOM Exportto CC Save Ls 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 Material Plant Alternative BOM type Wald from Change No Revision test test 1 Do not resolve chained products Mas number of hierarchy levels 1 Progress Export database file with test data to desktop 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 ERPAMS5 PCB Pricing Da tto CCZ Save CSV file Compare BUM Col Changes to partnumbers IPNs or reference designators are shown with a red X mark 50 Router Solutions BOM Connector User Manual 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 00
72. ts 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 92 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 53 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 54
73. u 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 a and ERP By splitting into individual tri grams a field 100k 0603 1 0 will receive a high match 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 Hit rate factor El UA Frice Material Link FartlD RefDes El Description O Nar 28s 100 FOCPEO1 295
74. us sources Simply click here and you will see this dialog enter new production quantity Enter the amount of boards you will produce and click OK Once you have entered a few Production Quantities i e 1 50 250 500 your screen should look as follows Price Groups e 1 Quantity Price Ll rit ERPI F 1 F 50 250 dl 500 We added a Price Group of 1 because 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 36 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 one ERP1 as above you will notice that two new columns have appeared and some prices ua E 1 EUR S 1 EUR IFN CPN ka 04970 20 500 1015 0 09 0 09 MM 08437 20 500 1100 20 500 1112 ba 11792 20 500 1113 ba 09748 20 500 1130 0 0074 0 0056 wa 07781 20 520 1003 20 520 1006 0 0009 0 0027 Ma 14328 20 520 1007 0 0008 0 0008 WI 04666 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 t
75. ustomer gt Distributor Distributor gt Customer 4 Star Electronics ACE Advonics Group AED Electronics Alied Electronics Amazon com America II Area51 Authorized Area51 Recertified Arow ASAP Semiconductor Avnet Express Avnet Express Asia Avnet Express Europe B D Enterprises Bison Technologies Braun Bristol Electronics Brooks amp Maldini C Plus Electronics Chip 1 Exchange Chip One Stop Chip Outpost Component Electronics Componert Sense 24 Components Direct ComponentsMAX Cyclops Electronics UNDESIRED PREFERRED NORMAL UNDESIRED NORMAL NORMAL NORMAL UNDESIRED UNDESIRED UNDESIRED NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL UNDESIRED PREFERRED UNDESIRED UNDESIRED UNDESIRED NORMAL 7 test routersolutions de Customer 234 Distributor NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE NO_OVERRIDE ACE Advonics Group AED Electronics Allied Electronics Amazon com America Area51 Authorized Area51 Recertified Arrow ASAP Semiconductor Avnet Express Avnet Express Asia Avnet Express Europe B D Enterprises Bison Technologies Braun
76. 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 lt 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 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 Co

User Manual Status: Q3, 2014 Current Version 6.X

Contents

Download Pdf Manuals

Related Search

Related Contents