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?

Hello, Elvira!

In GridView, the IC Primary Vendor field can be found in the table 'I/C Additional Item File' (@N65AIT2).

To view/print the view to list all items with the same Primary Vendor, create a filter with the syntax: {Vendor 1 Code} = "AAAAAA", where "AAAAAA" represents the Primary Vendor Code you want to select.

Make sure you select the actual {Vendor 1 Code} field from the list at the left, rather than typing it in.

Regards

Alright - I stand corrected!

quote:

---

Make sure you select the actual {Vendor 1 Code} field from the list at the left, rather than typing it in.

---

You CAN type the field name in, but you must make sure it's syntax is exactly as the program expects - AND the Vendor Code (Customer Code, Item Number etc) must actually EXIST!

In my testing, it was the latter that got me in trouble.... AR Customer Codes do not exist in Payables!

Good luck!