PDA

View Full Version : Sales Tax


chris199437
04-28-2009, 10:10 AM
The Sales Tax is adding on in the tax column then adding the total for the tax total column and pre tax items. http://www.hotcakesinc.com/store2.asp

IN sales tax is 7%

chris199437
04-28-2009, 10:53 AM
Sorry, http://www.hotcakesinc.com/fbb/store2.asp

Ray Borduin
04-28-2009, 10:58 AM
I'm afraid you will need to give more background in order to debug this. The url does not work and I don't quite understand the problem you are describing.

chris199437
04-28-2009, 11:04 AM
If you start at http://www.hotcakesinc.com/fbb/store1.asp add something to cart. Then you will see on page store2.asp it adds the tax on the sub-total and totals it there. Where I want it to just show the tax amount of the order in the Tax column then Grand Total the Sub-total and the tax.

Ray Borduin
04-28-2009, 11:45 AM
Then you would want to add a calculation:

TotalPrice = ([Price]*[Quantity]) + ([Price]*[Quantity]*0.07)
TaxAmount = [Price]*[Quantity]*0.07

Then remove your tax rule entirely since tax will already be handled in the calculations