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.
Tax Codes
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?
One way I have found of implementing this is to create a new price list - Tax Exempt Customers - based on the Taxable Price List and then setting the calculation fields to New Price = Base Price * ( 1 + -0.1667) + 0.00 (Note 0.1667 is negative). I then assign the customer to the price list and the 20% tax is removed by means of calculation.