Finance | Project Operations, Human Resources, ...

Value ### in field Source document header is not found in the related table Source document header

(3) Share

Report

Posted on by MYGz

2,334

Hi,

I had deleted a Sales order and recreated due to address issue, now when I am running Database consistency check on the sales orders, I'm getting below error, how can we fix this?

The value '5637174392' in field 'Source document header' is not found in the related table 'Source document header'.

Sales order, line and parameter

The value '5637174392' in field 'Source document header' is not found in the related table 'Source document header'.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (0)

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi MYGz,

In case sales order SO-000082 is imported using data management, can you tell us what columns were used for the import? Is there any column where the value for the source document header was provided manually, maybe based on the value from the deleted order?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Have you tried to run "Fix error" on Consistency check?
Can you provide more info about the SO? Have you posted confirmation, picking list, packing slip or invoice?

Was this reply helpful? Yes No
MYGz 2,334 on at

Like (0)

Report
Copy link

Link copied!

Hi @André Arnaud de Calavon

Below is the DMF data I used to import the sales order SO-000082. Here, SalesOrder number was set to Manual in number sequences.

LotID & AddressLocationID in SalesLineV2 as autogenerate.

Sales order headers V3

https://docs.google.com/spreadsheets/d/1tp1TM9NQkKSwjFAgdUBpzuls4JDFFfse/edit?usp=sharing&ouid=114982502746957761574&rtpof=true&sd=true

Sales order lines V2

https://docs.google.com/spreadsheets/d/1W6cWLgNwXRvZWx6lvLqPCOMrEWicf9ci/edit?usp=sharing&ouid=114982502746957761574&rtpof=true&sd=true

@Alireza Eshaghzadeh

I tried it in Dev Environment, Ran Consistency with Fix Error, it didn't work with no mention of any errors.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,713 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you please try to run fix in the consistency check.

Was this reply helpful? Yes No
MYGz 2,334 on at

Like (0)

Report
Copy link

Link copied!

Hi @BillurSamdancioglu

Just ran the Consistency check with "Fix Error" option. It found the errors but didn't corrected any errors.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi MYGz,

In the source files, I can't see anything that can lead to an orphaned value during the import. Can you try to open the sales order, then View distributions and check if resetting the distributions is available and can solve this?

Was this reply helpful? Yes No
MYGz 2,334 on at

Like (0)

Report
Copy link

Link copied!

Hi @André Arnaud de Calavon

I can not see the the View Distributions & Accounting section in the Sales Order > Sell tab. I can see it in purchase orders > Purchase tab though.

Thanks.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi MYGz,

Apologies. You are correct. The View distributions is only available on the purchase orders, not on the sales orders. The source document header field is set as not visible in the SalesTable. Have you considered deleting the sales order again and re-import it?

Was this reply helpful? Yes No