Hi Andrew
Turns out that client showed me up and suggested a way to do it that I would have never thought of - through the Ledger!!
The Ledger keeps monthly/annual statistics on sales and cost of sales by location, assuming the IC location is defined to point to a department. That's what the net activity figures are.
So I am going to use either GridView or Financial Reporter to give him exactly what he needs.
Regards
Steve