The Consolidated Sales Analysis report groups sales by Department Category and Product ID to show sales across Locations. An advantage of this report is it automatically includes Products with identical Product IDs and Department Categories when only selecting the Product from one Location.
The Consolidated Sales Analysis report is found at Accounting Reports / Accounts Receivable / Sales.
This report has three Sort By options:
- Product Across Loc – This groups the Products to show each Department’s total sales and a grand total for the Product across Locations. Checking or unchecking Show Detail determines the amount of detail displayed on the report.
- Consolidated – This option displays totals by Product consolidated across Locations and grand totals for the Department Category.
- Customer by Product – Sales are grouped by Customer first and then Product to give a view of sales across Locations. Show Detail is also available with this option.
