160
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
*This post is locked for comments
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 www.nav-connector.com/.../Issue-with-Dates-when-you-sync-from-NAV-to-CRM-direction.
Cheers,
Konstantin
P.S. this message copied from my answer to you on mibuso (you're not replied there if it works for you or not)
Hi ROMANR,
But both the CRM and NAV are in same time zone.
Hi,
I do not speak English. Nonetheless....
Look in the SQL server.
SQL(NAV): date-sql = date-nav(show in client) +/- difference in Greenwich.
SQL(CRM): date-sql = date-crm(show in client)??? (where's the difference)
Connector transmits SQL data.
Share
Report
All responses (
Answers (
