Sage 100

Customer wants to be able to sort/view product line in the Item Quantities by Warehouse BIE view. Is it possible to add another table to a BIE view?

If you go into Column settings and click add, CI_Item is a table available, so you can add product line to the view.

Sorry, I should have specified that they need the product line description, and i don't think that's part of CI_Item?

Well, @ThereseLogeais, here is another application that has Pivot Table written all over it. And @DanBurleson has developed dashboards using Access and I believe Excel which would probably work here as well....

I'd create a Product Line Desc UDF in CI_Item (using ProductLine as data source), VI the descriptions for existing items (new items will inherit description), then add the UDF to the BIE view.