I would suggest that the Shopify connector does not recalculate currencies on orders imported from Shopify in stores running markets, which is quite common.
From what I can see, orders are imported in the checkout currency into BC and then converted to the Shopify store base currency, which would be an optional step, not a forced one.
It looks like all the data tags along, and in the transactional tab in the Shopify connector in BC, the checkout currency is present. Still, when it turns into a sales order in BC, it's recalculated to the Shopify base currency for unknown reasons.
So my suggestion would be to make that extra conversion optional - Let checkout currency be sales order currency and posted sales order currency.
Comments
Has anyone tried to retrieve data via the API from Shopify to create sales orders with amounts in the correct currency?
Category: Sales
We have a company that trades with multiple currencies. We experience that Shopify cannot handle currencies, as there is no currency code on Shopordre and amounts are transferred in accounting currency. This happens despite the fact that we use customer templates that define the currency code based on the country code. We experience that the code for creating a sales order in BC uses the currency code from the shop order, which is blank and therefore uses LV.If we code that the currency code should be retrieved from the customer and used on the sales order. Then the currency code on totals is shown correctly, but amounts are still inserted in LV when they are transferred from Shopordre. It would be my opinion that many of the challenges we experience could be solved by: That the Currency code, amount in Total and VAT amount were shown in the currency in which the customer had purchased the item. Information that must be stated in the Order Confirmation to the customer.The same company also has a US tenant that also uses Shopify. Here we do not experience similar problems, but here Avalara is also used at the same time.
Category: Sales
his is a significant issue for companies selling in multiple currencies, like ours. We are unable to use this connector solely because of this limitation. All orders are being converted to the local currency.
Category: Sales
We sell in multiple currencies and having it convert is causing issues. This is something that needs to be included in the roadmap. We sell in multiple currencies and having it convert is causing some major headaches.
Category: Sales
It makes no sense that the DEFAULT behavior is to change the currency of a transaction.
Category: Sales
I agree, there's no reason to convert the presentment amount and currency to store currency, this causes problems reconciling payments to invoices.
Category: Sales
This is definetly something that needs to be included in the roadmap. We sell in multiple currencies and having it convert is causing some major headaches.
Category: Sales
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team