Report TPS Report
From Fishbowl Advanced
This report generates a list of gross sales for the date range specified, ordered from greatest to least. An empty date range will report on gross sales to date. T.P.S. stands for Total Product Sales.
The 
Modify Report button allows the following report filters to be customized:
- OPTIONAL TAB
- Date Range - Choose a date range to run the report for. The date range looks at the DateLastFulfillment on the SOITEM table in the database, meaning, if a line item with a quantity greater than 1 is partially shipped, the most recent fulfilled date (when a partial quantity was shipped) is what will be used for all quantity fulfilled so far. Backdated shipments will show up correctly. Partial shipments of a specific product will show up on the latest fulfilled/shipped date for that item.
- Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
- Include Cover Sheet - Choose to show/hide the cover sheet by checking/unchecking this checkbox.
- PRINTER TAB - Allows a default printer to be specified for the report in each location group.