Report Gross Sales By Product Tree
From Fishbowl Advanced
This report displays gross sales for a specific product tree or all product tree nodes in a specified timeframe. Returns product tree sales as a percentage of total sales and single product sales as a percentage of the respective tree the product belongs to. This report will only show products that are assigned a product tree category. Inventory, non-inventory, service, and shipping type products will be displayed. Sales tax not included.
The 
Modify Report button allows the following report filters to be customized:
- OPTIONAL TAB
- Product Tree - Select the product tree category to run the report for. Leave this field blank to run for all product tree categories.
- Date Range - Choose a date range to run the report for. This date looks at the PostDate for the Sales Order on the POSTSO table in the database, meaning the date the order is shipped. If you backdate the shipment, it will show up on that date. Partial shipments will show up as separate line items but all parts on the sales order will use the first date shipped.
- Include Credit Return Items - Choose to show/hide credit return items by checking/unchecking this checkbox.
- Show Each Product Once - Choose to only show a product once even if it is in the Product Tree multiple times.
- Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
- Show Data - Choose to show/hide the data page by checking/unchecking this checkbox.
- Show Graphs - Choose to show/hide the graphs page by checking/unchecking this checkbox.
- PRINTER TAB - Allows a default printer to be specified for the report in each location group.