I find no way to have pricelist based on cost when having prices with taxes included.
I have a product:
price 25,
cost 10,
tax: 21% (included in price)
Pricelist set to Based on Cost and the rest is left to default
I Create a Quotation and set this Pricelist, add a line with the product and get:
unit price: 10
cost: 10
subtotal: 8.26
So in fact I am selling it not for cost price but for less (21% less)
What I tried is creating a Fiscal Position replacing the Tax 21% incl to Tax 21% excl
Now what I get is:
unit price: 8.26
cost: 10
subtotal: 8.26
What I want is to sell it for cost price and then add the taxes on top. The standard_price in product must be tax excluded and so pricelist based on cost should behave accordingly.
How can I set my pricelist in this scenario?