Supply chain | Supply Chain Management, Commerce

One or more accounting distributions is either over-distributed, under-distributed. You must update the accounting distributions before you can journalize the source document when confirming purchase order

(0) Share

Report

Posted on by marypeace

524

Hi,

I created a purchase order under Procurement and sourcing>>Purchase orders>>All purchase orders.

At first I created 2 different line items and successfully confirmed the PO.

Then I add another line item which is same item as first item so that there will be 3 line items.

I created same item as the first item to differentiate the original item from the revision because this is project related PO and I want to monitor what are the changes in the PO.

When confirming the PO, the below error appeared:

One or more accounting distributions is either over-distributed, under-distributed. You must update the accounting distributions before you can journalize the source document.

I checked all the posting account for vendor and item and found no issue.

But when I add another item that is different as the original item, it was successfully confirmed.

I'm using D365 finance and supply chain.

Pls help.

Thank you.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (0)

Report

Hello marypeace,

From the PO, in the Purchase ribbon can you click on Distribute Amount or View Distribution (you can also do from Sales Order Line > Financial > Disctribute Amounts)

You can verify that the amounts are fully distributed for each lines and apply corrections as necessary:

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report

Hi Danny,

I checked the distributions and it is fully distributed.

I reset the distribution to make sure that the distribution is correct.

I checked the posting account for vendor and item and found no issue.

Pls advise.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (1)

Report

Hello marypeace,

Here is a Microsoft doc article on a data inconsistency issue for ehich there is a clean-up job: docs.microsoft.com/.../accounting-over-under-distributed

Can you try that?

Danny

Was this reply helpful? Yes No
Adrian Peter 219 on at

Like (0)

Report

Hi

we had similar issue - but in relation with expense reports. And in our case, the problem was caused by a new feature, which we had enabled. Read the support communication:

Symptoms:

When trying to post an expense report for a credit card transaction in a different currency than the accounting currency the system is displaying the error message:

“The accounting distribution is invalid for the document as its over or under-distributed. Please correct the accounting distribution records for document and try again. Detailed information for your administrator: SourceDocuemntHeader ‘yyy’ SourceDocumentLine: ‘ZZZ’ and Accounitng event ‘’TTT”.

Resolution:

The issue is now being worked on by the product team and is now trackable on LCS. The link to track the issue: Details for issue 651239 (dynamics.com)

You can go to the link and click on the notify me button and this will update you on the status of the issue and notify you when the resolution is available.

Till then, since the business does not use cash advance functionality, the feature “Ability to map cash advances to expense lines” can be disabled for the expense reports to be posted without any issues.

perhaps you also have a feature enabled, which may cause problems...

best regards,

Adrian

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report

Thank you for sharing Adrian.

How will we know that the enabling of the new features affect other processes?

Thanks.

Was this reply helpful? Yes No
Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (0)

Report

Hello marypeace,

Did you try the clean-up job?

Here is the bog post that was embedded in the Microsoft doc link that I sent earlier which explains how to use the function:

cloudblogs.microsoft.com/.../

If you do not have access, you can ask a System Adminstrator to run it for you.

Regards,

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report

Thank you Danny.

When running clean up, I encounter errors as follows

Appreciate your inputs.

Thanks.

Was this reply helpful? Yes No