[Benjamin Baxter]

I don’t think there is a base report that will get you everything you need. For example, the “Item/Vendor Catalog” Report you mentioned is pulling from the “Vendor Item Catalog” table, without picking up the Default Vendor defined on the Item Card itself. This means Items only purchased from a single Vendor, defined on the Item Card only, would not appear on the report.

You could write an Extension to populate the Vendor Item Catalog table when you add the Default Vendor to the Item, this way the entry exists in both places and would allow the “Item/Vendor Catalog” report to properly display all Vendors.

Now that we have the data updating with what we need, the next change would be to redesign the “Item/Vendor Catalog” report to group by Item and not by Vendor, thus giving you a list of all the Vendors that can be used to requisition the Item.

Sorry, I don’t know a stock report for this, but with some quick extensions you’d be able to make it happen.

Best Regards,

Ben Baxter – Accent Software Inc