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

(0) Share

Report

Posted on by Magno Pereira

2,435 Moderator

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

I have the same question (0)

All responses (15)

Answers (1)

Verified answer

Magno Pereira 2,435 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Magno Pereira 2,435 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Magno Pereira 2,435 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Magno Pereira 2,435 Moderator on at

Like (0)

Report

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:

Thank you in advance!

Was this reply helpful? Yes No
Magno Pereira 2,435 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Katy3992 322 on at

Like (0)

Report

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?

Was this reply helpful? Yes No