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.
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for people that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!