I'm getting a request to create the ability to sto...
# manufacturing
a
I'm getting a request to create the ability to store multiple manufacturers and manf part numbers per item. Has anyone else done this?
k
Yes
Enable the "Multiple Vendors" feature
then on the item record there will be a tab where you can define the vendors, their part number, and price.
a
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.
k
I mean, if all you need to do is store the history - you could use a custom record
a
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.
it is listed as an NS enhancement but not holding my breath, just wondered if someone had a workaround.
k
I mean, you can make a custom record sublist - and then join it to a custom column field filtered by the vendor.
It wouldn't be that hard to do.
a
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.
k
No, they'd be able to add it on the fly to both if you configured it correctly.
That said - the filtering on the transaction would absolutely be by the vendor.
so that you could only pick valid results by the appropriate vendor.
I.e. Vendor A buys from MFG 1, 2, 4, but not 3. Vendor B buys from MFG 1, 3, 4, but not 2. those sorts of things.
g
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.
a
@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!