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

Processed Currency Handling wrong on Shopify Orders

(3) ShareShare
ReportReport
Posted on by 164

Hi,

A client I am helping is having an issue with wrong currency on credit memos created from Shopify refunds.

They sell in different currencies in Shopify and the currency on the sales orders that are created in Business Central is correct (presentment currency from Shopify order). But - when they create a credit memo from a Shopify refund the credit memo is always created in LCY which is wrong.

We have found the reason for this - the field “Processed Currency Handling” value on Shopify orders is “Shop Currency” on all Shopify orders. Then we tried to change that value to “Presentment Currency” and after that we could successfully create credit memos in correct currency from the refunds connected to the Shopify orders. We have tested this on several orders and are 100% sure that the value in the Processed Currency Handling field is the cause of this issue.

So now to the question - how can we make all imported Shopify order get the value “Presentment Currency” in the Processed Currency Handling field? And yes, the setting on the Shopify shop card already has that value.

Thanks in advance,

Jim

  • Suggested answer
    GM-01082130-0 Profile Picture
    15 on at

    Hi Jim, you can’t control this from setup I’m afraid. The field is not filled at import. It is stamped once, when the sales document is created, as a copy of Currency Handling from the shop card, so a refund follows the same currency as the original order even if the shop setting changes later.

    That means orders processed before the shop card was switched keep Shop Currency. Same for everything processed before v28, the field came with that version I think, and there’s no upgrade routine filling the old orders, they just sit on the default. For those I see only a one-time data fix, like you did in your test.

    New orders should get the right value on their own. If one processed today still shows Shop Currency, that looks like a bug and I’d raise it with Microsoft. Were your test orders processed before the upgrade, with the sales order currency coming from a customisation?

    Glad to help - follow up if anything is unclear.   

    ►  If this solved it, marking it verified helps others too.       

    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

  • Jim Oskarsson Profile Picture
    164 on at

    Hi Grigorios,

    Thanks for your answer.

    The setting on the Shopify shop card is set to Presentment Currency and we have never changed that. Even though, the Processed Currency Field on the Shopify orders is always set to Shop Currency by the Shopify Connector.

    As you write, it may be a bug or it may be something in this environment that causes this.

    Can you confirm that it works as expected in environments that you have access to? This is the first multi-currency Shopify integration that we have set up so I can not check how it works in other places.

    Thanks,

    Jim

  • Suggested answer
    OussamaSabbouh Profile Picture
    20,817 Super User 2026 Season 2 on at

    Hello Jim,
    There should be no separate setup for this: Microsoft documents that when Currency Handling = Presentment Currency on the Shopify Shop Card, Business Central should store that choice on each Shopify order when the order is processed, and both sales orders and refund credit memos should then use the presentment currency. The important point is that changing the Shop Card setting does not retroactively change orders that were already processed—those keep their stored Processed Currency Handling value. However, if completely new Shopify orders processed after the Shop Card was already set to Presentment Currency are still getting Processed Currency Handling = Shop Currency, that does not match the documented behavior and I would treat it as a connector issue: first confirm you are on the latest BC/Shopify Connector update, then raise it with Microsoft rather than adding customization. For existing affected orders, changing the stored value before processing the refund is a reasonable workaround, as you already confirmed.

    Regards,
    Oussama Sabbouh

  • Jim Oskarsson Profile Picture
    164 on at

    Hi Oussama,

    Thanks for looking into this. I have now had a developer check that we have done no customization that could break the standard functionality and he confirmed that is not the case.

    So what we will do is to build a workaround that sets Currency Handling to Presentment Amount before creating credit memos.

    Of course the best would be also to report this bug to Microsoft. Where is the best place to do that?

    Thanks,

    Jim

  • Suggested answer
    YUN ZHU Profile Picture
    104,090 Super User 2026 Season 2 on at

    I suggest submitting this to Microsoft as a support ticket. It looks like an issue with the standard product.

    Alternatively, you can share this question on Viva Engage below. Microsoft engineers active there can give you better insights.

    (1) Viva Engage - BC Partners | Integrations

     

    Thanks

    ZHU

  • Jim Oskarsson Profile Picture
    164 on at

    Thanks to you all three who has responded. I will raise a support ticket with Microsoft as it looks like an issue with the standard product.

    Best regards,

    Jim

  • Sajjad Yousuf Anjum Profile Picture
    159 on at

    Hi @Jim Oskarsson 
    Raising the ticket is the right call. While it's open, a couple of things may help: 

    1. Include in the ticket the Shopify Connector version (Extension Management), the shop code, and two order IDs – one imported after the shop card was set to Presentment Currency – so Microsoft can confirm whether it's a stamping bug. 

    2. If you have more than one Shopify Shop card, check the setting on each; orders take the value from the shop they were imported through. 

    3. Rather than fixing orders manually before each refund, a small per-tenant extension can subscribe to the connector's order events (codeunit "Shpfy Order Events", e.g. after the order header is imported) and set the field to Presentment Currency when the shop is configured that way. Please verify the exact event name in your connector version. This is easy to remove once Microsoft ships a fix. 

    4. Check refunds already posted in LCY – those credit memos may need correcting/reversing. If this helps, please mark it as verified.

  • Suggested answer
    Assisted by AI
    JasonBrown Profile Picture
    6 on at

    @Jim Oskarsson 

    I checked the Shopify Connector source, which is public in Microsoft's BCApps repository, and this is a known bug that Microsoft fixed on 6 October 2026.

     

    Pull request #12214, "[Shopify] Store currency handling for auto-created orders", explains it: when orders are created automatically during sync, the connector built the sales document with the shop's currency handling but didn't reliably store it on the Shopify order, so Processed Currency Handling could be left at Shop Currency. Refund credit memos read that stored value, which is why yours come out in LCY while the sales orders are right. The fix stores the value in the same step that creates the sales document.

     

    The fix is on the main branch (connector version 30). I couldn't find it on the 29.x release branches yet, so it probably isn't in your environment. In your support ticket, quote PR #12214 and ask whether it will be backported to your version.

     

    One note on the extension idea above: the connector's OnAfterProcessSalesDocument event is internal, so another extension can't subscribe to it. Your plan of setting the value before creating the credit memo is the practical workaround until the fix reaches you.

     

    Source: https://github.com/microsoft/BCApps/pull/12214

    If this helps, please tick "Does this answer your question?" so others with the same problem can find it.

     

  • Assisted by AI
    JasonBrown Profile Picture
    6 on at

    @Sajjad Yousuf Anjum @Jim Oskarsson 

    A correction to my reply: I was wrong that the internal event can't be subscribed to. In AL, a publisher's access modifier only limits who can raise the event, not who can subscribe, so an extension can subscribe to the Shpfy Order Events. If you go that way, test that nothing later in the processing overwrites the value you set.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 664 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 446 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 282 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans