Community Add-Ons

The previous patch (fixed for MySQL 4.0.x)

with added support for Tax Subtotals.
(the original version doesn't display properly order totals as it doesn't take into account Taxes)

after installing the original contribution, please replace stats_detailed_monthly_sales.php in /catalog/admin/

add the following line to
/catalog/admin/includes/languages/english/stats_detailed_monthly_sales.php

define('TABLE_HEADING_TOTAL_TAX','Tax');

The original contribution was failing on MySQL 4.0.X. I had to replace the nested queries with joins.

You have to replace only stats_detailed_monthly_sales.php
in /catalog/admin

Nick

The install was missing the line for the english.php file.

in addition there was a duplicate file in the language file. it doesn't need to be uploaded.

*** UPDATED ***
I forgot to include a file.

"Detailed Monthly Sales" is a report that starts by breaking the orders up into months, grouped by years, listed in descending order, as well as listing Net Sales, Shipping/Handling, and Gross Sales amounts. From there it allows you to drill down to all the orders for a specific month, again, listed in descending order, and shows you the Order #, Customer's Name, Order Date, Order Subtotal, Shipping Total, and Order Total. Once at this screen, you can view a printer friendly version of the report or the original invoice (both opened in new windows).