Before BREWW I would run a weekly sales report detailing the total of each product invoiced the week prior grouping firkins, pins, kegs etc per beer. then how many of each by customer group and including the sales value.
I cant see how to attach an example of the old the report but to explain it, it would tell me -
Id sold 100 firkins of Beer XXX
50 sold to trade customers
25 to key account group XXX
25 to SIBA
the total sales value of the 100 firkins
And so one for each beer
Could a similar report be built?