Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Customized Fields Inte...
Microsoft Dynamics CRM (Archived)

Customized Fields Integration between Dynamics NAV 2016 and Dynamics CRM 2016

(0) ShareShare
ReportReport
Posted on by Nour

Dear All,

I am integrating dynamics CRM 2016 with Dynamics NAV 2016.
I set up the integration and everything is working perfectly. 
I was able to insert items from NAV to products entity in CRM. 
Also, when I change a default field like description in NAV, the change is reflected in CRM.
My problem is I created a custom field in Item table with field No. 50003 and a custom field in CRM products with field No. 50003 and mapped the 2 fields using integration field mapping table in NAV.  
integration-field-mapping.png

When I change the value of this custom field, and then press on synchronize on the item page, a message “synchronization successful pops up” but the change is not reflected in CRM. Nothing Happens.

What could be the problem? What am I missing?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customized Fields Integration between Dynamics NAV 2016 and Dynamics CRM 2016

    Hi,

    A bit late to respond, but the reason is simple. You added this field after the record is coupled and synchronized. By adding just a field, no trigger exists in order to have the record synchronized again. Just change a value in any field on the record in NAV, synchronize and you will see that your added value is also added in CRM. (If no sync issue exists, that is).

    For all records, you need to change a value on the NAV records and that can be time consuming... One way to deal with that is to export/import all records in NAV with configuration package with a changed value and after that do it again to have the former value. So just to act as a trigger.

    Another way would be to create a new field of type Date in the NAV item table and call it e.g. “Last Transaction Date”;
    In the function responsible for posting into item ledger, add two lines of code updating the Last Transaction Date with today’s date and then committing the change.This would give the system an indication that something has changed in relation to NAV record and that in turn would trigger the update via the Dynamics Connector.

    regards

    Wim

  • PS Profile Picture
    PS 23,577 on at
    RE: Customized Fields Integration between Dynamics NAV 2016 and Dynamics CRM 2016

    Hi Nour

    I am asking you to copy paste it's content

  • Nour Profile Picture
    Nour on at
    RE: Customized Fields Integration between Dynamics NAV 2016 and Dynamics CRM 2016

    The page is displaying service request error.

    Can you please copy paste its contents?

    Thank you

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Customized Fields Integration between Dynamics NAV 2016 and Dynamics CRM 2016

    Have u done this:

    To add a custom field to standard entity maps

    In Microsoft Dynamics NAV, in Object Designer, open the page that has been exposed as a web service in design mode.

    Add the field to the page, and then recompile the page.

    Source: msdn.microsoft.com/.../gg502482.aspx;MSPPError=-2147217396

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans