I am creating a report to pull all rows in a date period from Sales Invoice Line.
I would like to filter so that only orders are returned where there is a specific Item Category Code (AP).
However, I do not want just Item Category = AP lines. I want the rest of the lines on that order as well. (shipping in this case)
I need to filter all lines to return the list of just the orders, then returns all the lines of details of those orders. Just cant seem to nail the syntax.