# Calculating Tax for Exempt Customers on Sales Order

shaun

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?

1 Comment
shaun
-

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.

shaun

The solution of creating a price list to to calculate the correct price for Exempt customers is not complete. The reason being that some of the products that I sell are Zero Rate (0%) . Therefore based on a calculated Price list to remove TAX you get the following scenario.

Product A Tax Code ST11 (20%)

Price Â£12 (Â£10 ex TAX)

Product B Tax Code ST0 (0%)

Price Â£12 (Â£12 ex VAT)

Customer B Exempt - > Fiscal Rule applied + Assign to calculated price to remove TAX

Product A Price Â£10 correct

Product B Price Â£10 incorrect as product B is Zero Rated with a price of Â£12

This begs the question of "What is the point of a Tax Code with a setting of TAX included in Price?" unless there is a way of Mapping between Fiscal Positions

Does this mean that to set up OpenERP correctly all prices should be EX TAX?

1 Comment
shaun
-

Is it possible to use the Taxes -> Special Computation Field to calculate the price on logic. ie IF (tax_code = ST11 and ST11_tax_is_included) {Price = Price - ST11_TAX} ELSE {return Price} . Will this create problems with tax reports? Can any one provide me with an example?

patrick