Report off of Public Shopping Lists

Summary:

When using Public Shopping Lists you can't see what is available in Inventory. As a workaround we are looking to build a report with a listing of item on the PSL and show Inventory On-Hand for the items. This is needed as this or Cafeteria orders and if it isn't on-hand the menu would need to be changed as backorder isn't an option. Would this be possible and if so how do I find PSL when building a report?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):