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

(0) Share

Report

Posted on by MahGah

15,435

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.

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

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

Thanks

All responses (2)

Answers (1)

MahGah 15,435 on at

Like (0)

Report

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

Hi Mr Zhu

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

YUN ZHU 79,044 Super User 2025 Season 1 on at

Like (0)

Report

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

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