web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

CRM → Business Central Sales Order Synchronization – Document Date Error

(4) ShareShare
ReportReport
Posted on by 168

I am currently working on Dynamics 365 CRM/Dataverse → Business Central Sales Order integration using the standard Integration Table Mapping / Integration Field Mapping functionality.

The Sales Order mapping is configured, as shown in the attached screenshot.

If requesting support, please provide the following details to help troubleshooting:

Error message: 
The data could not be updated because of the following error: Document Date must have a value in Sales Header: Document Type=Quote, No.=ORD-01190-V1K9V7. It cannot be zero or empty.

Internal session ID: 
cf2b859e-5548-4c06-a25f-66cba9599c2d

Application Insights session ID: 
b1b69245-e5e2-4e75-b49c-699c34e44936

Client activity id: 
25ab742d-7aab-4131-9be3-f626998f6b81

Time stamp on error: 
2026-10-06T12:41:15.8908094Z

User telemetry id: 
c6155eee-e29c-437d-b2af-5285ea0d5da5

AL call stack: 
"Integration Synch. Error List"(Page 5339)."Message - OnDrillDown"(Trigger) line 14 - Base Application by Microsoft version 28.5.54151.55497

Custom dimensions: 
[{"Item1":"Call Stack","Item2":"\"Sales Header\"(Table 36).\"Payment Terms Code - OnValidate\"(Trigger) line 46 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Record Synch.\"(CodeUnit 5336).SetDestinationValue line 18 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Record Synch.\"(CodeUnit 5336).TransferFieldData line 20 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Record Synch.\"(CodeUnit 5336).TransferField line 25 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Record Synch.\"(CodeUnit 5336).TransferFields line 8 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Record Synch.\"(CodeUnit 5336).OnRun(Trigger) line 2 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Rec. Synch. Invoke\"(CodeUnit 5345).TransferFields line 8 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Rec. Synch. Invoke\"(CodeUnit 5345).SynchRecord line 53 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Rec. Synch. Invoke\"(CodeUnit 5345).OnRun(Trigger) line 3 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Table Synch.\"(CodeUnit 5335).Synchronize line 49 - Base Application by Microsoft version 28.5.54151.55497\\\"CRM Integration Table Synch.\"(CodeUnit 5340).SynchCRMTableToNAV line 27 - Base Application by Microsoft version 28.5.54151.55497\\\"CRM Integration Table Synch.\"(CodeUnit 5340).PerformScheduledSynchFromIntegrationTable line 14 - Base Application by Microsoft version 28.5.54151.55497\\\"CRM Integration Table Synch.\"(CodeUnit 5340).OnRun(Trigger) line 24 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Synch. Job Runner\"(CodeUnit 5339).RunIntegrationTableSynch line 3 - Base Application by Microsoft version 28.5.54151.55497\\\"Integration Synch. Job Runner\"(CodeUnit 5339).OnRun(Trigger) line 5 - Base Application by Microsoft version 28.5.54151.55497\\\"Job Queue Start Codeunit\"(CodeUnit 449).OnRun(Trigger) line 18 - Base Application by Microsoft version 28.5.54151.55497\\\"Job Queue Dispatcher\"(CodeUnit 448).HandleRequest line 26 - Base Application by Microsoft version 28.5.54151.55497\\\"Job Queue Dispatcher\"(CodeUnit 448).OnRun(Trigger) line 35 - Base Application by Microsoft version 28.5.54151.55497\\"}]
 

  • Suggested answer
    YUN ZHU Profile Picture
    104,190 Super User 2026 Season 2 on at

    Based on the error message, could you first check if the Document Date on Sales Quote ORD-01190-V1K9V7 has a value?

     

    Thanks

    ZHU

  • Suggested answer
    OussamaSabbouh Profile Picture
    20,962 Super User 2026 Season 2 on at

    Hello,
    This looks like a field-validation sequence issue, not a missing Document Date mapping. Your screenshot shows Document Date → Date Submitted, but the call stack shows Payment Terms Code – OnValidate failing because Document Date is still 0D when that field is validated. First confirm that Date Submitted actually contains a value in CRM; if it does, initialize Document Date before Payment Terms is validated—typically through OnBeforeTransferRecordFields/custom synchronization logic. As a quick test, disable Validate Field on the Payment Terms Code mapping; if synchronization succeeds, it confirms the ordering issue, although I would not leave validation disabled permanently without testing the downstream behavior.

    Regards,
    Oussama Sabbouh

  • Suggested answer
    D365BC_AmanKr Profile Picture
    291 on at

    Hi,

    This appears to be a field-validation order issue, not a missing Document Date mapping. Although Document Date is mapped to Date Submitted, the call stack indicates Payment Terms Code – OnValidate is triggered while Document Date is still 0D.

    First, verify that Date Submitted has a value in CRM. If it does, ensure Document Date is populated before Payment Terms Code is validated, possibly through OnBeforeTransferRecordFields/custom synchronization logic. As a quick test, disable Validate Field for Payment Terms Code. If synchronization then works, it confirms the sequencing issue; however, validate the downstream impact before keeping this setting disabled.

    Hope it will help you.
    Please Verify if you found the answer helpful so that it will help others.

    Many Thanks
    Aman 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 545 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 354 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 228 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans