Monthly Sales and Tax Summary Report [support thread]

[lat9]

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/

[swguy]

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

[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?

[lat9]

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.

[planetjune]

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.

[lat9]

No progress, but you've reminded me!

[planetjune]

Thanks!

[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?

[lat9]

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.

[planetjune]

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 :)