Skip to main content
Power Platform integration forum
Unanswered

Customized Dual Write setup for Project Quotation

editSubscribe (0) ShareShare
ReportReport
Posted on by 5

Hi,

I am working on an interesting task were I have to setup customized Dual Write mapping for Project Quotations – to some extent I am trying to replicate the functionality that is in Project Operations, however, I am trying to make Project Quotation data flow from D365 FO to Power Platform Sales Hub.

My approach so far has been to replicate the Dual Write Out of the Box mapping for Sales Quotation, just for Project Quotation, like this:

 pastedimage1678964785284v1.jpeg

The issue I face with this mapping is that I can only write over Items/Products to the Quotedetails table in Dataverse, which is not sufficient since I also need to write Project Operations data such as hours, fees, and expenses. As one can see on the below picture the error message that pops up when I try to create a Project Quotation containing both items and hours states that “an order line should be assigned at least an existing product or sales product category..”. This is interesting because Product and Sales Category are optional fields in the Dataverse table “Quotedetails“.

Error message when creating the Project Quotation with Items and Hours:

 pastedimage1678964792708v2.jpeg

The full error message:

 Dual-Write-Error-message.jpg

What I am thinking is that there might be some underlying Microsoft setup for the Dataverse table Quotedetails that prevents me from adding anything other than Products - which in turn would make this approach impossible unless anybody has a workaround? 

All I am trying to do is to get FO Project Quotation data (which means Product-based Lines and Project-based Lines) to Sales Hub such that a Quotation can be created in Sales Hub and then sent to the customer from there. Anyone has any recommendations on how to do this or get around the error message that I am facing? (I am aware that a quotation can be sent to a customer directly from FO, however, we would prefer to make the quotation in FO and then sent through Sales Hub).

Attachments
  • Customized Dual Write setup for Project Quotation
    Did you find a answer to this?

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans