Skip to main content

Notifications

Dynamics 365 general forum

How to save data into custom field in NAV Sales Line via Connector, NAV/CRM integration

Posted on by 95

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to save data into custom field in NAV Sales Line via Connector, NAV/CRM integration

    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?

  • DaveSz Profile Picture
    DaveSz 95 on at
    Re: How to save data into custom field in NAV Sales Line via Connector, NAV/CRM integration

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to save data into custom field in NAV Sales Line via Connector, NAV/CRM integration

    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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans