Start a new topic

Report/Query to find all parts sold to a client

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.

1 Comment

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?

(61.9 KB)
Login or Signup to post a comment