Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Missing or incorrect ledger account when posting batch/multiple free text invoices

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello - Hoping someone can help me out...I've been stumped after scouring the internet.

Basically, when the user generates recurring invoices, they generate fine. (he does this as a multi-group) and not selecting a specific customer/template. (below)

But when he goes to post them, they not all of them actually post and I'm thinking that its because they generate the error below.

"One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid.
Use the Accounting distribution form or the Posting profile to update the ledger account."

I searched for this error and all I see are answers as they relate to Purchase Orders, not free text invoices...and since this is done in "batch", I don't see a way to place breakpoints and interactively step through the code.

But he is able to post each individual Invoice, one-at-a-time at the end of each month, but this causes much frustration. This just started happening recently.

I did a search for this particular error within the code and found that its thrown when there is a "0" in the ledger dimension field of the AccountingDistributinon table and ran the same sql query that I found in that method in the AOT, but I found no records with a zero.

There is another condition where it will throw the error but I'm unable to decipher what its checking for without being able to step-thru/runtime and debug...

Can anyone provide insight? thanks.

*This post is locked for comments

  • CU06090812-0 Profile Picture
    CU06090812-0 2 on at
    Missing or incorrect ledger account when posting batch/multiple free text invoices
    Did you ever solve this issue?
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Missing or incorrect ledger account when posting batch/multiple free text invoices

    Hello picklepete,

    I found three hotfixes on LCS that seems to address the issue described.

    See e.g.

    KB 2965193"One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid" error when posting free text invoices

    Can you check them and verify whether they overcome your issue?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing or incorrect ledger account when posting batch/multiple free text invoices

    Thanks for your replay Andre` ...the error in the Infolog in the smaller screenshot above is:

    "One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid.

    Use the Accounting distribution form or the Posting profile to update the ledger account."

    I am a developer, but the frustrating part is that I don't know how I can breakpoint/debug the process because I only see the option to batch run the posting process...

    another puzzling problem is that when I did a search for this error in all classes in the AOT (@SYS340058) I commented out the part where the error gets thrown (and also commented out the bit where the validation gets set to false) and the error still gets thrown...

    I've hit a brick wall...

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    RE: Missing or incorrect ledger account when posting batch/multiple free text invoices

    Hi Picklepete,

    The second screenshot is too small to be able to read it. Can you repost it? If the user can post them one-by-one, then I do think the setup is correct. There might be an orphaned record which could cause this issue. Did you ask a developer to debug this scenario?

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! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans