I'm getting a request to create the ability to store multiple manufacturers and manf part numbers per item. Has anyone else done this?

Yes

We do have that enabled, and use it, but the issue is that we want to see multiple Manufacturers, and associated multiple MFPNs. One vendor can have more than one mfg. It can be changed on the item record as needed, but it doesn't retain a history, like if we temporarily have to use a different mfg but will go back to the original one, it's just a lot of sifting through emails or spreadsheet management to look that up. I don't think NS can do this, but was just seeing if anyone has tried.

I mean, if all you need to do is store the history - you could use a custom record

will, ideally they want to be able to store it on the item record in a list format, indicate which one is preferred, then have the ability to chose mfg when doing a purchase order. don't think i see that happening.

I mean, you can make a custom record sublist - and then join it to a custom column field filtered by the vendor.

thanks, @KevinJ of Kansas. This would be by item, not vendor. the only problem with this is that the user can't add to it on the fly on the item record, unless i'm mistaken.

No, they'd be able to add it on the fly to both if you configured it correctly.

Just wanted to mention we're facing this challenge as well. We have a number of vendors we purchase from, as well as a number of manufacturer part numbers that all are identical parts based on the manufacturer. (Screws, resistors, capacitors, etc.) I think we're going with the sublist with a checkbox for primary so we can try to make it pull in the default on purchase orders. Ah the complexities.

@GrayLeopard, good to know. I'm going with the sublist as well, they just want one place (item record) to see what the manufacturer options are (same types of items). When you get that going let me know how it goes! Thanks!