Developer forum

Forum » Ecommerce - Standard features » ERP-backed order, live taxes and rounding

ERP-backed order, live taxes and rounding

E-mail notifications
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Posted on 02/04/2017 22:15:43

Hi there,

We have an order that is calculated by the ERP using a customized version of the live integration framework. When the tax comes back, we get decimals like 7.16. When the cart is rendered, the tax shows up as 7.00. This is because we have rounding applied on the currency associated with the order. Is there a way to disable that rounding? Since the value is calculated by the ERP, it must be exactly what we assign, or we get price differences on the calculations in the ERP.

Thanks!

Imar


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 04/04/2017 09:05:22
Reply

Bump. Any ideas?

Another thing that we saw is that rounding affects existing orders also. Is that right? We set a new rouding rule and then saw prices change in the customer center for old orders. That's undesired behavior if you ask me. We did run into a major issue with a cached rounding rule on a currency (where, after disabling rounding for a currency it continued to be applied until we restarted the site), so maybe it was related to that, but something's definitely a bit fishy.

If we can find a way to stop rounding on manually set values and have an answer on whether or not it's by design that historical orders change, I can look into some solutions or work arounds and in parallel try to reprodue the issue we had yesterday.

Thanks,

Imar

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 13/04/2017 09:40:30
Reply

Bump again. Anyone?

 
Jonas Krarup Dam
Posted on 19/04/2017 11:06:05
Reply

Hi Imar,

I don't have a solution for you, but I am also somewhat confused - why do you have rounding activated on a solution with a live integration?

It seems to me that when you do this, you're not allowing the ERP system to be master for the data that is being presented. In my opinion, if you want to have any rounding in an integrated solution, that rounding should be done by the ERP system.

Regards, Jonas

 

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 20/04/2017 13:05:43
Reply

Hi Jonas,

We use rounding for the list prices that are stored in Dynamicweb whereas the cart is (live) calculated by the ERP. Consider something like this:

Product 1
  Price:    $21

Currencies:
  USD: 100
  GPP: 110

This would make Product 1 cost 19.09 on the list when viewed in British pounds, but the customer wants to show it as 19.00. Then when you add the product to the cart, the actual price for the user is calculated by the ERP in GBP which is also 19.00 (as they have applied similar rounding in the ERP).

Is Dynamicweb doing the right thing by rounding taxes? I can imagine it rounds product prices, but rounding taxes seems somewhat scary to me as you could lose money or end up with a mess ;-)

But if rounding taxes is by design (thinking it is, as it does it on the currency itself), then it is what it is and we'll have to implement our own rounding for the list prices.

Hope this explanation makes somewhat sense but let me know if you want me to explain further.

Thanks,

Imar

 

You must be logged in to post in the forum