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
Login
Report
There was a problem reporting this post.
Block Member?
Please confirm you want to block this member.
You will no longer be able to:
See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection
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!