Allow search of vendor reference number

It would be great to be able to search via vendor reference number in materials. I find there are multiple times a week that I am looking for a part number given to me by someone in the shop that may be brand specific, where my material is generic. I have multiple pricing and vendors loaded for the material, but it is difficult to locate without the additional search option in material.

Guest
Jul 26 2017
Future Consideration

Attach files

Enter a subject

Guest commented

December 15, 2022 18:51

The ability to have multiple part numbers for a part is very common, I'm very surprised this ERP does not give us the capability to have multiple part #s that are searchable and ties it together in the location database.
Example, MS51957-18,211005497,91400A114 All identical parts...

×
Attachments Open full size
Nick Lindsay commented

August 23, 2018 19:13

Copy and paste this into Shop Alerts Query

SELECT Material.Material, Material.Description, Vendor_Material.Vendor_Reference, Vendor_Material.Vendor, Material.Status
FROM Material INNER JOIN
Vendor_Material ON Material.Material = Vendor_Material.Material_Owner
WHERE Vendor_Material.Vendor_Reference = 'INSERT VENDOR NUMBER HERE'

×
Attachments Open full size