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

Business central -> Shopify - Postinggroups

(1) ShareShare
ReportReport
Posted on by 345
Hi all, 
 
I am trying to add items to shopify product. 
And when I left the fields for Gen.Bus Posting group and TAX. Bus. Posting group empty in our shopify shop. I got an error message saying:
 
VAT posting setup does not exist. Identification fields and values: VAT business posting group = '', VAT product posting group = '6'. (we have postinggroups on every item and it is 6% VAT)
 
So I added "domestic" to those fields. But, what happens when a customer from another country orders from our shop? when gen.bus posting group is domestic?
 
We want to add/sync items from BC to Shopify. Never from shopify to BC. 

I have the same question (0)
  • DavidO Profile Picture
    10 on at
    Business central -> Shopify - Postinggroups
    Hi,
     
    Following this Business Central error: VAT posting setup does not exist. Identification fields and values: VAT business posting group = '', VAT product posting group = '6'. (we have postinggroups on every item and it is 6% VAT)
     
    I suggest that you add a new set up in the VAT Posting Setup. The VAT Business Posting Group will be blank, the VAT Product posting group will be "6". Then add the values to the remaining fields. 
     
    You need to make sure that the VAT Posting Setup has configurations to cater to every type of VAT related posting that is accepted in your region else you will encounter these posting errors. 
  • Suggested answer
    Mansi Soni Profile Picture
    8,881 Super User 2025 Season 2 on at
    Business central -> Shopify - Postinggroups
    Hello,

    1. Why does the error VAT posting setup does not exist occur when Gen. Bus. Posting Group and VAT Bus. Posting Group are left empty?

    This error happens because Business Central requires a valid combination of VAT Business Posting Group (from the customer or sales document) and VAT Product Posting Group (from the item) to find the correct VAT Posting Setup. If the VAT Business Posting Group is left empty or missing, the system cannot identify which VAT posting to use for the product’s VAT product posting group, causing the VAT posting setup does not exist error.

    2. What happens when you set Gen. Bus. Posting Group to Domestic on the item?

    In Business Central, the Gen. Bus. Posting Group is typically set on the customer or vendor card, not on the item. Setting Domestic as Gen. Bus. Posting Group on an item is not standard and does not impact VAT calculation. VAT calculation depends on the VAT Business Posting Group on the customer and the VAT Product Posting Group on the item. The Gen. Bus. Posting Group mainly controls general ledger posting behavior and is not used to determine VAT.

    3. What happens when a customer from another country orders, but the Gen. Bus. Posting Group is set to Domestic?

    If the customer’s VAT Business Posting Group is incorrectly set as Domestic instead of reflecting their actual location, Business Central will apply domestic VAT rates to their orders. This can cause incorrect VAT calculation for international customers. To ensure correct VAT treatment, the customer’s VAT Business Posting Group must be set accurately (e.g., EU, Export) based on their tax jurisdiction.

    4. How should you handle posting groups when syncing items from BC to Shopify, considering you only want one-way sync?

    When syncing items from Business Central to Shopify, ensure that the VAT Product Posting Group on each item in BC is correctly set to represent the VAT category (e.g., 6% VAT). The VAT Business Posting Group and Gen. Bus. Posting Group should be set on the customer cards in BC, reflecting their location and tax status. This setup allows BC to calculate VAT correctly when orders come in, using the combination of customer VAT Business Posting Group and item VAT Product Posting Group. Since syncing is one-way (BC to Shopify), customer posting groups should be managed entirely within BC.

     

    Hope this answer will help you!

    Regards,
    Mansi Soni

  • Suggested answer
    Sohail Ahmed Profile Picture
    11,089 Super User 2025 Season 2 on at
    Business central -> Shopify - Postinggroups

    I recently implemented a similar solution for one of my clients, but it required customization using AL code. I'm sharing a few hints that might help you resolve your issue:

     

    We extended the default Shopify connector and injected our custom business logic. Specifically, we applied posting groups conditionally based on the customer's country code. When an order is synced from Shopify to Business Central, the customer's country code is also brought in. Based on that, we applied a specific posting group when the order is created in BC as either a Sales Order or Sales Invoice.

     

    For example, our client treats all domestic orders as those with the country code AE, and any other country is considered an international order (Export VAT Group = No VAT).

     

    If you're a developer, I can share my code with you. Otherwise, I’d recommend contacting your Microsoft partner — this is a fairly simple customization for them to implement.

     

    LinkedIn : https://www.linkedin.com/in/sohailahmad897/

     


    Mark this answer as verified if its helps you.
  • Gerardo Rentería García Profile Picture
    23,574 Most Valuable Professional on at
    Business central -> Shopify - Postinggroups

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,330

#2
Sumit Singh Profile Picture

Sumit Singh 2,738

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,546

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans