Monthly Sales and Tax Summary Report [support thread]

Edit the file /YOUR_ADMIN/includes/languages/english/stats_monthly_sales.php, finding this block:

Code:

---

//-bof-a-lat9
//  Identifies whether the Shipping & Handling values are to be merged into the overall totals, one of:
//  - auto ... (default) S/H charges added to taxed/untaxed totals based on whether shipping is taxed for the store (i.e. sort order of "Tax" order total is greater than that of "Shipping").
//  - on ..... S/H charges added to taxed/untaxed totals *regardless* of store's Order Totals settings
//  - off .... S/H charges kept separate from taxed/untaxed totals *regardless* of store's Order Totals settings
define('STATS_MONTHLY_SALES_COMBINE_SHIPPING', 'auto');

---

For your store, set the value to 'off'.

Just updated this mod to provide 1.3.9 compatibility.

Thanks, swguy!

Thank YOU for all the great work you did on this mod. It's a very nice addition.

Quote:

---

Originally Posted by swguy

Just updated this mod to provide 1.3.9 compatibility.

---

Ummm - 1.5.3 compatibility ?

Quote:

---

Originally Posted by frank18

Ummm - 1.5.3 compatibility ?

---

Nope, swguy re-added ZC v1.3.9 compatibility, which I'd removed in my update. The plugin is now compatible with ZC 1.3.9, 1.5.0, 1.5.1, 1.5.2 and 1.5.3.

Quote:

---

Originally Posted by lat9

Nope, swguy re-added ZC v1.3.9 compatibility, which I'd removed in my update. The plugin is now compatible with ZC 1.3.9, 1.5.0, 1.5.1, 1.5.2 and 1.5.3.

---

Stupid me! I mis-read that :blush:

Hi, can any help me?
I have twitch base cost plugin installed, how do i display the base cost in the report, i know subtracting from product sales will be complicated so i just want to display it there and subtract it manually myself.....

@Huang, why not post in Twitch's forum for the base cost mod and ask him to add it as an option to one of the sales reports. (It could be this one or another one.)

Environment: A new 1.5.4 site with display logs, encrypted master password, inventory report, and monthly sales installed in the admin.

When I select a state and then click on Filter, everything works well. If I then select a status other than all orders, I get the following debug.

Quote:

---

[06-Jan-2015 23:56:45 UTC] #1 trigger_error() called at [/home/enigjohn/public_html/enl154/includes/classes/db/mysql/query_factory.php:155]
#2 queryFactory->show_error() called at [/home/enigjohn/public_html/enl154/includes/classes/db/mysql/query_factory.php:132]
#3 queryFactory->set_error() called at [/home/enigjohn/public_html/enl154/includes/classes/db/mysql/query_factory.php:262]
#4 queryFactory->Execute() called at [/home/enigjohn/public_html/enl154/newenl154/stats_monthly_sales.php:292]

[06-Jan-2015 23:56:45 UTC] PHP Fatal error: 1054:Unknown column 'o.delivery_state' in 'where clause' :: SELECT orders_status_name from orders_status WHERE language_id = '' AND orders_status_id =3 AND (o.delivery_state LIKE 'Texas') ==> (as called by) /home/enigjohn/public_html/enl154/newenl154/stats_monthly_sales.php on line 292 <== in /home/enigjohn/public_html/enl154/includes/classes/db/mysql/query_factory.php on line 155

---

Possibly 1.5.4?