Developer forum

Forum » Ecommerce - Standard features » VAT calculation on order line

VAT calculation on order line

Christian Fisker
Reply

Hi DW,

We have an issue with VAT calculation for an order line.
OrderLinePriceVAT is calculated too low, compared to what the backend ERP system calculates for the same line.

OrderLineQuantity = 57
OrderLineUnitPriceWithoutVAT = 102.39
OrderLinePriceWithoutVAT = 5836.23
OrderLineUnitPriceVATPercent = 25
OrderLineUnitPriceVAT = 25.59
OrderLinePriceVat = 1458.63

25% of 102.39 is 25.5975
DW rounds this down to 25.59

Result is that OrderLinePriceVAT is 1458.63 but the result we want is 1459.06

How do I get DW to calculate VAT as OrderLinePriceWithoutVAT * OrderLinePriceVATPercent = 1459.0575 (rounded to 1459.06)?

BR Christian

 


Replies

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply

Hi Christian,

 

Check the Rounding configuration for that currency. Notice the Rounding setting https://doc.dynamicweb.com/documentation-9/ecommerce/internationalization/currencies

 

You'll have to setup the rounding as expected first https://doc.dynamicweb.com/documentation-9/ecommerce/internationalization/currencies#sideNavTitle1-1

 

Best Regards,

Nuno Aguiar

 
Nicolai Pedersen
Reply

Also fiddle with these 2 settings - probably uncheck them:

 

You must be logged in to post in the forum