Monthly Sales and Tax Summary Report [support thread]

[skipwater]

Hi,

I have duplicated my core files into another site and this mod is amongst them, I would like to know If I can zero the figures for the new business.

Can it be done in anyway or is it an overwrite of the mod with.

Cheers

RR

The report data comes from the orders and orders_total tables of your database. So if your new business site started with a clean database there should be no values.

Skip

[JoeZ]

Hello,
I have this mod installed that figures out profit:
http://www.zen-cart.com/index.php?ma...roducts_id=278

Any way you can take a look and see if it is possilble to add a profit column to your mod? It'd be great to show Tax collected, Gross Sales, and Gross Profit all on the same page, separated by Month and Year like you have.

Great mod, btw!

[skipwater]

Hello,
I have this mod installed that figures out profit:
http://www.zen-cart.com/index.php?ma...roducts_id=278

Any way you can take a look and see if it is possilble to add a profit column to your mod? It'd be great to show Tax collected, Gross Sales, and Gross Profit all on the same page, separated by Month and Year like you have.

Great mod, btw!

With ZC 2.0 coming out and the profit mod over writing core files. Adding this option is not something that I want to do.
Can it be done YES.

Skip

[anita]

Does anyone know if this works with 1.3.9 and PHP 5.3?

[skipwater]

Does anyone know if this works with 1.3.9 and PHP 5.3?

Yes all 1.3.x and php 5.3

Skip

[dkeil]

I'm sure I'm missing something really obvious as I'm relatively new to Zen Cart. I've installed the files for this addon but their not showing up under the reports menu.

I have successfully installed a couple of shipping modules, COWOA so I'm not quite that green... but green enough apparently.

I did put them in their respective folders in the admin file on my server.

I'm running 1.3.9h

I've spent more than a couple of hours looking for a thread. Thanks for any help,
David

[skipwater]

I'm sure I'm missing something really obvious as I'm relatively new to Zen Cart. I've installed the files for this addon but their not showing up under the reports menu.

I have successfully installed a couple of shipping modules, COWOA so I'm not quite that green... but green enough apparently.

I did put them in their respective folders in the admin file on my server.

I'm running 1.3.9h

I've spent more than a couple of hours looking for a thread. Thanks for any help,
David

It sounds like you have not renamed the mods admin folder to match the admin folder that you are using on your site.

Double check that the mods files where uploaded to there correct folders.

Skip

[dkeil]

Thank you Skip,

I'm still wrapping my head around the file structure. I haven't renamed my folders, except for my template. So I assumed that the files would go in the admin folder and structure on the server. But because of your post I took a closer look at the actual address of my admin section and realized I wasn't looking at my admin directory but instead my manage directory. Moved the files and of course, they showed up in my admin section.

Thanks,
David

[jcun45]

Hi, like the mod so far, however, I have two tax classes for the netherlands, one at 6% and the other at 19%. Both tax classes are installed properly (they work fine when items are sold) however when using your mod I only see a total tax collected. When I click on the "tax" number to get the details I get something like this:

2010/12

: 1,658.50



Only showing the amount but not listing the tax classes. Also, this number is considerable lower than the actual taxes collected (the number I clicked on). I really would love this to work so I can stop paying the tax office 19% on things I charged only 6% for! Can you direct me on where to look for the error? Does this have something to do with the mod? I imagine I have overlooked something...

I am using 1.3.9f

Any help would be greatly appriciated.

Cheers,
jeff

[skipwater]

Hi, like the mod so far, however, I have two tax classes for the netherlands, one at 6% and the other at 19%. Both tax classes are installed properly (they work fine when items are sold) however when using your mod I only see a total tax collected. When I click on the "tax" number to get the details I get something like this:

2010/12 : 1,658.50

Only showing the amount but not listing the tax classes. Also, this number is considerable lower than the actual taxes collected (the number I clicked on). I really would love this to work so I can stop paying the tax office 19% on things I charged only 6% for! Can you direct me on where to look for the error? Does this have something to do with the mod? I imagine I have overlooked something...

I am using 1.3.9f

Any help would be greatly appriciated.

Cheers,
jeff

Look at your
table orders_total

orders_total_id ... orders_id .. title .................... text .......... value ... class ....... sort_order
67  ............... 20050 ...... Sub-Total: ............... $30.00 ........ 30.0000 . ot_subtotal . 1
68  ............... 20050 ...... UPS (1 x 26.4lbs) (Ground) $13.01 ........ 13.0100 . ot_shipping . 2
69  ............... 20050 ...... TAX 4.5%: ...............  $1.35 .........  1.3500 . ot_tax ...... 3
70  ............... 20050 ...... Total: ................... <b>$44.36</b> . 44.3600 . ot_total .... 4

How are you storing the %6 tax and the 19% tax is there another class? And if so what is its name.

If you look in admin/stats_monthly_sales.php you will find queries getting the class info and you most likely have a class name unknown to this mod.

Skip