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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Question on how exchan...
Microsoft Dynamics AX (Archived)

Question on how exchange rate is calculated at general journal posting

(0) ShareShare
ReportReport
Posted on by Community Member

Hello All,

I am trying to reverse engineer some code in AX 2012 which creates records in the LedgerJournalTrans table (including setting the value for LedgerJournalTrans.ExchRate) and then posts the journals.

My question though is, how does AX use the LedgerJournalTrans.ExchRate value to calculate the amount to post for the Accounting Currency and Reporting Currency fields? Or does it use some other method?

In other words, how does a record get from the LedgerJournalTrans table, with only the transaction currency amount, into GeneralJournalAccountEntry table with the correctly converted Accounting and Reporting Currency amount.

Thank you,

Phil

*This post is locked for comments

I have the same question (0)
  • Pranav Kumar Profile Picture
    Pranav Kumar Microsoft Employee on at

    Hi Phil;

    When you create a general journal, system picks up the exchange rate automatically, you can see the exchange rate on general tab. Exchange rate comes into picture when you post any voucher having currency different than entity currency but in case of reporting currency, you don't have that good visibility.

    I would rather stress on the business requirement here as playing with exchange rate can be difficult. The reason is because AX also supports for example forced rate feature where the system exchange rate overridden by the one mentioned in journal by user.

    So if you elaborate the business requirement, then probably some ways can be found without changing any code.

    Pranav

  • Community Member Profile Picture
    Community Member on at

    Pranav,

    I apologize, I am not currently trying to change any code, I am trying to figure out what someone else's code has already done. We are already forcing in an exchange rate in this implementation, and I am trying to tack down exactly how it is populating the reporting currency amount.

    And when you say " Exchange rate comes into picture when you post any voucher having currency different than entity currency" is entity currency the same thing as accounting currency?

    Thank you for you help,

    Phil

  • Pranav Kumar Profile Picture
    Pranav Kumar Microsoft Employee on at

    Hi Phil;

    It will be great if someone shares some modification experience here. What i have seen is in the secondary currency, system picks exchange rate on it's own.

    I was referring to accounting currency in my post above.

    Pranav

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dserp Profile Picture

dserp 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans