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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

API Sending Currency in Power Automate Flow but Business Central is Ignoring it

(0) ShareShare
ReportReport
Posted on by 15

A customer that I am currently working with has a Power Automate flow between Dyanmics Sales and Business Central, this particular flow is to create journal entries for costs which would not be added to any sales or purchasing document.

The flow send the information fine, the issue comes when its a different currency. Although the currency is being sent in the payload and matches BC like for like in terms of spelling and case (and also having an exchange rate in BC), it is ignoring it which of course means the amount value is incorrect as it creates it as LCY which is £ rather than in the currency sent.

Why would it be ignoring the currency?

I have the same question (0)
  • Suggested answer
    TabrezAjaz Profile Picture
    202 on at

    Hi EchoAlpha,

    If the currency is being sent in the payload and matches Business Central like for like in terms of spelling and case, it's possible that the issue is related to the setup of the currency in Business Central.

    Here are a few things you can check to troubleshoot the issue:

    Check that the currency has been set up correctly in Business Central, including the exchange rate. Go to "Currency Exchange Rates" page in Business Central and make sure that the exchange rate for the currency is correct.

    Check that the user account used to run the Power Automate flow has the necessary permissions to create journal entries in the specified currency. Make sure the user has the "Posting to G/L Journal in Foreign Currency" permission set to "All" in their user setup.

    Check that the "Currency Code" field is included in the payload sent by Power Automate, and that it matches the exact spelling and case of the currency code in Business Central. You can also try sending the currency code in both uppercase and lowercase to see if that makes a difference.

    Check that the currency code is mapped correctly in the integration between Dynamics Sales and Business Central. Make sure that the currency code field in Dynamics Sales is mapped to the "Currency Code" field in Business Central.

    If none of the above solutions work, you may need to contact Microsoft Support for further assistance.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    What API are you calling from Power Automate? A standard or a custom made API?

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

News and Announcements

Season of Giving Solutions is Here!

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,472

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 684 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans