Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Journal amount

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans