Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

(0) ShareShare
ReportReport
Posted on by 2,429 Super User 2024 Season 2

Hi,

I was posting a General Journal, when I had the following error:

The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

Do you have any idea how to fix it?

AX version is 2012 R3 CU13

Thank you in advance!

*This post is locked for comments

  • Verified answer
    Magno Pereira Profile Picture
    Magno Pereira 2,429 Super User 2024 Season 2 on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Hi all,

    Finally, we've found the issue.

    The issue occurs when we have a journal with a vendor line and two or more ledger lines in the same voucher.
    When we've removed the invoice number in the ledger lines, we successful posted the journal.

    General Journal

    Thank you!

  • Magno Pereira Profile Picture
    Magno Pereira 2,429 Super User 2024 Season 2 on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    We only have this issue when we are using two offset lines with different sales tax codes. Now, we are trying to discover why.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Hello Magno Pereira,

    I have seen similar issues with integrations that were caused by $ rounding issues.

    Can this be the underlying issue in your case also?

    That is, how are the numbers transferred? With multiple decimal places, rounded, etc.?

    Best regards,

    Ludwig

  • Magno Pereira Profile Picture
    Magno Pereira 2,429 Super User 2024 Season 2 on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Hi Ludwig,

    Manually it's work.

    However, by integration, the issue still happens.

    Yes, it's our Corporate Chart of Account. Associate to each Main Account we have a Corporate Chart of Account.

    We still looking to account structure and advance rules to find an inconsistency.

    Thank you!

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Hi,

    Can you delete the amounts and retype them manually in the journal?

    I am wondering whether this makes a difference.

    Another thing:

    Why does the account-FinDim string in the second line show 6628 twice? Is this your ledger account or something else?

    Best regards,

    Ludwig

  • Magno Pereira Profile Picture
    Magno Pereira 2,429 Super User 2024 Season 2 on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Hi Ludwig,

    It's an uploaded journal by API.

    Here you are:

    5557.TESTE.png

    Thank you in advance!

  • Magno Pereira Profile Picture
    Magno Pereira 2,429 Super User 2024 Season 2 on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Katy3992,

    Yes, I did. It's an upload journal by an API.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    Hello Magno Pereira,

    Can you share details of the voucher that triggers this error message?

    Attaching a screenshot would be ideal.

    How did you create the journal (manually or through an upload)?

    Would be great if you could show us the journal and voucher.

    Many thanks and best regards,

    Ludwig

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: The transactions on voucher XXXX do not balance as per <date>. (Company currency: XXX.XX - secondary currency: XXX.XX)

    It seems strange to me that it happens although you created a new line. I had the issue with posting a product receipt, but in the journal it always worked at least after deleting the journal and creating a new one ... :-( did you already try 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans