I'm trying to implement a tax and discounts table which can allow line item discounts and entire order discounts. I'm not using any software in particular, just want to know how it's currently done or if it's even possible. Implementing the discounts per line item and entire order was easy. How to determine the tax affected is the hard part. I'll keep my example simple:
Line # Price Tax Rate Sub Total Discounts Sub Total after Discounts 1 $5.00 8.25% $5.41 1 $4.33 2 $5.00 0.00% $5.00 1 $4.00 3 $10.00 7.25% $10.73 2 $8.58 Total: $21.14 Total: $16.91
As you can see, the line item discounts are easily done and the taxes deducted accordingly. Now, however, if I want to apply a $5 discount to the entire order, how do I take into account the taxes to deduct if the tax rate is different for each line? Is this even possible?
Thanks in advance, Tony