Overview of products ordered by one customer

Using my Dolibarr
1

Hi there!

is there a way to display a table of products ordered by one customer (no matter when)? i.e. something like this as a result:

Cust#1:

Product 1: quantity
Product 2: quantity
Product 3: quantity
…

sum all products

It’d already suffice if I could have an SQL statement giving me this information but I can’t find my way through all the tables and I am lacking expert SQL knowledge.

Thanks for your support!

msrleloup

2

yes i need this report too

3

+1!

4

Hi, if you want to make a table of sums of total products, its hard to html format but if you want that on ODT you can use ODT spreadsheet and use the SUM function of Openoffice/libreoffice

5

Hi!

thanks for your input. In fact I could live without the sum but I don’t even succeed in having the table since I need to link more than 3 tables in the same SQL-statement to have the information. Any idea on how the SQL statement should look?

6

A feature resuqtes has been added into tracker for report.