Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by adilD365

185

Hi when user trying to make Purchase Order Resubmit after editing the price in line he got below message 'One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid'

Now this PO approval Status 'Rejected' and user wants to Resubmit the PO after Editing the PO

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi Adil,

this seems the posting profile issue for either Creditors or Item level.

Can you check you vendor posting profile and also item posting setup?

Was this reply helpful? Yes No
adilD365 185 on at

Like (0)

Report

Hi thanks for reply as i am new here please can you show where this setting?

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Check the followings

Accounts payable parameter ->> Ledger and sales tax->> Posting profile has the value filled up

\

Check the vendor you are using, that vendor group is added to the posting profile along with summary account added

Now, check from inventory management - setup- posting

Check the purchase order tab and check the necessary setup is done there.\

Was this reply helpful? Yes No
Suggested answer

Ashish K 154 on at

Like (3)

Report
Hello Adil, there could be few scenarios because of which you are getting this error. Let's follow below 2 steps:

Let's update the Main account on that particular PO where you are getting this error. Open the PO, Select the PO line, Click Financials --> Distribute Amount and Update the Main Account

2. After updating the Main account. You should be able to post the PO

3. For fixing this issue permanently, Lets update the main Account on Inventory Management --> Posting Profile. Update the Main Account in Purchase Expenditure for expense . As it seems you are using the Procurement category from your screenshot.

4. Update the main account for the Procurement category for which you are getting error.

Let us know if this fixed your issue.

Was this reply helpful? Yes No
adilD365 185 on at

Like (0)

Report

Hi thanks for reply when i check the 2nd line >Click Financials --> Distribute Amount > there i did not found the Ledger Account 'drop down value is empty' as you check the 2nd line details Procurement Category has value 'Utilities'

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi Adil,

Can you check that you have created an Inventory Posting profile for the Purchase order and this includes your category "Utilities"? If not please update it.

Let us know if this helps you,

Thanks,

Was this reply helpful? Yes No
adilD365 185 on at

Like (0)

Report

I checked that 'Utilities' not found how to update it?

Was this reply helpful? Yes No
Suggested answer

Prem Kumar Bachu 3,418 on at

Like (0)

Report

Hi adilD365,

Make sure you mapped ledger account for procurement categories(used in your PO) in inventory posting. In inventory posting select item code as category, select category in category relation and select main account.

Regards,

Prem

Was this reply helpful? Yes No