"One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid" Error while posting Vendor Invoice

(0) Share

Report

Posted on by Community Member

I have been getting this error above for the last day and cannot figure out why the system is not picking up my account numbers. I have picked through many of the topics already on this forum and tried every suggestion I can see to configure this. Please see screenshots below of the configuration. The invoice is for 1 "Television" with item number 454545.

Item 454545 belongs to "DP Items" Item Group:

DP Items group has had Posting rules configured for the group:

I even ensured that the account numbers were in the "Accounting Structure" setup:

But the ledger account is still blank in the Subledger Journal and Accounting Distribution screens:

And of course, this error occurs when attempting to post:

Can someone please help me out to find the setup missing? I am unable to continue with my work until I can get an invoice successfully posted in the system. Please note, I am a developer and so I have very little knowledge of the ERP and accounting. So if there are setup tasks I forgot, please provide menu paths to the process and what the data should look like. Thank you very much for any assistance you can provide.

All responses (4)

Answers (1)

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: "One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid" Error while posting Vendor Invoice

Evan, did you delete the line and enter it again by any chance?

Not sure how a system restart would take care of filling in the accounts :)
Verified answer

Community Member on at

Like (0)

Report

RE: "One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid" Error while posting Vendor Invoice

Hello Gunjan, so I am not sure what happened, but the accounts just started appearing after many attempts at resetting the system. The functionality seems shaky as I restarted the system many times with no resolution and now after about the 6th restart, the number now appear. I get a different error now about the transactions not balancing. I guess off to research another issue. Thanks for your help!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: "One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid" Error while posting Vendor Invoice

Hi,

I noticed that the setup has been made in the DAT company.

This company is not supposed to be used for recording transactions.

Can you make the same setup in one of your other companies and try again?

Best regards,

Ludwig
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: "One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid" Error while posting Vendor Invoice

Hi Evan,

Have you tried clicking on Reset in the accounting distribution screen?