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

All responses (8)

Answers (0)

Suggested answer

Prem Kumar Bachu 3,410 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

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
adilD365 185 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

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

Gaurangkumar Jani 4,511 User Group Leader 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

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,
adilD365 185 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

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'
Suggested answer

Ashish K 154 on at

Like (3)

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

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.
Suggested answer

Ramit Paul 22,293 Most Valuable Professional 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

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.\
adilD365 185 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

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

Ramit Paul 22,293 Most Valuable Professional 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

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?