The transactions on voucher do not balance as per xx/xx/xxxx. (accounting currency: 400,00 - reporting currency: 400,00)

(0) Share

Report

Posted on by Community Member

Good morning,

Could anyone help me to figure the cause of this message error ?
It appears whenever I try to post a vendor invoice. I googled it and found that it may be related to the posting profile or the account under the item group ... But it's all there and well configured.

What I noticed is that the LabelID of this error is : "The transactions on voucher %1....." so it supposes that I have a number (voucher number) displayed in the error. But as you can see, it's not the case.

Also, I had a look on the code and found a log table SubledgerJournalErrorLog and I reached the Purchase orders that had this error but I couldn't figure out WHY and the cause of this error.

I cannot debug since the environment is deployed in the Cloud.

Greatful for you consideration and help.

I have the same question (0)

All responses (11)

Answers (1)

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Please check your Posting setup from Inventory management. you need to setup 'Accrual', PO expenditure uninvoiced, purchase expenditure .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thank you for your response.

it's already setup in the Purchase Order tab.

Was this reply helpful? Yes No
Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

It is unusual that it's showing %1 in the standard error message. I have a feeling it is related to the issue somehow, perhaps a missing number sequence? I am just guessing here. Please add more information to make it easier for us to help.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HiAnton,

thank you for your response.

The standard message is not showing the character %1.

I mentioned that the LABELID (as joined in the picture) has %1 written in order to display the voucher number in the message). However, the error showing is this :

"The transactions on voucher do not balance as per xx/xx/xxxx. (accounting currency: 400,00 - reporting currency: 400,00)"

so it is missing the number of the voucher.

Was this reply helpful? Yes No
Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

I see. It is strange that the voucher is missing. Did you check if the number sequences are setup?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes they are setup I checked

Was this reply helpful? Yes No
Suggested answer

Sheela Ningappa on at

Like (0)

Report

Hi,

Are you entering both Main and offset account in one line in the journal or in 2 lines. Means; one line with Debit value and other line with Credit value?

If you are using 2 different lines, have you checked if voucher number created in both lines are same or different? If the voucher number is same in both lines, that means, the transaction is balanced. If somehow 2 different voucher numbers are created, that means the transaction is not yet balanced. If this is not yet balanced, then delete the other voucher number and re-create the line again.

Also- please check Maximum penny rounding differences and Maximum penny-differences.

Thanks,

Sheela

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Good morning,

it's the standard process that is posting the invoice.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have to mention that we have upgraded D365 to the version 10.0.16 with platform Update 40.

We investigated and debugged and found that the VENDOR BALANCE posting type is posting in the side of the DEBIT whereas the mainaccount is setup to write in the CREDIT column...

Could this be caused by a new Feature that is not enabled?

Was this reply helpful? Yes No
Verified answer

Corina Manescu on at

Like (1)

Report

Hi Naycene,

A similar issue was reported/investigated and fixed via the request 538008 - Posting of financial document throws following error message 'The transactions on voucher do not balance as per 12/18/2020. (accounting currency: 200.00 - reporting currency: 200.00)''. The fix was backported to 10.0.16 release starting with the build 10.0.689.10023.

https://fix.lcs.dynamics.com/Issue/Details?kb=4600641&bugId=538008&dbType=3&qc=a1c86283d726e216e3b0b0884a02c1dd9dd7ce17d3119e4eec6f95235b6c801e

Could you please check if the feature “Intercompany Expense report financial dimension enhancement” is enabled? If this is the case, please disable this feature and retest the scenario.

Thank you,

Was this reply helpful? Yes No