User has asked for a query to bring in all revenue for a single location.
Location is not captured at the line level on the invoice and all transactions can be multi-location, so it was suggested to start with the item fulfillment.
I'm close, but some line items are not pulling in the search.
I can't see why that is. Please see Criteria and Results.