3 Replies Latest reply on Jul 27, 2013 11:21 AM by philmodjunk

    Printing/Viewing specific inventory locations across many inventory locations

    leftear13

      Title

      Printing/Viewing specific inventory locations across many inventory locations

      Post

           Hi,

           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)

           Any insight?

           Thanks,

           Chris

      Capture.JPG

        • 1. Re: Printing/Viewing specific inventory locations across many inventory locations
          philmodjunk

               It's possible, but not simple. Relationships, calculation fileds, filtered portals and (possibly) ExecuteSQL might all be involved in setting up this type of report (called a cross tab report).

               Much depends on the design details of your database in terms of your tables and existing relationships. You may want to hire a consultant familiar with this reporting method to set it up for you. Especially since, if I understand correctly, you want to omit columns of data where a given supplier does not have any of their product located.

          • 2. Re: Printing/Viewing specific inventory locations across many inventory locations
            leftear13

                 Hi, Thanks for your reply.  I figured speaking with a programmer is probably the way to go here.   But, as an option, is it possible to select the locations with inventory (maybe via a checkbox, or popup window allowing to choose which locations to include) and then create a script to show only those locations in a new layout?  For example, each location would have a checkbox.  We'd then click the checkboxes/locations having inventory, click a button to run some kind of script taking the selected locations to a new layout? 

                  

                 Thanks for your help.

                  

                  

            • 3. Re: Printing/Viewing specific inventory locations across many inventory locations
              philmodjunk

                   It's possible, though the process isn't any simpler and won't actually "take the selected locations to a new layout". The columns of data can be produced with filtered portals so it is possible to manipulate the value in a field that is part of the portal's filter expression in order to select a particular set of records to supply data to that column.