Hi there,
I am using OData to send orders into BC. I got most of it working but I am now facing some rounding issues. I am sending the order line price with VAT (with the "Prices Including VAT" turned on) as the unit price for each product. The totals match but the VAT break down doesn't. It looks like DW calculates VAT per line and then sums it whereas BC calculates VAT for the entire order.
In DynamicWeb I have these VAT values on the order lines:
This totals 148.49 which matches with what the customer sees:
However, in BC I have this:
The VAT of 148.43 is 20% of the total amount of the order of 742,16 (equaling 25 DK VAT) which is different from the sum of the tax of each individual line in Dynamicweb (at 148.49).
This leads to display issues and confusion.
I believe I have seen a setting that calculates tax over the order instead of lines, or maybe I imagined that and it's for somehting else like Live Integration? What is the recommended approach here? I tried to send order and VAT totals to BC but those are readonly.
Any advice is highly appreciated!
Imar
