We have a weird issue with VAT calculation when creating orders using live integration towards a BC18 running code unit version 126.96.36.199.
It seems that the database columns "OrderPriceBeforeFeesWithoutVAT" and "OrderPriceBeforeFeesVAT" are not getting their correct values, when creating an order although VAT percent seems to be returned correctly from BC. In the below example, I have created 2 identical orders, one with live integration enabled (ORDER779) and one with live integration disabled (ORDER780). The 2 lines seems to be identical except the 2 columns mentioned above
And the orderlines here:
I can't seem to figure out why this occurs. This is the XML exchanged between DW and BC for ORDER779 (customer and product details omitted from the XML example):
Could you please check to see if this is an error. We have a customer running a solution where some of their customers pay VAT and some does not, so we really need the fields to be correct.
Also is there any way to manipulate these 2 columns in a NotificationSubscriber for a quick fix, I can't seem to find their equivalent on the order objects in the subscribers?