Report Compare Sales By Month
From Fishbowl Advanced
This report generates a report to compare sales by month per item. This report includes products that are inventory, non-inventory, shipping, and service type products. The price listed is total price the product has been sold for on all orders in that date range. Sales tax is not included.
The
Modify Report button allows the following report filters to be customized:
- OPTIONAL TAB
- Location Group - Choose a specific location group to run the report for. Leave this field blank to run for all location groups.
- Last Month - Select the first month date range to use in the comparison. 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.
- This Month - Select the second month date range to user in the comparison. 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.
- Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
- PRINTER TAB - Allows a default printer to be specified for the report in each location group.
