You’re offline. This is a read only version of the page.
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?
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.
What API are you calling from Power Automate? A standard or a custom made API?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (