CRM NAV Integration

preethisaravanan

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

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

Hi Stark,

It worked out... Thanks \:D/


Thanks,
Preethi