The problem is that the Department Sales match the Department Income. Which is fine if a user can only run in one department - which is usually the case.
Sales should always reflect the total products sold for that department - never income received.
Income should always reflect the total payments received by that department - never sales made.
User sales shows the performance of a user, and the total of all users should equal total income. Because a user can move between departments, you can not accurately use them for tracking sales and/or incomes - it has to be by departments.
Even if you own the whole business, you still need department breakdowns by sales & income. The way it currently is, you will never balance the cash drawers within a department - you have to balance the site.
I don't think product tags are the answer (but they will help). I think it is the way the report is generated is the issue.
There are only two scenarios.
1. Sales solely within one department
2. Cross selling between departments.
If you don't cross sell, then there is no issue with the reports.
If you do cross sell, then you need to track why the Bar cash drawer is down compared to the report, and why the Restaurant cash drawer is up.
John, Your request perfectly fits to your situation but for other type of businesses that difference between sales an income amounts might create questions. I think we should leave it as is.
If businesses are cross selling like our situation, then I think they will have the same issues as me.
I think it is the logic in the report calculations that are the issue - and it only shows up in my situation.
I have discussed this with a couple of managers, and they can not understand the calculations.
Simply put - I think there is an error in the WPR calculations when a ticket has products from more than one department.