Price inc. VAT showing wrong

Using my Dolibarr CRM/SRM Modules
1

Hi,

After update from 23.0.0 to 23.0.1 i got bag with showing correct price with included VAT in line when i create vendor invoice.

Here is an example.

I add one line, add unit price without VAT and after confirmed in place where it need to show price inc. VAT it show smaller price than unit price. If i click on edit and only save without change anything, showing price is ok.

On the image, first line is before click on edit to save again.

For help about my language
Ед. цена > Unit Price without VAT
У.П (вклучено данок) > Unit Price with VAT

image
image923×130 10.6 KB

VAT calculate problem - VAT calculate on final price
2

Hi,

Version 23.0.2 in German, the same.

3

Any solution???

4

HI,

Since update my dolibarr to 22.0.4 to 23.0.2 we cannot set sale price. My company use multiple level of product price. I try set-up one price by product and the issue is the same.

I have isolate the log erro:

DoliDBMysqli::query SQL Error query: INSERT INTO llx_product_price(price_level,date_price, fk_product, fk_user_author, price_label, price, price_ttc, price_base_type,tosell, tva_tx, default_vat_code, recuperableonly, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, price_min,price_min_ttc,price_by_qty,entity,fk_price_expression) VALUES(1, ‘2026-05-06 09:55:52’, 0, 2, null, 0, 0,‘HT’,0, 0, null, 0, 0, 0, ‘0’, ‘0’, 0, 0, 0, 1,null)

25790 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1452 Cannot add or update a child row: a foreign key constraint fails (dolibarrdebian.llx_product_price, CONSTRAINT fk_product_price_user_author FOREIGN KEY (fk_product) REFERENCES llx_product (rowid)) From /usr/share/dolibarr/htdocs/product/class/product.class.php:2309.
2026-05-06 09:55:52 ERR

25790 33 Error url=/product/price.php, query_string=, sql=INSERT INTO llx_product_price(price_level,date_price, fk_product, fk_user_author, price_label, price, price_ttc, price_base_type,tosell, tva_tx, default_vat_code, recuperableonly, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, price_min,price_min_ttc,price_by_qty,entity,fk_price_expression) VALUES(1, ‘2026-05-06 09:55:52’, 0, 2, null, 0, 0,‘HT’,0, 0, null, 0, 0, 0, ‘0’, ‘0’, 0, 0, 0, 1,null), db_error=Cannot add or update a child row: a foreign key constraint fails (dolibarrdebian.llx_product_price, CONSTRAINT fk_product_price_user_author FOREIGN KEY (fk_product) REFERENCES llx_product (rowid))

I dont know if this is the same case but i’m locked for find a way.

Thanks

Romain

5

@Roke87 I think this has been fixed at github, and we also had a different post about it here.

I think you can find the solution on one of these threads, and when you do that, please link it here too, aka maybe link to a page where there is a solution, no need to duplicate it