Monthly Sales and Tax Summary Report [support thread]

**barco57** · 31 Aug 2008, 08:58 PM

well doing that does provide an end around to the fact the dropdown isn't populating but on clients site I can hear the whining already....I have one client with 12 statuses......not that he needs all of them but who am I to tell him any different......

**skipwater** · 31 Aug 2008, 09:18 PM

Well it looks like there is a conflict in the code.
I have changed the drop down code in this file let me know if it works.

**Merlinpa1969** · 31 Aug 2008, 09:38 PM

Skip,
the code that was in the file did not work properly,

However im sure Barco will send you the corrected file....

**barco57** · 31 Aug 2008, 09:44 PM

Ok here is what we have and works like a champ

**skipwater** · 31 Aug 2008, 10:01 PM

Thanks for the help I need to get better at looking at code.

Skip

**Elarya** · 2 Sep 2008, 06:57 PM

Which one of these would be the latest file to download? The one in the original post (was it updated) or one of the others? Thank you!

**barco57** · 2 Sep 2008, 07:03 PM

The one in my post is just one of the files that needed to be adjusted. I don't know if the whole module is being updated or not.

**skipwater** · 2 Sep 2008, 07:46 PM

Verision 1.3 has barco57 update
http://www.zen-cart.com/index.php?ma...oducts_id=1043

**Elarya** · 2 Sep 2008, 08:47 PM

Thank you to both of you! Wish me luck installing it :)

**fyzer** · 25 Sep 2008, 06:33 PM

This seems like a great module, I love modules that don't make you edit any of the files. One problem, I'm getting inaccurate tax totals.

I'm guessing this is because I'm using the local sales tax module
http://www.zen-cart.com/index.php?ma...roducts_id=623

for example;
I have 3 local taxes and a state tax that gets collected.

My "total" for the month is $3.90 on the main report page

When I click that total to get a detailed report, I see my local taxes;
(// entry for popup display of tax detail
// show=ot_tax )

0.08 - local
0.04 - local
0.07 - local
5.97 - state

So I'm not sure where the $3.90 total is coming from, it looks like the query is selecting only the standard sales tax.
around line 446
// Retrieve totals for products that are NOT zero VAT rated
I'm not sure how to setup the correct query for this at the moment.

I'm using this for tax tracking for now;
http://www.zen-cart.com/index.php?ma...roducts_id=768