Notifications
Announcements
No record found.
Hello,
we are experiencing the error The transactions on voucher XXXX do not balance as per <date> during the invoice posting of a sales order with several lines.
We already checked the following setup:
Moreover on 18 March 2020 a similar invoice was posted for the same customer.
Do you any other suggestions?
Thank you,
Fabio
System is AX 2012 R3 last CU
It looks to me the message is pointing out that you have "valuta di dicharacione=0" whereas the "valuta di contabiliazzione" has a different value. Have you check Tax calculations or change something related to "valuta di dicharacione" in the general ledger module?
Regards
Hi,
unfortunately the sales order has the same currency EUR of the company.
Reporting currency is not defined in the ledger, moreover other invoices in the same period work well.
thank you.
moved to the ax forum
Good Morning Fabio,
Can this be related to a rounding issue and a missing rounding account for picking up penny differences?
Can you very this by having a look at whether or not automatic posting accounts for rounding are setup in the respective GL form.
Have you also double checked the inventory posting matrix under inventory-setup-posting-posting to ensure that all cost & revenue accounts are in place?
Best regards,
Ludwig
Hello Ludwig,
thanks for your reply.
I already found the problem, it is linked with total discount on sales order header, indeed with total discount the base amount differ from the invoice total of -0.11.With no total discount the invoice was posted without any error.
Do you have links or a good explanation about the total discount calculation?
Hi FBA,
I found an old hotfix on LCS that seems to be related to what you describe.
KB 3146338"The transactions on voucher do not balance" error when posting a SO invoice with a total discount and misc charges
Yet, this fix was already released in 2016 and I would expect that you are on a more recent version.
Anyway, maybe let a developer have a look at this fix to verify that this is not the issue into which you run.
About total discounts in general: I don't like them at all because of the way they are accounted for. Do you really need them and/or can't you apply them at the line level to avoid this issue altogether?
Thanks Ludwig,
we checked the KB and we find out that a new one was released just one month after our upgrade.
Case closed ;)
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
