Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Product integration from Dynamics Sales(CRM) to Dynamics 365 Finance and Operation using CDS

(0) ShareShare
ReportReport
Posted on by 6,205

Hi All,

I want to make product integration between dynamics crm products to dynamics 365 finance and operation product using CDS.

There is no template available for sales to fiance&operation for product so is there any way to create custom template for the same.

Any help would be appreciated.

Regards,

Shahbaaz

*This post is locked for comments

  • Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,205 on at
    RE: Product integration from Dynamics Sales(CRM) to Dynamics 365 Finance and Operation using CDS

    also i dont want to import all product to F&O, i want product to create in F&O condition based.

  • Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,205 on at
    RE: Product integration from Dynamics Sales(CRM) to Dynamics 365 Finance and Operation using CDS

    thank you very much for the reply, i create a mapping from crm to f&o, when i run it, it is giving me error  : File contains duplicate rows, cannot insert data into staging due to unique key violation.-

    '0' 'Released products V2' record(s) inserted in staging

  • Verified answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at
    RE: Product integration from Dynamics Sales(CRM) to Dynamics 365 Finance and Operation using CDS

    Hi Shahbaaz,

    I just now tried this and below are the steps:

    1. Create connections to D365 CE and D365 F&O

    2. Create connection Set - select the connections and choose any template which points from CE to F&O

    3. Create a project and select the instances

    4. Once project is created delete the existing Task

    5. Create a new Task with the desired entities - Product...

    6. Edit the mapping by clicking the ">" button for new task

    7. Save the changes..

    8. Run the projects - with all data

    9. Check in execution history - for success or for errors

    Using these steps I was able to sync my CRM products in F&O products entity.

    Hope this helps.

  • Verified answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at
    RE: Product integration from Dynamics Sales(CRM) to Dynamics 365 Finance and Operation using CDS

    Hi..

    Did you check this link : docs.microsoft.com/.../data-integrator

    Section: "Customizing projects, templates, and mappings".

    It has both

    1) create temlate from existing

    2) create template from scratch.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans