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

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... / Shopify BC Integration...
Small and medium business | Business Central, N...
Answered

Shopify BC Integration - handle Prepayments or Cash Payments In Shopify

(6) ShareShare
ReportReport
Posted on by Samantha73 3,297
Hi All
When a Shopify Order is fully paid in Shopify before it Synced to BC how do we reconcile the BC bank account? Order synced to BC and it goes to warehouse but will take days to ship and invoice. In this scenario we cannot create a payment in BC as payment date will be prior to invoice date. How do others deal with this?
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 12,808 Super User 2026 Season 1 on at
    Hello,
     
    For prepaid Shopify orders, don’t post a BC customer payment before the invoice exists.
    Use a Shopify clearing G/L account instead.
    Money lands in the clearing account → you ship + invoice later → then apply the clearing entry to the invoice.
     
    That’s how most setups handle this.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at
  • Suggested answer
    Samantha73 Profile Picture
    Samantha73 3,297 on at
    ideal process is prepayment as when you generate order its actually paid but payment to account can work assume date doesnt matter if apply from AL code
  • Samantha73 Profile Picture
    Samantha73 3,297 on at
     
    This suggested process should work but the gap is sales order appears in BC as unpaid (and need to create an automatching process allocate payment after final invoice as otherwise statement/backend invoice send job will send payment due invoice to customer )
     
    "For prepaid Shopify orders, don’t post a BC customer payment before the invoice exists.
    Use a Shopify clearing G/L account instead.
    Money lands in the clearing account → you ship + invoice later → then apply the clearing entry to the invoice"
  • SP-13121535-0 Profile Picture
    SP-13121535-0 4 on at
    Did anyone ever fully solve this? We have that issue. We also have the issue with partially fulfilled orders in Business Central, where the suggest payments option is splitting the payment - invoice amount to the customer, and the other half undefined to a G/L account as it does not recognize the customer for some reason.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans