10
May2011
CRM 2011 – NAV 2009 R2 Synchronisation – tips and tricks
by Shanon
in Technical
The following pointers are little things we picked up while synchronising Microsoft Dynamics CRM 2011 and Microsoft Dynamics NAV 2009 R2, that were not well documented elsewhere. It doesn't cover everything - just the points that were poorly documented by Microsoft, or not obvious to us.
Firstly, make sure you have the right version installed. An early version of connector V5 caused errors when used with CRM 2011. To make sure you have the right version, go here: http://support.microsoft.com/default.aspx?scid=kb;en-US;2544388
CRM Users (perhaps only the integration user?) need to be set up as being in the same timezone as the NAV Server. If not, synchronisation will just never work. This needs to be done while logged in as the user, from the File>Options menu. You will need to do this for the integration user before you make it an integration user (you cant log in using that user after that).
Currency codes will probably cause a problem once you try to synchronise. This is covered in the connector documentation, by changing a mapping function. What it doesn't tell you is that you cant just copy and past the function in. I had to delete the current value, then user the function builder (from clicking on the paper and pen icon) to construct the function.
If you add a new field to NAV and wish to synchronise it, apart from updating config files (which is kind of straight forward), it also needs to be on the appropriate page, else it wont work.
Categories
Recent Posts
Archives
- 2019
- 2015
- 2014
- 2013
- December
- November
- October
- Downsizing Dangers - 28th October 2013
- Dynamics NAV NAS/Job Queue - Excel SaveAs method failed - 18th October 2013
- New in XLCubed 7.5 - 16th October 2013
- How to suspend and resume SQL database mirroring - 15th October 2013
- XLCubed: Excel Dashboards - 11th October 2013
- Analytical Applications of Business Intelligence Reporting - 10th October 2013
- What is Microcharts? How can it clarify data? - 10th October 2013
- Can’t print from XLCubed Web Edition - 2nd October 2013
- September
- June
- February
- January
- 2012
- 2011
- November
- August
- July
- May
- A call to SSPI failed in NAV 2009 R2 - 31st May 2011
- Can’t send BizTalk documents from NAV2009 Role Tailored Client - 23rd May 2011
- Unique External Document No. on Sales Order - 23rd May 2011
- CRM 2011 – NAV 2009 R2 Synchronisation – tips and tricks - 10th May 2011
- Manually Create NAV Service Instances - 3rd May 2011
- April
- March
- February
- January
- 2010
- December
- November
- SQL Maintenance plan won't run, modify or delete - 24th November 2010
- Miscellaneous NAV RTC Development Tips - 21st November 2010
- NAV RTC Development training tools - 18th November 2010
- Microsoft Dynamics NAV Application Objects - 15th November 2010
- Delete a rogue Conur Expense Report - 12th November 2010
- CRM - 9th November 2010
- October
- September
- February
Tags
- 2009
- 64bit
- antivirus
- application objects
- BI
- BizTalk
- blocking
- Business
- Business Intelligence
- c#
- C#
- cached password
- calculation
- CGRS
- Cloud
- Commerce Gateway
- concur
- CRM 2011
- CRM 2013
- Crystal Reports
- csv
- Data Type
- date and time
- deadlock
- delete
- DotNet
- Downsizing
- Dynamics
- Dynamics NAV
- EDI
- ERP
- Excel Buffer
- External Document No.
- Generate xsd from SQL table
- impersonation
- Jigsaw
- Job Queue
- MDX
- Microsoft Excel
- NAS
- NAV
- NAV 2009
- NAV 2009 R2
- NAV Application Server
- NAV Development
- NAV Upgrade
- NAV2009
- NAV2013R2
- NAV2015
- Navision
- new version
- no delimiter
- NST
- OLAP
- Permissions
- printing
- regsvr32
- right-click
- security
- Security
- service broker
- SMTP
- SQL
- SSPI
- SSRS
- sync
- synchronisation
- umbraco
- upgrade
- User Setup
- Web Service
- xlcubed
- xmlport
- xp_ndo
- xp_ndo_enumusergroups
- xp_ndo_enumuserids