Hi,
I'm working on the integration between NAV 2009 R2 and CRM 4.0 using Connector for MS Dynamics.
I have a problem with saving data into custom fields which were added to the NAV table "Sales Line" (as a part of Sales Order). I've added those new fields on Pages "Sales Lines" , "Sales Orders" and "Sales Order Subform" then I reconfigured connector, so I can operate them with Integration_Sales_Order web service - I can map the new field in the connectors "Order to NAV sales order" map, but connector seems to ignore this during sychronization.
The problem doesn't occur with any other table nor Sales Lines default fields, I also can read data from custom fields and write them into CRM. Only saving data into NAV Sales Lines custom fields is not working.
I'd be very gratefull for any help.
Best regards,
Dave
This might have been addressed with another fix that went into our latest release, which was posted on Dec. 23rd. Could you verify if the condition still exists after installing the version 2 release?
Thanks for a quick response.
it's not depending on a type of field - Connector doesn't write data to any custom field on Sales Line, no matters if it's Decimal, Date or Code (the problem is with writing data into ERP entities, not CRM). There aren't any errors in Connector's log, all default fields are filled properly during integration. As I said - it's seems that the Connector just ignores those fields even though they are mapped in "Order to NAV Sales Order" map.
I think the cause may be a specific situation of Sales Lines - they don't have a separate Integration web service and they are operate by a part of Integration Sales Order web service. Also, it's seems to be some issue with Connector, because when I'm using this Web Service directly from SDK, it's writing data into custom fields of Sales Line without any problem.
I wonder if it isn't some general Connector's problem with this kind of "sub-entities" as Sales Lines. Or maybe should I add those custom fields to some other NAV Page than I told in a first post? But if that would been the cause, they shouldn't be visible in Connector's map, am I right?
What type of field are you trying to map to in CRM? Is it just a text field or is it something more complicated like a Lookup or Picklist? Are you receiving any errors that are being logged in Connector's Log?
It can also be helpful to capture a Fiddler trace to ensure that the values you think are coming out of the ERP actually are coming out of the ERP and in turn are actually being sent into CRM. Fiddler can be installed from here: www.fiddler2.com/fiddler2
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156