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 - Handle overp...
Small and medium business | Business Central, N...
Suggested Answer

Shopify - Handle overpayments in cash receipt journal

(3) ShareShare
ReportReport
Posted on by FD-13061304-0 6
Hello,
 
Our setup between Shopify and Business Central currently results in differences of calculation of taxes. When the invoice is sold in Shopify, the total might be 25.01, as when Business Central does the sales invoices, it comes out at 24.99.
 
When using the Suggest Payments reports in the cash receipt journal, the system thinks that there is an overpayment of 0.02. It will add a line for this amount, the Account Type is marked as a G/L Account, but there is no G/L specified. Is there a way to configure this behavior to include a G/L by default?
 
In the other case, when the calculation results in a underpayment, the tolerance mecanism automaticlly takes over.
 
Thank you
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,555 Most Valuable Professional on at
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,169 Super User 2026 Season 1 on at

    This issue with GTIN and original price not syncing in the Shopify connector seems unusual. I haven't encountered this problem with the standard Shopify connector. It suggests there might be an issue with the default connector's specific behavior in your environment. I recommend you contact the Dynamics 365 Yammer Group or your Microsoft partner for further assistance, as this might be a unique scenario or configuration oversight.

    ✅ Mark this answer as verified if it helps you.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,417 Super User 2026 Season 1 on at

    Hello,

    Thank you for your question.

    The issue you're encountering—where minor tax rounding differences between Shopify and Business Central result in overpayments (e.g., 0.02)—is common in multi-platform integrations. When using the Suggest Payments function in the Cash Receipt Journal, Business Central attempts to reconcile the difference by creating an additional line, but as you've noted, the G/L Account is not automatically populated.

    Recommended Configuration:

    1. Set Up a Default G/L Account for Overpayments
      You can configure a default G/L account for overpayments by navigating to:

      General Ledger Setup → Payment Tolerance
      • Ensure that Payment Tolerance Posting is enabled.
      • Specify the G/L Account to be used for overpayments under the Overpayment G/L Account field.

    2. Define Payment Tolerance Limits
      In the Customer Posting Group or General Ledger Setup, define the maximum allowed overpayment amount. This ensures that small differences (e.g., 0.01 or 0.02) are automatically posted to the designated G/L account without manual intervention.

    3. Review Journal Templates
      If the G/L account is still not populated, check the Cash Receipt Journal Template and Batch settings to ensure that default accounts or dimensions are not interfering with the posting logic.

    4. Custom Posting Logic (Optional)
      If your business requires more granular control, consider implementing a customization or event subscriber to automatically assign the appropriate G/L account when such differences are detected.

    This setup should help streamline the reconciliation process and eliminate the need for manual corrections when minor overpayments occur.

    Please verify if this response was helpful.
    Best regards.

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