cybershieldms - Oh I see.
I'm totally up for you to take a stab at it, but it's not really "reporting" - the data isn't even there in the first place.
An Invoice looks at the tables invoices
and invoice_items
. The invoice category is tracked in the invoices
table. When items are added (either manually or when copied from a product, they get added into invoice_items
.
We'd need to add a column in invoice_items
to track either the original product, or the product category, or both. Then we could adjust reports to show Invoice by Category and Invoiced Item by Category.
-
Out of interest, how are you going to be billing usage?