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) / Posting General Journa...
Microsoft Dynamics AX (Archived)

Posting General Journal with Rounding difference in the Reporting Currency

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

We are trying to load in a journal into a company using the local currency. The company in AX is setup with a different reporting currency. When I enter the Journal and validate it I get an error stating "The transactions on voucher EDD-000000003 do not balance as per 12/1/2017. (accounting currency: 0.00 - reporting currency: 0.01)". How do I resolve? I have checked the setup for the rounding settings on each currency involved and setup Accounts for Automatic Transactions to deal with Reporting Currency Conversion Gain/Loss but am still unable to post this transaction.

Thanks,
Garrett

*This post is locked for comments

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

    Hello Garrett,

    Sometimes Excel rounds different than AX.

    What you can do is not allowing Excel to use its normal calculation and rounding functionalities but (manually) overwriting the amount or truncating the number of decimal places uploaded.

    Another alternative - if only a couple of vouchers are affected - is posting the journal by making use of the post and transfer functionality.

    What this will do is transferring the voucher that makes the problem to a new journal.

    When making this transfer, the Dynamics rounding rules are used and it might be the case that you can post the transaction directly thereafter.

    Would be great if you could test those options.

    Best regards,

    Ludwig

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you for the help. I figured out that it was a setting under the General Ledger Parameters. The "Maximum penny-rounding in the Reporting Currency" field was set to $0.00. Because of that it would not allow any variance in the journal lines and was not using the rest of my setup I had done.

    Thanks,

    Garrett 

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

    Hello Garrett,

    Many thanks for this update.

    Would be great if you could finally verify and close this thread.

    Thanks,

    Ludwig

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