TAX Calculation Error with Coupon/Unit Reduction feature.
Posted: Mon Dec 24, 2007 12:03 am
Hey Dale,
There is an issue with sales that have a combination of non-taxable and taxable items and combined with the F9 "Coupon/Unit Reduction" feature. It causes a negative tax amount to be calculated. I've tried this with 6.39j through 640d1.
My tax configuration is add tax at end of sale. I have tax 1 set to 6% all other tax fields are zero. The F3 key "Discount" is set to 10%.
If all items in the sale are taxable, the "Coupon/Unit Reduction" works correctly. However if a sale has non-taxed item(s) and taxed item(s) and the "Coupon/Unit Reduction" is used then the tax calculations gets goofy.
This happens both with items set as tax free in the stock table or if tax is set to zero during the sale via the F7 key.
For sales with non-tax and taxed items;
I would expect the "Coupon/Unit Reduction" would be similar to the way the "All Above Reduced by 10%" and/or the F3 "Discount" function works as shown here.
![Image](http://www.thepompouspooch.com/dummy/pospercentoff-ok.jpg)
The tax rate is 6 percent.
For the taxable $10 dollar dog the register takes 10% off.
This makes the taxable amount $9 dollars. Then an additional 10% is taken off the $9 dollars with the F3 key "Discount".
This makes the taxable amount $8.10. The tax on $8.10 is .49 cents.
So this is correct.
When the F9 "Coupon/Unit Reduction" is used with a combination of non-taxable and taxable items, the tax is not calculated correctly.
![Image](http://www.thepompouspooch.com/dummy/posCouponWithPercent-bad.jpg)
The $11 "Coupon Reduction" amount is removed only from the taxable $10 dog.
This make the taxable amount -$1 dollar.
Then with the F3 key "Discount", an additional 10% is taken off the -$1. This makes the taxable amount -$0.90.
The tax on -$0.90 is -$0.05 cents. I'm pretty sure for sales tax calculation this is not good.
I would expect the "Coupon/Unit Reduction" calculation should be as follows.
The "Coupon Reduction" amount is divided between all items in the sale.
This portion is removed from each of the taxable item(s). Tax is then calculated on that amount.
In this case above, half of the $11 dollars is $5.50. The $5.50 is subtracted from the $10 dollar dog. The taxable amount is now $4.50. Then an additional 10% is taken off by use of the F3 key "Discount". This make the taxable amount $4.05. The tax on $4.05 is $0.24 cents.
If the portion of the coupon reduction removed from a taxable item results in a negative price then that item is not included in the tax calculation (a zero tax amount for that item).
There is an issue with sales that have a combination of non-taxable and taxable items and combined with the F9 "Coupon/Unit Reduction" feature. It causes a negative tax amount to be calculated. I've tried this with 6.39j through 640d1.
My tax configuration is add tax at end of sale. I have tax 1 set to 6% all other tax fields are zero. The F3 key "Discount" is set to 10%.
If all items in the sale are taxable, the "Coupon/Unit Reduction" works correctly. However if a sale has non-taxed item(s) and taxed item(s) and the "Coupon/Unit Reduction" is used then the tax calculations gets goofy.
This happens both with items set as tax free in the stock table or if tax is set to zero during the sale via the F7 key.
For sales with non-tax and taxed items;
I would expect the "Coupon/Unit Reduction" would be similar to the way the "All Above Reduced by 10%" and/or the F3 "Discount" function works as shown here.
![Image](http://www.thepompouspooch.com/dummy/pospercentoff-ok.jpg)
The tax rate is 6 percent.
For the taxable $10 dollar dog the register takes 10% off.
This makes the taxable amount $9 dollars. Then an additional 10% is taken off the $9 dollars with the F3 key "Discount".
This makes the taxable amount $8.10. The tax on $8.10 is .49 cents.
So this is correct.
When the F9 "Coupon/Unit Reduction" is used with a combination of non-taxable and taxable items, the tax is not calculated correctly.
![Image](http://www.thepompouspooch.com/dummy/posCouponWithPercent-bad.jpg)
The $11 "Coupon Reduction" amount is removed only from the taxable $10 dog.
This make the taxable amount -$1 dollar.
Then with the F3 key "Discount", an additional 10% is taken off the -$1. This makes the taxable amount -$0.90.
The tax on -$0.90 is -$0.05 cents. I'm pretty sure for sales tax calculation this is not good.
I would expect the "Coupon/Unit Reduction" calculation should be as follows.
The "Coupon Reduction" amount is divided between all items in the sale.
This portion is removed from each of the taxable item(s). Tax is then calculated on that amount.
In this case above, half of the $11 dollars is $5.50. The $5.50 is subtracted from the $10 dollar dog. The taxable amount is now $4.50. Then an additional 10% is taken off by use of the F3 key "Discount". This make the taxable amount $4.05. The tax on $4.05 is $0.24 cents.
If the portion of the coupon reduction removed from a taxable item results in a negative price then that item is not included in the tax calculation (a zero tax amount for that item).