Skip to main content

Notifications

Announcements

No record found.

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

  • axerp Profile Picture
    axerp 2,600 on at
    RE: Journal amount

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal amount

    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
    axerp 2,600 on at
    RE: Journal amount

    I would much appreciate any help with this.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal amount

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans