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?
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?
Your solution is possible, but I wonder why you want your product prices to be with tax included?
If you would create the prices without taxes, openERP is able to do the tax-calculation correctly, depending on the country of the customer and the existence of the VAT number of the customer. This way, the tax-exempt customer might get a receipt with tax included, but he can get it back from the customs.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/5/13, 1:00 PM|
|Seen: 5295 times|
|Last updated: 5/26/16, 9:07 AM|