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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Use fx-exchange as Currency Service in BC - This can be used for many currencies

(0) ShareShare
ReportReport
Posted on by 15,529

Hi

I know many companies use floatrate for currency exchange service in BC. But I wonder if someone can help me with fx-exchange setup. Since they have lots of different RSS for different currencies they can be used in many different countries if we can define the "transfer rules". 

The USD rss looks like below and output is like below as well. Now I wonder what are the transfer rule for below? 

1) How we get the AED from the below text for currency using transfer rule? I mean length of each currency is different. Is it any logic that start from 2nd last character of text and go back 3? This is the part I struggle the most with it. yzhums TeddyH JAngle  any help here will be greatly appreciate it.

pastedimage1646850395310v3.png

2) How we convert the following text date to actual date? any specific logic to does this in transfer rule? 

pastedimage1646850448526v4.png

3) How get the exchange rate from the following text? 

pastedimage1646850481465v5.png

Thanks 

pastedimage1646850123368v2.png

pastedimage1646849983484v1.png

I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    95,649 Super User 2025 Season 2 on at

    Hi, sorry i didn't try it. I think Custom Transformation Rules can do it.

    But it might need some customization, writing some special rules.

    I mentioned something at the bottom of the following post.

    https://yzhums.com/7341/

    More details:

    https://docs.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions#to-map-columns-in-the-data-file-to-fields-in-

    Hope this will help.

    Thanks.

    ZHU

  • MahGah Profile Picture
    15,529 on at

    Hi Mr Zhu

    Thanks for info. I just admit that I failed. I could not make it to work. Thanks again.

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

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 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans