Monthly Sales and Tax Summary Report [support thread]

[mprough]

I don't have a SQL 5.7 environment to solve this right now

[swguy]

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.Possibly 1.5.4?

OK I would guess that in stats_monthly_sales.php" line 292 you should remove the appending of $zone_only_sql to the query. This references fields in the orders table, and the query on line 192 is only against the orders status table.

[Speak394]

Version 1.5.4.

Have been using this for a while and love it. Now I need to add something to it. I have a field in my products table called products_vendor_code. I need to add this to the report. I know the report comes from the orders table. How do I add this new info from the products table?

[twitchtoo]

Version 1.5.4.

Have been using this for a while and love it. Now I need to add something to it. I have a field in my products table called products_vendor_code. I need to add this to the report. I know the report comes from the orders table. How do I add this new info from the products table?

If the products_vendor_code is stored in the orders table already you can simply add it to the lookup and publish the data the way the report publishes data. If you need to make a new column be certain to add the heading row and data row separately.

[swguy]

This data is product based I assume, right? Since Monthly Sales and Tax Summary Report is order based, you might want to look at Sales Report or another mod that does product based breakdown. (Unless you can aggregate the vendor data in a way that makes sense per order.)

[marton_1]

I seem to have done something stupid.
This plugin has been working well for years but last week I no longer had the Admin->Reports>Monthly Sales.

I uploaded the plugin files again, no change.

There is nothing in my logs.

The entry in DB table admin_pages looks OK, see screenshot.

I must have changed something but I have no idea what? I test changes in my test site before uploading and my test site monthly sales is still working OK.

The only recent change is I added an EAN coumn to the DB table products.

[DrByte]

Admin menu options don't show if the language-defines are missing.
Check whether you've deleted its language file. Or, for that matter, check that you haven't deleted a bunch of other stuff too.

[marton_1]

Admin menu options don't show if the language-defines are missing.
Check whether you've deleted its language file. Or, for that matter, check that you haven't deleted a bunch of other stuff too.

Thanks.
I deleted this plugin in my live site including deleting the entry in DB table admin_pages and reloaded the plugin.
It recreated the entry in DB table admin_pages OK but still not showing up Admin->Reports>Monthly Sales.
Language defines are there for both languages on my site.

Other plugin admin options are showing up OK like "Recovered Sales Results".

Is there anything else obvious that blocks admin options showing up?

[marton_1]

Just noticed I have the Admin->Reports>Monthly Sales on my smartphone and tablet but not in my computer.
I can live with that but it would be nice to fix.

[DrByte]

Just noticed I have the Admin->Reports>Monthly Sales on my smartphone and tablet but not in my computer.

Are you logged in as a different Admin user, which uses an admin profile with different privileges?