1. MacroFab Platform Help
  2. MacroFab Platform Help

How do I add Alternates Parts to my BOM

MacroFab's new Approved Vendor Lists

The MacroFab Platform now supports lists of alternate MPNs to be used in place of the primary part for individual line items of a BOM. A green checkmark icon shows the predicted part to be used and how much it is predicted to cost at the time of order submission.

This list of alternate parts can be made reusable by assigning a title to the list called a “CPN” or Customer Part Number.  Once an alternative part list has been assigned a CPN it becomes a “Custom Alternative Part List” and can be centrally managed within “My Organization”

 

The MacroFab platform now support multiple MPN within a single BOM upload. A multi-column MPN BOM (.xlsx) can now be uploaded to the MacroFab BOM tool. The BOM tool will now accept multiple MPNs. multiplempn

Below is an example of a Custom Alternate Part list. The list can be achieved by either uploading a .xlsx with more than one column for MPN or manually as detailed below. This Custom Alternate Part list has been given a CPN or Customer Part Number. Here is an example of the .xlsx

BOMnew

Here is a link to a sample empty BOM .xlsx Sample BOM Empty Version 

Here is a link to a sample BOM with populated test data Sample BOM with Data

 

The CPN - Customer Part Number

How to create a CPN - The CPN can be created simply by clicking its value and entering a name

1-1

                                                        

The parts comprising an alternate list can be found in the table under “Parts Allowed”

3

                                                                              Parts Allowed

The “Parts Allowed“ table includes the new Strategic Sourcing Tool which contains a toggle for sorting parts by “Price” (in ascending order; least expensive to most expensive) or “Fixed” (user defined order)


“Price” will result in the purchasing of the lowest cost part in the alternate list that is capable of satisfying the target quantity

4

                 The above shows Priority = “Price“

 

“Fixed” will result in the purchasing of the highest ranked part in the AVL (1 - highest, 2 - second highest, etc.) that is capable of satisfying the target quantity

5-1

              The above shows  Priority = "Fixed"

 

A green checkmark icon shows the predicted part to be used and how much it is predicted to cost at the time of order submission. At this time we only support the order being placed if all demand can be satisfied by a single MPN. We do not allow the customer to specify that we use X of part ABC and Y of part DEF. However, at planning and purchasing time we do not preclude our supply chain team from doing this.

6

 

Individual components (MPNs) can be searched and added to the alternate list with the “Add a Component” search box7

        

Search results for MPNs are displayed under the “Marketplace Components” table8

Once a search is completed, simply click the Add Component button to add the component to your list of Alternate Parts.                                                                                 

9

                                                                           

10

 

Note: When an alternate list has been created, adding or removing parts will be reflected in all PCB BOMs that use the alternate list. When an alternative part list has been created and assigned a CPN (making it a “Custom Alternative Part List”), adding or removing parts to the list will be reflected in all PCB BOMs that use the CPN.


Alternate lists (CPNs) can be searched and selected to replace the current alternate list associated with a BOM row. Enter your CPN in the search box as seen below, and search for the CNP from within your Organization. 

11

                                                                                                                                              

 

Search results for alternate lists (CPNs) are displayed under the “Custom Components” table

12

 

The search will provide each part or MPN which is included in the search for the CPN. 

13
                                                  
 CPNs returned in the search results may be selected to replace the current alternative part list
14
                                                
 
15
                                                                   Replacing an Alternate List
 

Existing alternate lists (CPNs) can be renamed by clicking on their value and entering a new name. Note: Doing so will change the name of the CPN for all members of your Organization. 55

When one attempts to rename the CPN a notice prior to the name change will appear asking to confirm the name change.  56
 
 
 

The “Add a Component” search may also return both alternate list (CPN) and MPN results if applicable. Below is the results of the search, yielding a simultaneous MPN and CPN Search Results. One would need to select either the Component (MPN) or Custom Part Number (CPN)

 16

                                           

Note: MPN, value, and package information has moved and is now located as seen below. moved

 

In the event that a valid part (MPN) or alternate list (CPN) cannot be found using the “Add a Component” search, a part may be added manually. To do so click the Add Part Manually button

17
 Next enter the MPN and Manufacturer and then click Add to Allowed Parts                                                  
18
 If the BOM tool cannot find any information regarding the Manually entered part, please contact support@macrofab.com                                                                   
19
                                                                        

Note: MPN, value, and package information has moved and is now located as seen below.

20
 
Managing Custom Alternate Parts Lists
The MacroFab Platform now includes a screen for Custom Alternative Part List management at the organization level. Custom Alternative Part Lists allow you to manage alternative allowed part lists globally across your team. Any changes will automatically be applied to PCBs that reference the Custom Part Number (CPN) you have set for the list. custom1
 

All of an organization’s Custom Alternative Part Lists are displayed on this centralized page. Any change will affect the CPN and its associated BOM.

 

custom2

c8c5
You can search individual lists for details and or editing
c6
When a search is complete you can edit CPN, Description and Preference. 
c9
 
Below is where the Preference - Price or Fixed (The order in which you want your Alternatives to be listed for purchase) c10

How to search for CNP c13

To delete an individual part, click on the red trash can icon. c14

From the My Organization screen one can also add components  c15

c16

c18

Adding a part manually is also available from this screen, the functionality is identical to that found in the BOM tool. Click the add Part Manually button

c20

Then click the Add to Allowed Parts button to add the part. 

c22

c23

From this page a new CPN or Custom Alternate Part list can be created. To do so click the Add new list button.  c25

Click the save button to save the new CPN.

c26

Once saved, you will see your new CPN in you list of CPN's. c30

If you need assistance with the new AVL - Approved Vendor Lists please contact support@macrofab.com