Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

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

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?

  • Suggested answer
    TabrezAjaz Profile Picture
    TabrezAjaz 190 on at
    RE: API Sending Currency in Power Automate Flow but Business Central is Ignoring it

    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
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: API Sending Currency in Power Automate Flow but Business Central is Ignoring it

    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans