Hi All,
I’m having a problem with product buying price. Whenever I change the price to inc. of VAT it calculates and changes the price with some calculation for example:
In the above image the VAT is 16% and buying price inc. VAT is 15000
When I save it this is what happens:
Instead of remaining at 15,000 inc. VAT it changes to 12,931.03 Net of tax!!!
How is this happening? I’m using Dolibarr 5.06. Any assistance will be welcome
So the buying price always shows net of tax and changes accordingly if you select inc. tax it doesnt change to that that’s what is happening.
Kindly if someone has a solution to this
i have almost same issue but i found out if i use “.” instead of “,” it will do it right but if you then try to modify it again you have to change it again back to “.”
Hi Nemprinter,
Thanks for your reply. So if I type 15.000 instead of 15,000 it should work?
Hi Nemprinter,
Kindly if you can explain your solution in more detail, I’m not understanding
Hi,
15000 include VAT 16% = 12930 !
it is a price all taxes ? No ?
@+
Hi Philazerty,
I want the buying price to be inclusive of VAT but if I change it to inc. VAT it goes to net of tax! How to make it stay at inc. of VAT
So like in the example if I type 15,000 and choose inc. tax then save it automatically changes to 12,931. I don’t wan’t it to change to 12,931 I want it to remain 15,000
i found if i use “.” instead of “,” it was working that calculation in my system that i so around when i start to give discount on product it was not calculation right
Nemprinter,
Kindly provide a practical example
Buying price screen will always show the net of tax value
so when you enter an inc tax value dolibarr will reverse back it into 2 separate values, first how much original cost, and second how much taxes, at your example 15000/1.16 = 12931.03448
This is a system behaviour I believe and not a bug.
I think we need to request for a new feature to register inc tax values and to be available at proposals as inc tax items also, but there is an impact at the proposal especially when you apply a discount for “inc taxes” products as this case will fail to calculate in a proper way. i.e. if you apply the discount for your item 10% so should it be 15000-1500 = 13500 inc tax??
or Net of tax cost (12931.03448*.9 = 10991.37931) + taxes ((based on discounted cost)10991.37931 * .16 = 1758.62069) = 12750 inc tax
or Net of tax cost (12931.03448*.9 = 10991.37931) + taxes ((based on actual cost)12931.03448 * .16 = 2068.965517) = 13060.34483 inc tax
Above 3 options are valid business scenarios but I think dolibarr handles only number 2 … 12750 inc tax
I hope my idea is clear … let me know if you need any further help …
Thank you.
Hytham
Hi Hatham,
Thanks for your detailed explanation. The problem I’m facing is that my client insists on buying price being inc. of VAT. My client is holding on to payment because of this and other issues.
This feature not available.
follow this workaround:
1- For your country define new VAT rate name it VAT0 and make the rate value 0
2- at the product, define net of tax value as 15000, don’t be so worried that the system will add 16%
3- at (any of) the proposal, invoice, order view and upon selecting the product, select the VAT0
Hopefully, it will work.
don’t forget to press “Thank you” button for both my comments 
Regards,
Hytham Soliman
if i type in an order from own of my supplier he sel me a part for 56,78€ and i get 21% in discount if i type 56,78 it will calculate it wrong if i type 56.78(".") it will calculate it right
but if i then make a change to maybe text for it system change it back to “,” and i need to change that to before save it (Ver. 7.0)
