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?

example.JPG
(61.9 KB)
Login or Signup to post a comment