Business Activity Report 1.5.0 Support Thread

[EhKho]

Old database added to new installation of ZenCart Version: 1.3.8
Mods installed: Admin Profiles and Business Activity Report
Custom template

Warning: Division by zero in /home/USERNAME*/public_html/igotluckyskraps.com/ADMINFOLDER*/DG_BusActivity.php on line 204

*changed here for obvious reasons lol

The problem started on the very first search.

Also, is there an uninstall proceedure?

Thanks

[mooomers]

1.
i'm probably not doing something right. i got the business activity to installed, and when i click on the 'details' button, i get this on the page :

Records Displayed Below are Stored in Database Table "dg_businessTS_detail"
1146 Table 'yabycosm_zc1.dg_businessTS_detail' doesn't exist
in:
[TRUNCATE dg_businessTS_detail]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


does that mean i didn't install the module correctly?



2.
For account and tax purposes, i actually need the report to show the taxes separately. Here in canada we have 2 taxes and my accountant needs to see them as separate colums as they filed separately. Is there a way to do that?


thanks!

[dkhoward]

I got the same error when trying to view the details. Evidently there is a mistake in the SQL script that creates the new datafiles. I can't find it.

HEY GHARLS. You listening guy!? We need a little help here.

[shartlesville]

I installed and it works but it shows $0.00 tax and $0.00 coupons no matter what the timeframe and I know several have used coupons and many paid tax. Any idea why it isn't picking up that info?

Thanks!

Blessings,
Krisann

[gharls]

I installed and it works but it shows $0.00 tax and $0.00 coupons no matter what the timeframe and I know several have used coupons and many paid tax. Any idea why it isn't picking up that info?

Thanks!

Blessings,
Krisann

Your case sounds the most baffling ... based on the SELECT SQL that resides behind the report, it's 'supposedly' impossible not to pick up tax on the order line.

First things first ... do you know how to use SQL against your database? (We can also communicate via e-mail; I'm at [email protected]).

[shartlesville]

Your case sounds the most baffling ... based on the SELECT SQL that resides behind the report, it's 'supposedly' impossible not to pick up tax on the order line.

First things first ... do you know how to use SQL against your database? (We can also communicate via e-mail; I'm at [email protected]).

I can do basic stuff what did you have in mind?

I mean, I can copy, paste, and click 'go' I can also usually search through to find what I'm looking for if I know approximately what table something should be in.

I am running zcv1.3.8a in case it matters. :-)

[gharls]

I can do basic stuff what did you have in mind?

I mean, I can copy, paste, and click 'go' I can also usually search through to find what I'm looking for if I know approximately what table something should be in.

I am running zcv1.3.8a in case it matters. :-)

If not too much a bother, would you please cut and paste the following SQL statement into your phpAdmin query tool for your database, hit the GO button, and then send me a picture of your query results. I'm at [email protected].


SELECT date(a.date_purchased) orderdate, count(a.orders_id) ordercount, max(b.value) ordermax, sum(round(b.value, 2)) subtotal, IFNULL(sum(round(c.value, 2)),0) coupons, IFNULL(sum(round(d.value, 2)),0) discounts, sum(round(a.order_tax, 2)) tax, IFNULL(sum(round(e.value, 2)),0) shipping, sum(a.order_total) ordertotal FROM orders a JOIN orders_total b ON a.orders_id=b.orders_id AND b.class='ot_subtotal' LEFT JOIN orders_total c ON a.orders_id=c.orders_id AND c.class='ot_coupon' LEFT JOIN orders_total d ON a.orders_id=d.orders_id AND d.class='ot_gv' LEFT JOIN orders_total e ON a.orders_id=e.orders_id AND e.class='ot_shipping' WHERE date_purchased >= '2009-01-01' AND date_purchased < DATE_ADD('2009-07-31', INTERVAL 1 DAY) GROUP BY orderdate

Thanks.

[gharls]

I got the same error when trying to view the details. Evidently there is a mistake in the SQL script that creates the new datafiles. I can't find it.

HEY GHARLS. You listening guy!? We need a little help here.

Easy does it ... we're all very busy and sometimes items slip past me from time to time.

Could you please relate to me the message that you see when you run the script within the Install SQL Patches module?

[gharls]

1.
i'm probably not doing something right. i got the business activity to installed, and when i click on the 'details' button, i get this on the page :

Records Displayed Below are Stored in Database Table "dg_businessTS_detail"
1146 Table 'yabycosm_zc1.dg_businessTS_detail' doesn't exist
in:
[TRUNCATE dg_businessTS_detail]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


does that mean i didn't install the module correctly?



2.
For account and tax purposes, i actually need the report to show the taxes separately. Here in canada we have 2 taxes and my accountant needs to see them as separate colums as they filed separately. Is there a way to do that?


thanks!

1. You must execute the SQL script that comes with the report. Instructions can be found in the README file.

2. Is your Zen Cart customized to separately capture and store both tax amounts? If so, I can perhaps give you a suggestion as to how to modify the report code to include both ... redesigning the report layout will be a messy job.

[rleepac]

[QUOTE=gharls;756315]1. You must execute the SQL script that comes with the report. Instructions can be found in the README file.


I'm having the same problem. When I hit Detail I get a message that the dg_businessTS_detail table doesn't exist.

I've run the SQL. I've checked in my SQL and the table is there but it's empty.

What am I doing wrong? Or more importantly....how do I fix it?

Anyone's help is appreciated here. In the meantime I'm going to remove all the files and start over again. I'll post if that works...

Thanks!
Bekah