Strange handling of tax with a discount

[rbenditt]

Hello,

I'm having some trouble with the Store Manager's order calculations. I have an order for $69.00 + 9.25% tax. After receiving this order, I attempted to put in a discount in the amount of $33.30. The tax that is computed comes out to $3.02. It seems to me that it should be: (69.00 - 33.30) * .0925 = 3.30.

Here is what I have in my Order Calculations dialog box:

"Subtotal" (ot_subtotal): sum_final_price
"Tax" (ot_tax): (sum_final_price - [ot_discount, 0.0] - [ot_coupon, 0.0]) * average_products_tax
"Total" (ot_total): ot_subtotal + [ot_tax, 0.0] + [ot_shipping, 0.0] - [ot_coupon, 0.0] - [ot_discount, 0.0]

Basically, they are all the stock default settings.

At one point, I changed the tax calculation to be simply "average_products_tax * 100" just to get the program to print out the tax rate that it is using, and I'm finding that it is using a rate of 8.47%. I don't know where that is coming from.

The order has only one line item ($69.00 + 9.25% tax) and I've entered the discount in the lower area where shipping and discounts are supposed to go. I entered the discount with a class of "ot_discount" with the "In Totals" checkbox checked.

One other thing that I've noticed after doing this is that when I run a sales report for the day that includes only this sale using the report "Sales Reports" under "Additional Reports", I see a Total Shipping Costs of "-9.25" and a Total Tax of "9.25". There should be no shipping at all. It is curious that these numbers are multiples of the tax rate. In fact, if I change the tax rate to 10% and re-run the report, I see "-10" and "10" show up for Total Shipping Costs and Total Tax. Strange. Any ideas on how to correct this?

I'm using Store Manager v5.1.5 build 1364 with osCommerce v2.3.1.

Thanks,

Ron

[demyanov]

Hello,

Please contact us via e-mail at: contact[at]magneticone.com or submit a ticket at: www.support.magneticone.com so we could investigate your issue more deeply.

Waiting to hear from you.

[rbenditt]

Ok, I just submitted a support ticket, #76645.

Thanks,

Ron