BC Code Unit - VAT calculation

Chris Søgaard

Posted on 04/10/2021 13:47:19

Hi DW

We have some issue with the calculation of VAT, when calculating orders using BC code unit. Customer is running version 1.2.0.16 of the code unit. This customer runs a setup with customer specific VAT calculation in BC. What we see is that VAT are applied with a rate of 25% when calculating the order, but when creating the order, the VAT is not applied. Maybe we're missing something here, so maybe you can shed some light on this matter. Below you will find XML examples of what we see (please note that I have omitted customer/user details from request and responses)

This is the XML from the request when calculating order:

And this is the response with the VAT applied to order lines:

Now when we send the same XML, but now for creating the order in BC, we send this response which is the same as the first request (but with a different order total because of the calculation response)

And this is the response without the VAT applied:

I hope we can figure out why VAT are applied on calculation but not on creating the order in BC.

BR Chris

Replies

Dmitriy Benyuk

Posted on 05/10/2021 10:10:31

Hi Chris,
what is your BC version and is it cloud/onprem? Do you have a new pricing feature on/off? Can you show how customer specific VAT calculation is setup in BC (could you provider some screens)?
Thx
BR, Dmitrij

Chris Søgaard

Posted on 13/10/2021 15:21:57

Hi Dmitrij

This took some time, but I needed the complete overview from the client in order to answer your question.

Client is running BC cloud version 18 and new pricing feature is set to "off".

Regarding the VAT calculation setup the client is using the standard matrix "VAT posting setup" like in this screen:

On the customer a "VAT Bus. Posting Group" is set like here:

And on a given product you could also set the "VAT Prod. Posting Group" like it is set here:

When adding VAT to a sales line it will take the rate from the line in the "VAT Posting Setup" where "VAT Bus. Posting Group" matches the setting on the customer and "VAT Prod. Posting Group" matches the setting on the product.

Furthermore I have mailed you the entire "VAT Posting Setup" on this customer to be able to replicate this exactly.

But I think I know what the issue is. It seems that the selection "VAT Calculation type" is not taken into consideration when calculating the order. If the type here is set to "Reverse charge" the VAT rate in the matrix should not be applied to the sales order. I have tested the following:

If a customer and product falls into a line in "VAT Posting Setup" where VAT rate is 25% and "VAT Calculation Type" is set to "Reverse Charge" then the expected result is that VAT is not added to the sales order. Calculating order in code unit will add the VAT but create order in code unit will not.
If a customer and product falls into a line in "VAT Posting Setup" where VAT rate is 0% and "VAT Calculation Type" is normal, then it works as intended on both calculate and create.

I hope this gives you the necessary information.

BR Chris

Dmitriy Benyuk

Posted on 13/10/2021 21:21:14

Hi Chris,
we were fixing exactly the same problem in the extension and it was released in 1.2.0.17 version. However there is already 1.2.0.19 version available on the App Source that can be installed on the cloud with BC18. Or on the doc site there 1.2.0.17 version for the BC 18 on premise.
Could you try to upgrade the extension to more never version of 1.2.0.17 or later and check your problem again?
BR, Dmitrij

You must be logged in to post in the forum

Developer forum

BC Code Unit - VAT calculation

Replies