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?