Vat is shown with 3 decimals

Hi all,

IM using dolibarr together with woocommerce wich is coupled via splash sync. When and order is placed on our webshop in dollibarr the vat rates are shown with 3 decimals. Is there a way to round this off within dolibarr. It looks like dolibarr recalcualtes the vat value based on the selling prices with and without vat.

Hello :slight_smile: & Welcome :slight_smile:

Can you be more precise : what is your version, which module you use, where do you find this screenshot

With phpmyadmin, can you check the ‘llx_commandedet’ where you can find every orders’ lines
maye be these values are as this in your database

Good continuation

Hi PCBlue,

Thanks for you reply. Due to the fact you made me look into the database i found out that taxrates were set to 3 decimals (Standard settings i guess) and that resolved my issue.

To anser your questions(just for if there is anyone facing the same problem in the future) i’m using dolibar 14.0.4. Further i’m using the splash module to sync my woocommerce orders and stock with dolibarr. The issue was visible in all order and invoice lines when an order was created and pushed from woocommerce to dolibarr.

The screenshot i sent earlier was a screenshot of the VAT column from one of my orders.

In case you have any further questions please let me know. For now my issue has been solved and i want to thanks you for pointing me in the right direction.