Monthly Sales and Tax Summary Report [support thread]

[mooomers]

Hi Skip,
the link is
http://www.yabycosmetics.com/admin/s...thly_sales.php

[skipwater]

The first thing you need to do is rename your admin and install the new patch http://www.zen-cart.com/forum/showthread.php?t=130161.
You also should subscribe to the Zen Cart Release Announcements so you can keep up with patches.

As for the 404 that is the correct file name.

But at this time I think it is more important that you up date your site first. and then get back to this.

Skip

[mooomers]

i changed the permission to 644 and now it all seems good!

i'm now trying to figure out the admin security patch situation. Thanks for letting me know abt this!

[mooomers]

i do have a question about the report though, some columns addup and some don't seem to..

using this one line as an example:

Month	Year	Gross Income	Product sales	Nontaxed sales	Taxed sales	Taxes collected	Shipping & Handling	Tax on shipping	Gift Vouchers

Jul	2007	  1394.07	     1278	     827.35  	  450.65	      49.58           138.83	              1.3	     73.64

product sale + taxes and shipping - discounts doesn't add up to the gross. am i missing something?


thx.

[skipwater]

i do have a question about the report though, some columns addup and some don't seem to..

using this one line as an example:

Month	Year	Gross Income	Product sales	Nontaxed sales	Taxed sales	Taxes collected	Shipping & Handling	Tax on shipping	Gift Vouchers

Jul	2007	  1394.07	     1278	     827.35  	  450.65	      49.58           138.83	              1.3	     73.64

product sale + taxes and shipping - discounts doesn't add up to the gross. am i missing something?


thx.

Now you want me to be a accountant

Belive it or not that infomation is correct:

gross income = 1394.07
product sold = 1278.00
-------------------------------
difference = 116.07

non tax items = 827.35
tax items = 450.65
------------------------------
total = 1278.00 same as product sold

Taxes collected = 49.58
shipping = 138.83
ship taxes = 1.30
----------------------------------
tax ship total = 189.71

So we have a difference in gross monies and product sales

tax ship total = 189.71
difference = 116.07
--------------------------
Gift Vouchers 73.64

You now have a balance of $0.00

Don't make be do that again

Skip

[mooomers]

oh duh i posted an example that worked out!! but thank you for showing me the calculations anyway!!

so some of the lines come out with a difference of a dollar and some, like this year's ytd is already off by about $75.

i'm just very confused why some rows don't add up.

[Martin Smith]

I uploaded all the files.....includes to the includes file .

Uploaded Stats_monthly_sales php to admin file.

I do not have a box at the bottom of admin reports to run the report.

What did I miss ?

www.centraltrailer.com

Thanks,
Martin

[skipwater]

You have this file
admin/includes/boxes/extra_boxes/stats_monthly_sales_reports_dhtml.php ?

Did you rename your admin?

Skip

[Martin Smith]

That file is in the includes file as you listed.

My admin is cart.

Any other ideas ?

Martin

[skipwater]

That file is in the includes file as you listed.

My admin is cart.

Any other ideas ?

Martin

OK your zen cart store root is centraltrailer.com/cart but that is not your admin folder.

The file should be centraltrailer.com/cart/admin/includes/boxes/extra_boxes/stats_monthly_sales_reports_dhtml.php.

But you should have renamed your admin folder per- new patch http://www.zen-cart.com/forum/showthread.php?t=130161.

If so the path would be what ever you changed admin too.
centraltrailer.com/cart/??????/includes/boxes/extra_boxes/stats_monthly_sales_reports_dhtml.php

Skip