CRM NAV Integration

preethisaravanan · 2013-07-11

Hi,

I integrated CRM and NAV using Dynamics Connector. I have mapped the Order Date to Effective from Date and Effective To date to Document Date. While choosing the Effective from and Effective to date in CRM i.e., for example if i give 08/08/2012 (mm/dd/yyyy) it comes as 08/07/2013 in NAV. Suggest us that where we might went wrong ](*,)

Thanks
Preethi

Stark · 2013-07-11

Hi,
Try to play with "GetUtcTime" function. Here is example for NAV to CRM "Requested Delivery Date" mapping:

CRM Requested Delivery Date = If(LessThan(Sales Order LinesSales Order LineRequested Delivery Date, Date(1900, 1, 1)), Date(1900, 1,1), GetUtcTime(Sales Order LinesSales Order LineRequested Delivery Date))

I described this issue while ago over here http://www.nav-connector.com/post/2011/08/26/Issue-with-Dates-when-you-sync-from-NAV-to-CRM-direction.

Cheers,
Konstantin

preethisaravanan · 2013-08-01

Hi Stark,

It worked out... Thanks \:D/

Thanks,
Preethi

CRM NAV Integration

Comments

Categories