Developer forum

Forum » Integration » VAT rounding issue (Business Central extension)

VAT rounding issue (Business Central extension)

Timo Tasala
Reply

Hi!

Standard Business Central calculates VAT for below mentioned case 460,28€. However, Dynamicweb Plugin extension returns 460,33€. Is there a bug in the extension or perhaps some setting which affects on the calculation? My expectation is that the VAT should be 1:1 same as in BC (since this is BC extension).


 

 

Regards,

Timo Tasala


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Timo,
that is probably related to the rounding issue which is caused by different calculations, more details can be found here.
You can try to change the currency Amount Rounding Precision from 0.01 to 0.001 and then Unit Amout Rounding Precision too:

BR, Dmitrij

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Also see here: https://doc.dynamicweb.dev/manual/dynamicweb10/integration/guides/erp-prices.html

If any calculations are made in DW - e.g. the product price is from ERP, but Dynamicweb calculates the line and order totals, you will have to test the different settings in the rounding section in DW10.

 
Timo Tasala
Reply

1) This is not related to currencies. This is local currency and in this case, the currecy code is left blank. There is of course setting "Amount Rounding Precision" in the General Ledger Setup (Business Central), but this can't even be changed in an environment where you have transactions.

2) DW doesn't do any VAT calculations, but relies on the web service response.

 
Timo Tasala
Reply

Any news on this yet?

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Hi Timo

Can you provide some more information

  • Which version of Dynamicweb are you using?
  • Which version of Live integration are you using?
    • And how is it setup? Can you provide screenshot of your settings? 
  • The XML you are showing - is that the response from BC to Dynamicweb after the order has been calculated in BC - or is it the Request Dynamicweb send to BC to create the order after it has been placed?
    • Please provide the full XML dump as a file so we can see where the rounding difference happens
  • How are your rounding settings setup in Dynamicweb?
    • Prices can be rounded in many different ways - all correct, but different. In the documentation link provided in my previous post that is handled.

Thank you for clarifying

 

You must be logged in to post in the forum