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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / D365 Project Operation...
Finance | Project Operations, Human Resources, ...
Unanswered

D365 Project Operations + Finance & Operations - Dual Write Error on Close as Won

(0) ShareShare
ReportReport
Posted on by LA-08041617-0
Hello,
 
When attempting to Close a Project Quote as Won, the following Dual Write error occurs:
 
 
I notice that if I stop the Dual Write table map "Project Operations integration contract line milestones" (msdyn_contractlinescheduleofvalues) before executing Close as Won, the error does not occur. The Project Contract is successfully created in F&O. I then run an Initial Sync (Dataverse as master) on the milestones map and the milestones sync correctly.
 
I think the issue is related to the Dual Write sync timing (race condition) as the milestones are being sent to F&O before the Contract Lines have finished syncing, causing the ContractLineId lookup to fail.
 
Has anyone experienced this issue and found a permanent fix?
 
Thank you in advance for any help!
Categories:
Dynamics 365 Project Operations
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,182 Super User 2026 Season 1 on at
    Hi,
     
    I have not used this scenario myself. Besides your thinking on the order of completion, it can be also related to missing table permissions, however, then the initial sync might also fail. 

    If you keep having this issue, I suggest to create a ticket for Microsoft Support.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 681

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 446 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 202 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans