Local Sales Tax Mod (with admin!) for testing

[supersnow]

I'm afraid the actual tax amount from each sale is not stored anywhere at this time, it is a completely calculate number generated on the fly when the order is created or pulled up. I know this is a pain, as a reporting system of some type is needed, but as this is my first module that went beyond what I could tackle.
Its something I have been trying to plan out, but have not had the time to complete as yet.

I wish I had a better answer for you but, for now at least, there just isn't anything.

LadyHLG

Thank you for your reply, at least now I know that I am not going mad. Do you think you will be able to add it to the orders table and store it like the order_tax in the not too distant future? This would be fantastic.

thanks again for a great Mod!!!

[LadyHLG]

I'm afraid its not as simple as putting it into a single field. The mod is specifically designed to allow for multiple taxes, so I am not sure if a single local tax total is sufficient for reporting purposes where more than one local tax is applied (ie - a city tax and a district tax).

However, I did some looking around and it looks like the local tax totals are stored in the orders_total table! Have a look there and see if you can get what you need.

LadyHLG

[supersnow]

I'm afraid its not as simple as putting it into a single field. The mod is specifically designed to allow for multiple taxes, so I am not sure if a single local tax total is sufficient for reporting purposes where more than one local tax is applied (ie - a city tax and a district tax).

However, I did some looking around and it looks like the local tax totals are stored in the orders_total table! Have a look there and see if you can get what you need.

LadyHLG

The order_total table is a messy one huh!

Anyway let me know if you a solution of bringing it through to the orders table as it would make it so much easier to export the orders if I can get it from one table.

If not possible just let me know. Thanks again for your replies.

[LadyHLG]

supersnow and anyone else interested,
I have been working on a very simple sales tax total report, it will be a completely separate mod from the local sales tax mod but will work to pull those sales tax totals as well as any zone tax totals you might have.
I will post it here for anyone to test before posting to the downloads.
The mod itself is very simplistic, it basically totals all the different sales taxes from the orders_total table based on a given date range.

I will post again here when the mod is available for testing, which should hopefully be soon.

LadyHLG

[supersnow]

supersnow and anyone else interested,
I have been working on a very simple sales tax total report, it will be a completely separate mod from the local sales tax mod but will work to pull those sales tax totals as well as any zone tax totals you might have.
I will post it here for anyone to test before posting to the downloads.
The mod itself is very simplistic, it basically totals all the different sales taxes from the orders_total table based on a given date range.

I will post again here when the mod is available for testing, which should hopefully be soon.

LadyHLG

Sounds great look forward to the mod - your are the best!!!

Will the sales tax report be able to to be printed or exported? Only ask as it would be a dream come true to make sales tax report process for to the state that much easier.

[LadyHLG]

As I said the report is very simplistic. A small 2-column table with the tax name and the total tax. The size of the table will depend on how many different taxes you have set up and how many sales you had for those taxes. If I have the time I will see if I can make a print version, but you many not even need it.
Have a good weekend.
LadyHLG

[LadyHLG]

Ok guys,
Here is the simple sales tax summary report mod. As I said previously, this is very simplistic it only gives you totals, but it is at least a place to start.
Please have a look and let me know what you think, I will post it to the downloads after its been tested a while.
The mod is written for Zen 1.3.7 - I have no idea if it will work with other versions, but since it does not overwrite any files it can be easily tested. Just copy the files over to the root of your zen cart maintaining the file structure provided.
This mod will work with or without the Local Sales Tax Mod so it will give you totals for zone and local taxes.

LadyHLG