Right now we're limited to one mpn and mfr per item under the additional tab in Item Maintenance, while we are usually able to choose from multiple mpn's on the customer bom for each item (primarily resistors where we can order from Koa, Dale/Vishay, Panasonic, etc). If the Koa part we have listed becomes a long lead-time part, to switch to a different mpn requires creating a whole new item# and updating the bom with that new item.

Instead, under the additional tab in Item Maintenance you could fill in the information for one mpn/manufacturer and then select some form of "add mpn" to populate a new mpn/manufacturer with its own specific information tied to it (price, lead time, attrition, customer pat#, etc.) that would still be tied to that same item number.

This way, when you go to an item and enter the additional tab you would be able to see a list of mpns listed for that item, and by selecting one it would populate the rest of the information for that mpn.

This would, in my opinion, increase Sage's value as an ERP system since we would be able to use Sage to quote and buy for builds instead of using an external site to quote all available mpns and then populate Sage with just the current ones being bought. It would also vastly simplify error checking since we could do a true compare between the Sage bom and the customer bom and use Sage to create an internal bom that could also be compared to the customer bom.

Comments