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...
Suggested answer

Shopify connector Tax Area Priority

(4) ShareShare
ReportReport
Posted on by 160
We have been using the Shopify Connector successfully for a couple of months with customers synched to a generic, per country account.
 
Shopify calculates VAT for the "ship to" (not the "bill to") country (this behavior is correct as VAT should be applied to the country the goods are delivered to). When using a Default Customer No. per country (under Shopify Customer Templates) allows for the correct VAT calculation in Business Central even in more complex scenarios for customers being delivers in another country. For example, Business Central will correctly use the French VAT Bus. Posting group on a sale for an Austrian customer that is delivered in France or doing a "Pick up in store" in France.
 
However, because we wanted a more detailed follow up for our customers, recently we switched to using a Customer Template per customer (now we create a customer in BC every time an order is imported from Shopify). The customers VAT Bus. Posting Groups are created correctly in BC. However, now we have an issue with customers that shipped to an address in a different country (I was surprised, but we have a few). In this scenario, our Austrian customer that is shipped in France, is still charged VAT in Austria, causing us to review and correct a few invoices.
 
I have made sure that Tax Area Priority in BC is set to Ship to -> Sell to -> Bill to (as I understand it will look for the shipping address first). I also made sure that Customer Templates has the correct Tax Bus. Posting Group per country (see Set up taxes for Shopify connection - Business Central | Microsoft Learn).
 
Anything else I am missing? Thanks
I have the same question (0)
  • Suggested answer
    Jainam M. Kothari Profile Picture
    12,126 Super User 2025 Season 2 on at
    Shopify connector Tax Area Priority
    Hello,
     
    To ensure correct VAT calculation based on the shipping address in Business Central when using the Shopify Connector, verify that Tax Area Codes and Customer Templates are correctly configured with appropriate VAT Business Posting Groups and Tax Area Codes. Review your VAT Posting Setup and confirm the Tax Area Priority is set to prioritize the "Ship to" address. Conduct thorough testing to validate the settings, and consider manual adjustments for specific transactions if necessary.
     
     
     
  • giovanni79 Profile Picture
    160 on at
    Shopify connector Tax Area Priority
    Hi Jainam,
     
    As I wrote before, the Tax Area Priority is already set to Ship to -> Sell to -> Bill to.
     
    Customer Templates seem to be created correctly as new customers are created correctly, but existing customers who want to be delivered in another country keep the original country VAT Bus. Posting Group.
     
    I am not sure how to set the Tax Area Code as this table seems to be related to Sales Tax, not VAT. Can you please explain yourself a little more?
  • giovanni79 Profile Picture
    160 on at
    Shopify connector Tax Area Priority
    The documentation says: "The Tax Area field also contains a Country Code and County Name pair. This pair is useful when the connector needs to convert a code to a name, or vice versa." (see Synchronize customers and companies - Business Central | Microsoft Learn).
     
    I am confused as in the Tax Areas I only see State Code and State, which I assume refer to sales tax in different US states, not countries for VAT.
  • Suggested answer
    YUN ZHU Profile Picture
    92,445 Super User 2025 Season 2 on at
    Shopify connector Tax Area Priority
    Just to add some information, you can post Shopify related questions to the BC Yammer Group below, and Microsoft technicians should be able to give you better suggestions.
    aka.ms/BCYammer: Dynamics 365 Business Central Partner Community (Formerly: Development)
    More details: About Business Central partner community on Viva Engage (formerly Yammer)
     
    Thanks.
    ZHU
  • giovanni79 Profile Picture
    160 on at
    Shopify connector Tax Area Priority
    Thank you Zhu,
     
    Not sure if the community you point to is reserved for Dynamics partners, but I've requested access.
     
    It seems some else required this feature a while back, but it does not seem that it has been developed: Microsoft Idea
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    19,137 Super User 2025 Season 2 on at
    Shopify connector Tax Area Priority
    Yes, the idea has already been shared with Microsoft. You can vote, comment, and support it.

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
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,237

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,425

#3
Sumit Singh Profile Picture

Sumit Singh 2,907

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans