
Greetings Everyone,
I have made a custom report that lists:
item / sum quantity / sum amount excl vat / sum of some custom params
It looks a lot like the standard customer item/sales report.
However, I had to base it on the posted invoices, as a lot of the data i use, is not available in the item value, used by that standard report.
The issue i now face is that it is not substracting credit notes, because of that.
So, is there any way to join the sales credit memo lines table with sales invoice lines table in my report please?
Cheers