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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cross rate currency ca...
Microsoft Dynamics AX (Archived)

Cross rate currency calculation method

(0) ShareShare
ReportReport
Posted on by HNG 25

Hi All,

I wonder where can I configure cross rate Calculation method?

Sample:

Company currency : AUD

Vendor Tax Invoice: USD.

Exchange rate: AUD 1 = USD 0.78  

 currency1.PNG

Cross rate display in payment voucher is  USA 1 = 1.28205 AUD ( Photo as below)

cross-rate.PNG

My question: How can AX display 1 AUD = USD 0.78 in our payment voucher? We need to send this information to our bank. therefore if AX can display this rate in our voucher then we can avoid a hard code in our bank file.

TIA.

Regards,

HN

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi HN,

    In the vendor payments journal - settlement form you have the cross rate field available that will be used for making payments. Is this what you are looking for?

    Best regards,

    Ludwig

  • HNG Profile Picture
    HNG 25 on at

    Hi Ludwig,

    Thanks for your reply however It is not what I am after as I don't want to change the cross rate manually. and also the rate is allready correct. However in stead of displaying   AUD 1 = USD 0.78, AX now display 1 USD = 1.28 AUD.

    Both ways are correct exchange rate however we need  AX to display AUD 1 = USD 0.78 in Exchange rate field in order for our technical to pick up the value ( avoid hard code).

    Regards,

    HN

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi HN,

    What do you mean that you technical needs to pick up the value?

    Is he/she exporting something from AX through an interface or something alike?

    Best regards,

    LUdwig

  • HNG Profile Picture
    HNG 25 on at

    H Ludwig,

    Yes, we are making international payment and intergate to Bank system ( third party) follow the file format MT101 international banking payment. It requires the exchange rate  which I have mentioned above. I don't want to hard code to convert the exchange rate in order to avoid any rounding issue which can make a different between AX transaction and Bank transaction.

    That's why I am trying to find a standard functionality which I can use. But  it looks like I have to customize it.

    Thanks so much for your patient.

    Regards,

    HN

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi HN,

    Couldn't you setup exchange rates that make use of the reciprocal rates? If you have already started working with AX this is something I would possibly not do because it might confuse people. However, if it is a 'fresh' system setting up a new exchange rate type and exchange rates with the reverse rates should be feasible.

    If you already worked some time with AX you would have to modify the way how the MT101 file is filled.

    Best regards,

    Ludwig

  • HNG Profile Picture
    HNG 25 on at

    Thanks Ludwig,

    We have used AX for couple years. By the way, we already customize a new EX convertor field which will display the rate from company currency to foreign currency. this field will inherrit the rate from currency exchange rate then allow to overwrite if needed. The value then will flow to MT101 template when we generate the payment.  

    All is ok now. Thanks so much for your comment.

    Regards,

    HN

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans