Filter on Sales Invoice Line to get orders with a specific Item Type


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.




Please sign in to leave a comment.