Printing/Viewing specific inventory locations across many inventory locations
As part of our monthly sales reports to suppliers, we include an inventory report showing onhand inventory totals on each of their items across multiple locations. Some suppliers have items in many inventory locations while others do not. How can we print/view those locations (or fields?) having inventory only?
For examle, there's 22 locations total. Supplier A has inventory on their items in location 1, 5 and 8, while supplier B has inventory on their specific titles in location 2, 5, 10, 13, 17, 20.
When generating the suppliers inventory report, we only want to show the inventory levels in location 1, 5 and 8 for Supplier A. For Supplier B, we only want to show inventory levels in location 2, 5, 10, 13, 17, 20.
To provide a real example, the image attached shows our inventory report for Supplier 655. As you can see, Supplier 655 has invenory in Location 001, 102, 122, 124 and 128. When printing/saving their inventory report to PDF, we don't want to show locations where there's no onhand inventory (104, 120, 121, 127, 131, etc)