One or more accounting distribution is missing a ledger account

This post describes how to fix the issue when the error message ” 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. ” appear in the purchase order confirmation.

1/ Error message

Access: Accounts Payable > Common > Purchase orders > All purchase order

  • Create a new Purchase order.
  • Select Item number and other informations.
  • Click on “Confirm”.
  • An error message appears.

DistributionAccAP001

This error message appears because one or several ledger accounts are missing in the setup. You have to fix the posting profile setup (for the next purchase orders) and the line of the purchase order.

2/ Correction in the purchase order

  • Go to the purchase order line
  • Click on Financials > Distribution amounts

DistributionAccAP002

  • You can see the the “Ledger account” field is empty. That is the origin of the error.

DistributionAccAP003

  • Enter the ledger account missing.
  • And close the accounting distribution form.

DistributionAccAP004

  • You can now confirm and post your purchase order.

Remark: you can also open the Accounting distribution form from the Purchase tab > View distributions. By this way, you can see all the lines (better option if you have several lines in your purchase order).

DistributionAccAP005

3/ Correction in the Posting profile form.

Access: Inventory & warehouse management > Setup > Posting > Posting

  • Go to the tab Purchase order
  • Check if all ledger accounts are setup.

DistributionAccAP006

  • In my case, the “Purchase expenditure for expense” was not filled for all item groups.

DistributionAccAP007

Advertisements

8 thoughts on “One or more accounting distribution is missing a ledger account

  1. Thank you for the post.

    Even i have configured all the accounts in the item posting still i am getting the error.

    So i click Purchase order – > Accounting distribution but the from is non editable and not allowing me to select the Ledger account as you said .

    What could be reason and how to resolve ?

    Thanks in advance.

    Reply
  2. Pingback: [ ax2012 ] One or more accounting distributions is missing a ledger account. Use the Accounting distribution form or the Posting profile to update the ledger account. | dsin

  3. Thank you for the post. I have a similar issue, just in my case the amount that is missing the main account is the Tax value. And in this case the ledger account is not editable. I have the VAT posting set, also the vendor and product. Where else would I need to set the posting profile so to not have this error.
    Thank you for the help.

    Reply
  4. I have a similar issue but in the Product Receipt Form. The account distribution is actually showing in the PO financials accounting distributions but the field is blank in the product receipt\view distributions. the record is not editable and AX is not letting me cancel the receipt either. Any help\suggestions is much appreciated.

    Reply
      • Hi Bella,

        I updated the record in SQL to enter the appropriate financial dimension.

        Farokh

        Farokh Bayegan Senior Director, Financial Systems | comScore, Inc. (NASDAQ:SCOR)

        o +1 (703) 438-2338 | m +1 (703) 581-8779 | fbayegan@comscore.com

        11950 Democracy Drive | Suite 600 | Reston | VA 20190

        ……………………………………………………………………………………………..

        comScore is a global leader in digital media analytics. We make audiences and advertising more valuable. To learn more, visit http://www.comscore.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s