Thank you @RenjolynC
Could you please clarify a couple more questions:
- Why is the "Source Name" missing from the filtering fields?
- The report is really showing the line items in PO rather than showing one line item per PO. Is there another way to generate a report showing a single line item per PO? Then if I want to see the detailed line items within the PO I can zoom into the PO
- The "preferred vendor" is a field that is part of an item. If I order this item from another vendor that is not preferred vendor then the report will be incorrect because it would exclude all items that are not matching the preferred vendor in the search. What other options are available?
- What other options are available for creating better reporting?