Monthly Sales and Tax Summary Report [support thread]

WiccanWitch420:

I have zen cart version info:
Zen Cart 1.5.5d
Database Patch Level: 1.5.5
v1.5.5a [2016-05-30 17:05:28] (Version Update 1.5.4->1.5.5a)
v1.5.4 [2015-02-18 04:55:48] (New Installation)
v1.5.4 [2015-02-18 04:55:48] (New Installation)

PHP Version: 5.6.40 (Zend: 2.6.0)
Database: MySQL 5.5.62-cll

And I wanted to know if I can install the newest version of this plug in, or if I need to install the one that is for 1.5.5? Please let me know, thank you.
The newest version requires zc157+, so you'll need to install an older version.

I've just submitted v2.0.3 of the "Monthly Sales and Tax" report for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes to correct the following GitHub issues:

#7: Correct strict MySQL 5.7 fatal error
#8: Correct PHP notices for missing totals in a given timeframe.

lat9:

I've just submitted v2.0.3 of the "Monthly Sales and Tax" report for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes to correct the following GitHub issues:

#7: Correct strict MySQL 5.7 fatal error
#8: Correct PHP notices for missing totals in a given timeframe.
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=734

Zen cart 1.5.7d PHP 7.4
Can someone tell me why this is happening with the version V2.0.3 previous version worked well. Months and days all over the place . Thanks

Thanks for the report; see this GitHub issue for the root-cause (https://github.com/lat9/monthly_sales_and_tax/issues/9). v2.0.4 coming shortly.

v2.0.4 has been submitted for the Zen Cart moderators' review.

This release corrects the dates' sorting by gathering the dates using 2-digit months and days; see GitHub issue #9.

@lat9
Brilliant thanks that fixed the issue, originally thought I had done something wrong in the language/english file..

@lat9
I have noticed that refunds are not removed from the sales value is it possible to add this?

ianhg:

@lat9
I have noticed that refunds are not removed from the sales value is it possible to add this?
Refunding is a payment-method-specific process. I'll consider adding a couple of notifications to enable that addition.

GitHub issue for tracking: https://github.com/lat9/monthly_sales_and_tax/issues/10

Cindy, older versions of this module had the ability to filter not just by order status but by zone as well - is this something you'd be willing to add back in?

swguy:

Cindy, older versions of this module had the ability to filter not just by order status but by zone as well - is this something you'd be willing to add back in?
@swguy, I'll give it a look. That might have been in a one-off (not captured in GitHub) update. Please open an issue on https://github.com/lat9/monthly_sales_and_tax/

Done. https://github.com/lat9/monthly_sales_and_tax/issues/11

hi @lat9! When I export to a CSV and tick the "Output Order Total Validation Column" checkbox, this column is not present in the CSV. What could be wrong?

lolwaut:

hi @lat9! When I export to a CSV and tick the "Output Order Total Validation Column" checkbox, this column is not present in the CSV. What could be wrong?
You have this report confused with the "Sales Report" (https://www.zen-cart.com/downloads.php?do=file&id=9).

Noting that the "Order Total Validation" column for that report is a display-only output, since the CSV can be customized using your spreadsheet tool to provide a similar function.

Just wondering if there's been any progress on adding 'filter by zone' back into this plugin? I've been using the older 1.5.4 version of this plugin to split my sales by province so I can report the correct amount of tax I collected for each province. I'm really missing this feature in the new version, and I'd love it if it could be added back in.

No progress, but you've reminded me!

Thanks!

Have been using this report for years but just recently noticed some of my months showing zero sales. I was running v1.5.4 of the report on zencart 1.5.7c when this happened. This morning I updated to 2.0.4. Now the report shows sales for each month in the main overall summary however if I click on individual months some show "NO INCOME FOR THIS DATE/STATUS SELECTION" even though the main overall page does report income. Some individual months work fine. Also some months show items under Untaxed Sales with something like 12 digits after the decimal point (example 2408.7200000000003 ). I had not made any changes to my cart system in some time. This is under php 7.3.33 according to my site cp. After further investigation I just realized that my host upgraded to mysql 8 today. I suspect 2.0.4 has some compatibility problem. Any ideas?

spyderrobotics:

Have been using this report for years but just recently noticed some of my months showing zero sales. I was running v1.5.4 of the report on zencart 1.5.7c when this happened. This morning I updated to 2.0.4. Now the report shows sales for each month in the main overall summary however if I click on individual months some show "NO INCOME FOR THIS DATE/STATUS SELECTION" even though the main overall page does report income. Some individual months work fine. Also some months show items under Untaxed Sales with something like 12 digits after the decimal point (example 2408.7200000000003 ). I had not made any changes to my cart system in some time. This is under php 7.3.33 according to my site cp. After further investigation I just realized that my host upgraded to mysql 8 today. I suspect 2.0.4 has some compatibility problem. Any ideas?
Too many plugins, too little time. This is on my list, but others (and clients) take precedence.

Hi Cindy, I just wanted to let you know that I've hacked together a SQL query outside ZC that gives me what I need for my tax reporting without using this plugin, so you can take 'reinstate the filter by zone ability' off your to-do list, if it was just there because of me! Thanks :)