web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

BC Sales Order VAT Error for some select customers with CRM Integration

(2) ShareShare
ReportReport
Posted on by 4
Hello,
I am encountering a persistent and frustrating VAT posting error in Dynamics 365 Business Central (SaaS, v26.4), preventing a sales order, synchronized from an external CRM system, from posting. This is happening for an existing EU customer that we have successfully invoiced previously without issue in the past and no recent changes have been made to our VAT setup.
 
We are running Dynamics 365 Business Central (SaaS, v26.4.x) with a tight integration to CRM (D365CE Sales)
 
All order generated from a particular country are stuck in the sales order posting queue whilst others from other locations go through without issues.
 
Here is the Error Message:

VAT Calculation Type must be equal to 'Reverse Charge VAT' in VAT Posting Setup: VAT Bus. Posting Group=EU-REG, VAT Prod. Posting Group=. Current value is 'Normal VAT'.
The call stack confirms the error is triggered by standard BC validation (Sales Line."No. - OnValidate") after the custom integration code runs:
AL Call Stack (Abbreviated)
[Custom Integration CodeUnit].InitializeSalesOrderLineFromItem
"Sales Line"(Table 37)."No. - OnValidate"(Trigger)
 
 
We made not changes to the vat setup which is odd and we cannot change VAT Setup as the error implies.
 
Can anyone advise why did this transaction suddenly begin to fail when previous, identical orders posted correctly using one of the other, correctly configured EU groups?
 
Thank you for any insight! 
I have the same question (0)
  • Suggested answer
    MariusTeleman_VGR Profile Picture
    4 on at
    BC Sales Order VAT Error for some select customers with CRM Integration
    Hello,
     
    Standard BC needs Vat Bus. Posting group + Vat Prod. Posting group to validate the correct VAT approach.
    For a standard sales document, the VAT Bus. Posting group comes from the header (customer) and the Vat Prod. Posting group from the lines. 
     
    In your case no VAT prod. Posting Group is being validated on the lines. 
    Potential causes:
    • Item used is missing on item card the VAT Prod. Posting Group - case in which adding the missing setup on item and trying again should solve it
    • There is a development that interferes in how standard validations are done and item is being added, reset, and the posting crashes for missing setup. 
     
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    3,561 on at
    BC Sales Order VAT Error for some select customers with CRM Integration
    Hi,
     
    The error occurs because BC validates the combination of VAT Business Posting Group and VAT Product Posting Group against the VAT Posting Setup at the time of posting. Even if nothing changed in your setup, a few scenarios can trigger this for some customers:
    > The customer’s VAT Bus. Posting Group was changed, or the integration is sending an incorrect or missing VAT group for that specific country.
    > The item or product being sold has a VAT Prod. Posting Group that does not match the expected setup (e.g., “Normal VAT” instead of “Reverse Charge VAT”).
    > The CRM integration is mapping fields differently for this customer or country, overriding the correct VAT setup.
     
    Resolution steps:
    > Verify the customer’s VAT Business Posting Group in BC.
    > Check the item’s VAT Product Posting Group.
    > Review the VAT Posting Setup for the EU-REG group and ensure “Reverse Charge VAT” is defined correctly.
    > Check the integration mapping for that country/customer to ensure the correct VAT groups are being passed.
     
    This is not a bug but a data mismatch; correcting either the customer, item, or integration mapping resolves the posting error.
     
    Thanks
    Rishabh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,864

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,185

#3
Sumit Singh Profile Picture

Sumit Singh 2,850

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans