We have entered the Primary Vendor for each inventory item in IC (back in the Accpac PLus days). When we try to create a Gridview file from the Master Inventory table we cannot find the field for the Primary vendor.

Is this field in this table? If not, which table is it in and how can I print a report to list all items with the same Primary Vendor?