"One or more accounting distribution is missing a ledger account or ...

(1) Share

Report

Posted on by Torben Andresen @ C...

170

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

Hi Dynamics AX experts :-).

I'm struggling with setting up a very basic company in AX 2012. I have setup ledger accounts for all the posting types under Inventory Management/Setup/Posting... And I have created a Posting Profile that applies to all vendors.

Still, when creating a purchase order there is no ledger account applied to the distribution setup. I can confirm the order, but as soon as I try to do anything the requires posting to the ledger I receive an error like the one above.

Has anyone struggled with this too, and mayby found a solution?

Thanks in advance,

Torben

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Torben Andresen @ C... 170 on at

Like (0)

Report

Follow up. Apparently I can't post anything to Ledger. I just did a complete setup of projects and project catagories to try out posting in the project module. Now I get an error indicating that the accounts haven't been setup, though they are.

Am I missing some kind of global financial dimension setup?

Was this reply helpful? Yes No
Pranav Kumar on at

Like (0)

Report

Seems there is some problem with COA configuration. One of posting account has not been included in active COA configuration.

Pranav...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is probably more than you wanted. But I've been through the pain on this one. It helps to understand what's happening.

1. First Go to: Inventory and Warehouse Management > Setup > Posting > Transaction Combinations. This form allows you to define how you want to associate your financial accounts with your items. Look at the options under the heading labeled ‘Item Relation’:

a. You can tell the system that you want to associate your financial accounts to your items on an item by item basis by selecting the ‘Activate Item Relation Table’ checkbox.

b. You can tell the system that you want to associate your financial accounts to item groups by selecting the ‘Activate Item Relation Group’ checkbox.

c. You can tell the system that you want to associate your financial accounts to item categories within a catalog by selecting the ‘Activate Item Relation Category’ checkbox.

d. Finally, you can tell the system that you want to associate your financial accounts to all items by selecting the ‘Activate Item Relation All’ checkbox.

e. You can select any or all of the above Checkboxes.

2. Once you have set this up, go to: Inventory and Warehouse Management > Setup > Posting > Posting. This is the form where you set up the relationship between Items, Accounts and transactions. For example, if I needed to specify the default expense account that I wanted associated to the purchase of a given expense item, I would:

a. Click on the Purchase Order tab and select the ‘Purchase Expenditure for Expense’ radio button.

b. Click the ‘Add’ button to get a new record.

c. Under the ‘Item Code’ field, select ‘Table’, ‘Group’, ‘Category’ or ‘All’. This tells the system whether you want this account

i. Applied only for a single expensed item (Select ‘Table)

ii. Applied to all items in an item group (Select ‘Group’)

iii. Applied to all items in a Catalog \ Category (Select ‘Category’)

iv. Applied to all items in the system (Select ‘All’)

d. If you selected ‘Table’ or ‘Group’ in the ‘Item code’ field, you must select the specific item or item group as appropriate in the ‘Item Relation’ field.

e. If you selected ‘Category’ in the ‘Item Code’ field you will skip the ‘Item Relation’ field and select the appropriate Category in the ‘Category Relation’ field.

f. If you selected ‘All’ in the item code, the ‘Item Relation’ and ‘Category Relation’ fields will not be editable since they don’t apply.

g. Finally, enter the account number that you want associated with this item or these items in this transaction type in the ‘Main Account’ field.

h. Now, when this type of transaction is created for this item or for any item in the group or category depending on how you set it up, it will post to the specified account and you will not get the error anymore.

i. The ‘Account Code’, ‘Account Relation’ and ‘Sales Tax group’ fields are used for complex operations where a posting can go to different accounts based on a specific Account \ Account Group \ Sales Tax Group combinations.

Was this reply helpful? Yes No
Aman_Kumar 85 on at

Like (0)

Report

Hi,

You may also want to check the "Posting definition" setup. Please ensure that the "Posting definition" check box is not marked in GL parameters->Ledger->Use posting definition. In case this check box is marked, then you will have to define the posting definition for purchase order in GL->Setup->Posting->Posting definition.

The other reasons for this issue could be an incomplete account structure setup. Ensure that dimension definitions have been configured for all GL accounts.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hello,

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.

Go here to have details of steps to follow and screenshots: vsdynamicsfinance.wordpress.com/.../one-or-more-accounting-distribution-is-missing-a-ledger-account

Was this reply helpful? Yes No
Suggested answer

Mahmoud 25 on at

Like (0)

Report

Dear Andresen

with regards to that error it can be fixed through defining the "purchase expenditure for product" in the item posting profile

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I had the same problem. It was because I didn't specify the date in Dimension value field Active from. I also found that option "Calculate total from multiple dimension values" is not allowed for transactions.

Was this reply helpful? Yes No
Suggested answer

SamuUdoys 17 on at

Like (0)

Report

If you have done all the setup suggested here "Posting Setup" on Inventory management and Item Group Account mapping and it's still not working, then confirm if the said account mapped to your Item group is on the Account structure, that might be the issue (90% of the time).

Was this reply helpful? Yes No
AMINE IT on at

Like (0)

Report

Where I find it ? please

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Amine IT,

You can find the posting setup in inventory management / setup / posting / posting.

Best regards,

Ludwig

Was this reply helpful? Yes No