Calculating Tax for Exempt Customers on Sales Order
My retail prices including tax are stored in the Product Sale Price field. The tax Code for my Taxable Customers ST11 is set to Tax Included in price. I also sell to Tax Exempt customers and have created a Fiscal Rule. The issue is that when entering a Sales Order the price is still based on the product Sale Price field but the tax does not get deducted.
ST11 -> 20% [TAX included in price]
ST2 -> 0% Exempt Sales
Fiscal Rule Exempt Customer -> Map -> ST11 to ST2
Product A Sale Price Â£120
Customer A Taxable
Customer B Exempt - > Fiscal Rule applied
(1) Sales Order selling product A to Customer A
Product A Â£100 Tax Â£20 = Â£120 correct
(2) Sales Order selling product A to Customer B
Product A Â£120 Tax Â£0 = Â£120 incorrect Price should be Â£100
I would like to keep the Product Sale Price as Tax Included.
What is the best way to set OpenERP to calculate the prices correctly for Tax Exempt Customers?