Business Activity Report 1.5.0 Support Thread

[mooomers]

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.

Hi!

1. I did, but it's still giving me the same error.

2. That would be fantastic!! Anything to make tax time less stressful would be awesome~

The way my taxes are setup in zencart is like this:
Priority Tax Class Zone Tax Rate
1 GST & PST Class Canada GST zone 5%
1 GST & PST Class Ontario PST Zone 8%

does this help?

[seancon1]

i was having a problem with "[INSERT INTO dg_businessTS_detail" and found a customer had an apostrophe in his name,
i corrected it by adding mysql_real_escape_string() to the customers name in the insert query.

changed line 189

$insert = "INSERT INTO dg_businessTS_detail (order_date, orders_id, customers_name, payment_method, subtotal, coupon, discount, tax, shipping, order_total) VALUES ('" . $dataset->fields['orderdate'] . "', " . $dataset->fields['orders_id'] . ", '" . $dataset->fields['customers_name'] . "', '". $dataset->fields['payment_method'] . "', " . $dataset->fields['subtotal'] . ", " . $dataset->fields['coupons'] . ", " . $dataset->fields['discounts'] . ", " . $dataset->fields['tax'] . ", " . $dataset->fields['shipping'] . ", " . $dataset->fields['ordertotal'] . ")";

to

$insert = "INSERT INTO dg_businessTS_detail (order_date, orders_id, customers_name, payment_method, subtotal, coupon, discount, tax, shipping, order_total) VALUES ('" . $dataset->fields['orderdate'] . "', " . $dataset->fields['orders_id'] . ", '" . mysql_real_escape_string($dataset->fields['customers_name']) . "', '". $dataset->fields['payment_method'] . "', " . $dataset->fields['subtotal'] . ", " . $dataset->fields['coupons'] . ", " . $dataset->fields['discounts'] . ", " . $dataset->fields['tax'] . ", " . $dataset->fields['shipping'] . ", " . $dataset->fields['ordertotal'] . ")";

probably should correct this elsewhere so it gets properly inserted, but that's for another post!

hope this helps someone,

Sean

[jcit]

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?

I had this happen when I installed BAR. The problem is that "zen" (default) gets suffixed in MySQL, making the call wrong.

Here's the fix for the basic (zen) install:

In the DG_BusActDetail.php change line 115 from:

$truncate = "TRUNCATE dg_businessTS_detail";

to

$truncate = "TRUNCATE zen_dg_businessTS_detail";

and also do the same on line 189:

$insert = "INSERT INTO zen_dg_businessTS_detail (order_date, orders_id, customers_name, payment_method, subtotal, coupon, discount, tax, shipping, order_total) VALUES ('" . $dataset->fields['orderdate'] . "', " . $dataset->fields['orders_id'] . ", '" . $dataset->fields['customers_name'] . "', '". $dataset->fields['payment_method'] . "', " . $dataset->fields['subtotal'] . ", " . $dataset->fields['coupons'] . ", " . $dataset->fields['discounts'] . ", " . $dataset->fields['tax'] . ", " . $dataset->fields['shipping'] . ", " . $dataset->fields['ordertotal'] . ")";

Cheers.

[shartlesville]

Also, is there an uninstall proceedure?

There are no file overwrites so you could just delete them and then look at the new table that was added and perform a "Drop Table" query in the DB

Or if you did a backup first (as it says you should, ) you could just reinstall the backup version.

Blessings,
Krisann

[gharls]

My apologies for the delay in response. I no longer support this product, yet I will research your issues.

[gharls]

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

One generally cannot experience a division by 0 error in this part of the report unless there is no sales data at all for the date range entered. A very inelegant error message, I admit, and I will address in the new version due soon.

[busintellsol99]

Busintellsol provides a full scope of regulatory software solutions and professional services that help FDA regulated companies improve compliance outcomes and reduce regulatory costs.

[abcisme]

I have the quantity discount module set up in order totals.

The business detail report is not showing this discount, so the tax is coming up incorrect in the report.

For example -

Net 123.63
Coupon (2.47)
Discount (0.00) < - should be 3.71
Tax 6.06 < - should be 5.87
Ship 47.81
All-In 171.13

Anyone have any ideas on how to correct this?

[abcisme]

I have the quantity discount module set up in order totals.

The business detail report is not showing this discount, so the tax is coming up incorrect in the report.

For example -

Net 123.63
Coupon (2.47)
Discount (0.00) < - should be 3.71
Tax 6.06 < - should be 5.87
Ship 47.81
All-In 171.13

Anyone have any ideas on how to correct this?

Well, I decided to switch to group discounts instead of using quantity discounts. So my report totals are coming up correctly now. Would still be nice to know how to add in quantity discounts module though...

Have a question about adding a column to the report. Is it possible to add a shipping status column?

[abcisme]

I know I probably won't get an answer, but this is making me crazy. I have it running on a test site, which is a clone of my live site and it's working perfectly. On the live site, the coupon discount and group discount aren't showing up in the report. They're coming up zero. Losing my mind with this!