Customized Fields Integration between Dynamics NAV 2016 and Dynamics CRM 2016

(0) Share

Report

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.

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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nour on at

Like (0)

Report
Copy link

Link copied!

The page is displaying service request error.

Can you please copy paste its contents?

Thank you

Was this reply helpful? Yes No
PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

Hi Nour

I am asking you to copy paste it's content

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No