I want something that will give me all the parts sold to a client.
The query in english would be something like:
Select "Part%", Qty, Doc No where document type is an order and sold to company is "name%"
The results of the query would be good enough for me. Don't need it as a report. Honestly if I could export the search for quoted items search results somehow I'd be able to get the data with filters in excel.
This would be a fairly straightforward report to create, although these things are often easier to do than to explain.
Are you looking for all parts, or just a specific one each time (like would you enter a SKU)?
Something like the attached?