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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Journal amount

(0) ShareShare
ReportReport
Posted on by 2,600

Hi All ,

When ever we do the foreign currency transactions in the Payment journals / Invoice journal system would post the journal amount in local currency to voucher transactions, but that amoount is not rounding to nearest value.

For example : Customer currency @USD in Customer master  , User created customer payment journal in USD currency , credit amount - 1577.28@61.87 -Ax calculates the amount 97586.31 as company currency.

But client says that amount 97586.31 should round to 97586.00 in Payment journal and post to Voucher transaction table.

Same way customer can receive the payment in other currencies also ( AUD, CAD,...)

Can i know how to achieve the above requirement in Ax ? and 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    I suggest you need to consider a customization in order to round the calculated amount.

  • axerp Profile Picture
    2,600 on at

    I would much appreciate any help with this.

  • Suggested answer
    Community Member Profile Picture
    on at

    Try to explore following class CurrencyExchangeHelper in dynamics AX

    In this class you will find some of the method which will basically convert amount from once currency to another.

    As per my understanding those methods will be in use as part of logic which calculates the amount..

    I suggest you to find out that method and review the logic and implement the rounding logic which you require

    Please verify and update with your findings.

  • axerp Profile Picture
    2,600 on at

    Thank you for the reply Nitish,

    I am sure that we need not to do any customization , becuase this is the common requirement in ERP's. I think some setup is available to get the results. I am missing that setup.

    Let's us see any Functional consultant can throw some light on this.

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 Giving Solutions is Here!

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans