Hello,
I was looking to build a GI replica/version of the data that the Inventory Summary inquiry screen provides. Basically, the same data but not filtered down to only one stock item at a time. I need to see this data for all stock items at once, and the stock item GI is not simple to add these additional fields to since the tables are so different and it’d increase the rows.
The inventory summary screen however, which, see below:
When inspected for customization, it has a “filter” table and a “results” table:
And both of these tables I can’t figure how to build off of since they expect a filter in order to populate data. But I need to see the same data (all warehouse locations of the stock item + their on hand QTY and the unit cost in that location) WITHOUT the filter down to one stock item at a time applied.
I tried guessing from documentation and pulling INsite and INtran both those didn’t give me the right cost or locations.
Does anyone have guidance on how to recreate this to a GI/non-filtered version? Thank you.
