Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales Order - The tran...
Finance | Project Operations, Human Resources, ...
Answered

Sales Order - The transactions on voucher XXXX do not balance as per .

(0) ShareShare
ReportReport
Posted on by Fabio C. 230

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:

  • Posting profile is unique and it is set as default on GL parameters;
  • Item posting for the same customer is already defined linking item group and customer group;
  • dimensions are defined on the sales order header.

Moreover on 18 March 2020 a similar invoice was posted for the same customer.

Do you any other suggestions?

Thank you,

Fabio

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per .

    Thanks Ludwig,

    we checked the KB and we find out that a new one was released just one month after our upgrade.

    Case closed ;)

    Best regards,

    Fabio

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per .

    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?

    Best regards,

    Ludwig

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per .

    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?

    Best regards,

    Fabio

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per .

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per .

    moved to the ax forum

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per <date>.

    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.

  • JCALLES1984 Profile Picture
    JCALLES1984 40 on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per <date>.

    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

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales Order - The transactions on voucher XXXX do not balance as per <date>.

    System is AX 2012 R3 last CU

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans