Developer forum

Hi Pernille,

We have encountered something similar in one of our projects and we ended up storing the prices with VAT in the database.

It would work if you sell to a single country but it might prove difficult if you are selling to multiple countries (multiple VAT rates).

Our decision was for an older DW version. Maybe there is some specific functionality in newer versions to handle this situation. At this point, I am not aware of it, but the guys from DW should have the final word here.

Adrian

Thank you for your input.

I am not sure that would be a solution is this case though. We would still have two numbers with many decimals (payment fee and the vat which is calculated based on the complete amount including payment fee) that we need to add together - creating a total that might vary because of rounding.
Furthermore this client is selling b2b so using prices with vat seems wrong.

I was hoping for a functionality to handling situations like this. My guess is that several shops would encounter similar problems if they use vat and a %-fee of some kind

Hi Pernille,

The problem is the rounding on the VAT amount and most specifically, when the rounding occurs.

In our case it was also a B2B project. The difference is that you will always have the price with VAT as calculated by the ERP and you calculate the VAT amount based on the value with VAT. And this will avoid rounding differences.

The same can be done for shipping and payment fees.

Adrian

Dynamicweb 9.9 contains a change in how VAT and rounding is handled - should handle the above scenario.

BR Nicolai

That sounds good! I will update and see if it fixes the problem.

Is there a new setting or something I need to enable, or is this new change just applied automatically?

That is default behavior, so no changes needed.

Hi Nicolai,

This improvement in 9.9, what does it do?

Has it changed the rounding precision?

I am asking because I have an integration with SAP and VAT calculation came into play. They have a few different VAT rates, depending on the product type and their calculations in SAP are using 8 decimals while the display is using only 2 decimals.

Would this improvement solve this calculation?

Thank you,

Adrian

When we work with calculated prices - in Dynamicweb inside the object "CalculatedPrice" we calculate vat, quantities etc. with rounded values instead of the full value.

Instead of calculating precise numbers as before for vat and quantity multiplications and only round display values, saving the precise values to the database, values are now rounded to the currencys regional info currency decimal precision when calculated. That means for most currencies, the calculated amount is rounded to 2 decimals before we do anything with it. (In japan the precision is 5 and probably other places as well)

If you calculate in SAP using Live integration, Dynamicweb will probably not calculate anything.

BR Nicolai

Hi Nicolai,

Thank you for the detailed explanation. All clear.

I want to detail this part: "If you calculate in SAP using Live integration,..."

Is there an existing/supported integration with SAP?

Thank you,
Adrian

Nope... I know there are some customers on SAP, but we are not involved...

Hi Nicolai,

That was also my information. I was hoping though that something may have come up in the meantime :)

This means that if we want to use LiveIntegration with SAP, we would have to create our own "Connector" between SAP and DW.

Thank you,

Adrian

You can create a provider for the current connector service. Or go directly from DW to SAP - eventually we will also leave the connector service and go direct (using odata or rest apis)