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 within the BoM screen 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 complete the order using an 

17
                                                                        
18
                                                                    
19
                                                                        

Note: if the only part associated with an individual line item was manually added, the platform will not allow the user to place the order; a MacroFab admin must update the part attribute so the customer can proceed with placing an order.  

 

60


MPN, value, and package information has moved within the BoM screen

20
                                                     

Added the ability to view and change pin count and mount type for individual parts on the part override screen based on “Part ID”

 21

MacroFab admins must specify pricing for any manually added parts to the BoM

 22

Add Pricing for Manual Part

 23

Add Pricing for Manual Part

24

 

The order summary page now shows parts from alternate lists 

 25

Order Summary Page
26
We have added a tooltip on the order summary screen indicating which exact capsule revision an order was placed against 80
                                               
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

The image below shows how to search by CPNc13

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