What I want to know is the following:
How many of a particular product did a specific customer buy from me.
OR, how many of a particular product group did a specific customer group buy.
If possible I want to know how much the total value of those purchases were (if selling prices were different).
Is there, with or without the use of an external reporting application, a way of doing this reporting without having to look at all of the invoices one by one?
Thank you in advance.
I would suggest “Toad for MySql” it’s really a good help for designing Mysql queries (ammong many other things you can do with this tool)
you can design your own queries filtering anything you need… but it means some knowledge on mysql and it’s a programming tool.
having the queries designed and tested you can:
1)use the included repport generation tool or…
2)copy query structure and create your own php code for a particular or specific repport…or
3)modify repports inside dolibarr
Hope this could help.
Ale
