Query to show all products and all products associated to vendors?
Would it be possible to have a query to show products and a query to show all vendors and there associated products? Right now my acquisition team needs this in order to create some PO's but I can give them access to this list unless I give them Admin access in SD+. This would be a requirement for future releases of SD+, to allow full access to products and vendors based on certain role permissions. But for now if I could get a query at least I would be able to get by.
SD+ version: 9.2 Build 9211
Database: MSSSQL