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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How Do I Map the Clien...
Small and medium business | Business Central, N...
Suggested Answer

How Do I Map the Client-Provided GL Accounts in Business Central for Our Shopify Integration?

(2) ShareShare
ReportReport
Posted on by CU06081136-2 4

We have integrated Shopify with Business Central using the official Microsoft BC connector, and our client (Darco Direct, Inc.) has provided their live General Ledger accounts:

  • 1200 – Accounts Receivable
  •  
  • 1300 – Inventory
  •  
  • 2370 – Accrued Sales Tax
  •  
  • 3000 – Sales
  •  
  • 3200 – Discounts Given
  •  
  • 4000 – Cost of Goods Sold
  •  
  • 6205 – Freight Income

 

What are the exact steps in Business Central to configure these account numbers so that:

  1. Sales, Sales Credit Memos, and Discounts post to 3000 / 3000 / 3200 via General Posting Setup?
  2.  
  3. Inventory Adjustments and COGS post to 1300 / 4000 via Inventory Posting Setup?
  4.  
  5. Sales Tax Accrual posts to 2370 via VAT (Sales Tax) Posting Setup?
  6.  
  7. Freight Income (Shopify shipping fees) posts to 6205 – Freight Income (either by creating a “Freight” service item or via connector freight-mapping settings)?

 

A step-by-step guide (with screenshots or menu paths) would be greatly appreciated to ensure our connector routes each transaction type to the proper GL account.

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Sumit Singh Profile Picture
    Sumit Singh 10,079 on at
    1. General Posting Setup (Sales, Credit Memos, Discounts)
    Purpose:
    Map Sales (3000), Sales Credit Memos (3000), and Discounts Given (3200).
    Steps:
    1. Search for "General Posting Setup".
    2. Ensure the correct Combination of Gen. Bus. Posting Group (e.g., DOMESTIC) and Gen. Prod. Posting Group (e.g., RETAIL, WHOLESALE) exists.
    3. Set:
      • Sales Account → 3000
      • Sales Credit Memo Account → 3000
      • Sales Discount Account → 3200
     You may need to configure Gen. Bus. Posting Groups and Gen. Prod. Posting Groups under respective pages if not already set.
    2. Inventory Posting Setup (Inventory & COGS)
    Purpose:
    Map Inventory (1300) and COGS (4000).
    Steps:
    1. Search for "Inventory Posting Setup".
    2. Ensure the correct combination of:
      • Inventory Posting Group (e.g., FINISHED)
      • Location Code (e.g., SHOPIFY)
    3. Set:
      • Inventory Account → 1300
      • COGS Account → 4000
    Ensure the Inventory Posting Group is assigned to the items synced from Shopify.
    3. VAT Posting Setup (Sales Tax Accrual)
    Purpose:
    Map Sales Tax Accrual (2370).
    Steps:
    1. Search for "VAT Posting Setup".
    2. Ensure the correct combination of:
      • VAT Bus. Posting Group (e.g., DOMESTIC)
      • VAT Prod. Posting Group (e.g., TAXABLE)
    3. Set:
      • Sales VAT Account → 2370
     Make sure the VAT Prod. Posting Group is assigned to taxable items and the VAT Bus. Posting Group is assigned to customers.
    4. Freight Income Mapping (6205)
    Option A: Create a Freight Service Item
    1. Go to Items → Create a new Non-Inventory Item:
      • Type: Service
      • Description: Freight
      • Assign Gen. Prod. Posting Group → FREIGHT
    2. Go to General Posting Setup:
      • Add a row for FREIGHT + DOMESTIC
      • Set Sales Account → 6205
    Option B: Connector Freight Mapping
    1. Open Shopify Connector Setup.
    2. Look for Shipping Fee Mapping or Freight Income Mapping.
    3. Assign the GL Account 6205 directly if supported.
     Connector behavior may vary slightly depending on version. Confirm freight mapping options in the connector documentation or setup wizard.
     Final Checklist
    Mapping Type GL Account Setup Page
    Sales 3000 General Posting Setup
    Sales Credit Memo 3000 General Posting Setup
    Discounts Given 3200 General Posting Setup
    Inventory 1300 Inventory Posting Setup
    COGS 4000 Inventory Posting Setup
    Sales Tax Accrual 2370 VAT Posting Setup
    Freight Income 6205 General Posting Setup / Connector
    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,329 Super User 2025 Season 2 on at
    Hi, hope the following can give you some hints.
    1. In General Posting Setup
    2. Inventory Posting Setup
    5. VAT Posting Setup
    7. Item Charges
     
    Thanks.
    ZHU
     

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans