You can synchronize data, such as to-dos, contacts, and tasks, between Microsoft Dynamics NAV and Microsoft Outlook. This allows users who rarely connect to Microsoft Dynamics NAV, such as salespeople who frequently work away from the office, to keep their data synchronized. For example, a sales manager can set a meeting for a salesperson as a to-do in Microsoft Dynamics NAV. That salesperson can then view or modify the meeting in Outlook. A salesperson can also add a new contact in Outlook. That contact is then added to the company's Microsoft Dynamics NAV database.
You define the mapping between Microsoft Dynamics NAV entities and Outlook items in Microsoft Dynamics NAV. You then specify the entities that users synchronize.
The Microsoft Outlook Add-In for Microsoft Dynamics NAV is required to set up and use synchronization. Outlook must be set up and configured for users before you install the add-in. If it is not, then the add-in may not display correctly. You must also set up a web service.
About This Walkthrough
This walkthrough illustrates the following tasks:
-
Setting up Microsoft Dynamics NAV synchronization in a multiple-user environment.
-
Configuring Microsoft Dynamics NAV for Outlook synchronization.
-
Mapping Microsoft Dynamics NAV entities to Outlook items, which lets you:
-
Assign synchronization entities to synchronization users.
-
Apply change log settings.
-
Assign synchronization entities to synchronization users.
-
Setting conditions for entities.
-
Setting up a web services connection between Outlook and Microsoft Dynamics NAV.
-
Configuring synchronization in Outlook, which lets you:
-
Apply synchronization settings.
-
Establish the connection using web services.
-
Set up synchronization folders.
-
Set a filter to exclude Outlook contacts from synchronizing with Microsoft Dynamics NAV.
Nota After you have set up and configured Outlook synchronization, you can test your setup by performing the steps that are described in. -
Apply synchronization settings.
Prerequisites
To complete this walkthrough, you will need:
-
Microsoft Outlook 2013 or Microsoft Outlook 2010 installed and configured for you as a user on a client machine. Outlook integration requires the 32-bit version of Outlook.
-
Microsoft Office Outlook Integration, installed on the Microsoft Dynamics NAV Server.
-
Microsoft Office Outlook Add-in, installed with the Microsoft Dynamics NAV per client Windows.
For more information, see How to: Choose Components to Install and Microsoft Dynamics NAV 7 Requirements.
Setting Up Synchronization for a Single User on a Single Computer
This walkthrough describes how to set up and use the Outlook add-in for a single user on a single computer. You can also set up and use the Outlook add-in for multiple users on a single computer, using tools such as Terminal Services. You should follow these steps before you use the Outlook add-in in this environment.
-
Ensure that Outlook is correctly installed and configured for all users who need the add-in.
-
Install the Outlook add-in from the Microsoft Dynamics NAV product media and make sure that the installation is for all users.
For best results, install Microsoft Dynamics NAV 2016 and the Outlook add-in on a machine that has not previously had Microsoft Dynamics NAV installed and then uninstalled on it.
Configuring Microsoft Dynamics NAV for Outlook Synchronization
In this walkthrough, before you set up synchronization, make sure that the correct permissions are set up.
Nota |
---|
In a production environment, you can specify any permission set that lets you add a salesperson and modify data in the Outlook Synch. Entities and Outlook Synch. User Setup tables. |
To define synchronization users
Start the Microsoft Dynamics NAV per client Windows.
In the Search box, enter Utenti, and then choose the related link.
If you are not already listed in the Utenti window, then create a new user.
On the User card, in the User Permission Sets FastTab, specify the SUPER permission set. Choose the OK button.
Next, you add yourself as a salesperson in Microsoft Dynamics NAV so that you can assign synchronization entities to yourself and then test your setup.
To add yourself as a salesperson
In the Search box, enter Salespeople, and then choose the related link.
On the Home tab, choose New, and then fill in the following fields in the Scheda agenti/addetti acq. card.
The following table describes the fields.
Campo Descrizione Codice
Your initials.
Nome
Your name as defined in your Outlook profile.
E-mail
Your email address as defined in your Outlook profile.
Mapping Microsoft Dynamics NAV Entities to Outlook Items
You start synchronization setup by identifying the Microsoft Dynamics NAV objects to synchronize. When you open the Lista entità Sincroniz. Outlook window for the first time, you may receive a message that asks for permission to connect to a .dll file that is installed with the Outlook add-in. You should choose the option that lets you connect: Allow for this session.
For this walkthrough, you can use the synchronization entities that come with Microsoft Dynamics NAV by default. But you can also customize and add entities. For more information, see How to: Set Up Outlook Synchronization Entities and Define Synchronization with Outlook Items.
To set up default synchronization entities
In the Search box, enter Outlook Synch. Entities, and then choose the related link.
In the dialog box asking for permissions, choose Allow for this session, and then choose the OK button. The Lista entità Sincroniz. Outlook window opens.
The following table lists the default Microsoft Dynamics NAV entities and the Outlook item types to which they map.
Microsoft Dynamics NAV entity code Descrizione Outlook items APP
To-do type: Meeting
Meetings
CONT_COMP
Contacts: Company
Contacts
CONT_PERS
Contacts: Person
Contacts
CONT_SP
Contacts: Salesperson
Contacts
TASK
To-do type: Blank or Phone
Tasks
After you have set up entities to synchronize with Outlook items, you assign a user to the entity that the user wants to synchronize. In the following procedure, you assign yourself as the user who is associated with the default entities.
When you are setting up synchronization, you can first assign a user to one or two entities and then continue with the setup to test whether your connection works.
To assign synchronization entities to users
In the Search box, enter Outlook Sync. User Setup, and then choose the related link. The Setup utente Sincroniz. Outlook window opens.
Choose New. In the Setup utente Sincroniz. Outlook window, choose the ID utente field, and then choose your user ID.
Choose the Codice entità sincroniz. field, and then add synchronization entities in the following order with your user ID:
-
Add CONT_SP. Leave the Nr. di elementi field as 0.
-
Add CONT_PERS. Leave the Nr. di elementi field as 0.
-
Add Cont_COMP. Leave the Nr. di elementi field as 0.
-
Add APP.
-
Choose the Nr. di elementi field to open the Dettagli setup Sincroniz. Outlook window.
-
On the Home tab, choose New, choose the line under Raccolta di Outlook, choose Recipients, and then choose the OK button.
-
Choose the Close button to close the Dettagli setup Sincroniz. Outlook window.
-
Choose the Condizione field, and enter information in the Filter window.
The following table describes the information that you have to enter.Column Value Nome campo
Salesperson Code
Tipo
CONST
Valore
<salesperson code>
-
Choose the OK button.
-
Choose the Nr. di elementi field to open the Dettagli setup Sincroniz. Outlook window.
-
Add Task.
-
Choose the Nr. di elementi field to open the Dettagli setup Sincroniz. Outlook window.
-
Choose New, choose the line under Raccolta di Outlook, choose Links, and then choose the OK button. Choose the OK button again to close the window.
-
Choose the Condizione field, and enter information in the Filter window.
The following table describes the information that you have to enter.Column Value Nome campo
Salesperson Code
Tipo
CONST
Valore
<salesperson code>
-
Choose the Nr. di elementi field to open the Dettagli setup Sincroniz. Outlook window.
-
Add CONT_SP. Leave the Nr. di elementi field as 0.
Choose the OK button. Choose the OK button again to close the window.
You must activate the change log to enable tracking of the changes that you made to the synchronization entities.
To apply change log settings
In the Setup utente Sincroniz. Outlook window, on the Navigate tab, in the Setup group, choose Register in Change Log Setup. The Set. log modifiche Sincroniz. Outlook window opens.
Clear the filter value for Code. This lets you enable the change log for all entities at the same time.
Choose the OK button. Close and reopen the company to enable the change log settings.
Nota Run the Set. log modifiche Sincroniz. Outlook batch job every time that you add or change a synchronization entity to make sure that changes are collected for the required fields.
Setting Conditions for Entities
You can set conditions for the TASK and APP entities to help limit the tasks and meetings that are included on your Outlook calendar. For example, you can set a condition to retrieve only those meetings and tasks that involve you as the salesperson and that you own. Meetings and tasks must have a Meeting Organizer or Task Owner, so that you must create a condition. If you do not, then you cannot synchronize meetings with Microsoft Dynamics NAV.
To configure conditions
In the Search box, enter Outlook Synch. User Setup, and then choose the related link.
Select the line with the APP entity, and then choose the Condition field.
In the Filtri Sincroniz. Outlook window, in the Nome campo field, select Salesperson Code. In the Valore field, enter the code for the salesperson.
Repeat these steps for the TASK entity.
Setting conditions for other entities is not required, but we recommend doing it to prevent mass data transfer to a local mailbox or a public folder.
Setting Up Web Services Connections
You must set up a web services connection between Microsoft Dynamics NAV and Outlook.
Before starting the next procedure, make sure that you have previously opened the Lista entità Sincroniz. Outlook window. When you do this, there is preparation in the background that is needed for the web service to appear in the later steps.
To set up a web services connection
On the computer that is running Microsoft Dynamics NAV Server, verify that web services are running. The web service has to run in English for locale 1033.
In the Search box, enter Servizi Web, and then choose the related link.
On the Home tab, in the Manage group, choose Edit List.
Choose the DynamicsNAVsynchOutlook service, and then select the Pubblicato check box.
Configuring Synchronization in Outlook
You can now start Outlook. By default, the Microsoft Dynamics NAV Synchronization items are on the Add-ins tab.
The following table describes the items on the Synchronization toolbar.
Ribbon command | Descrizione |
---|---|
Synchronize | Start synchronization manually. When you choose this command, synchronization applies to items that have been created or modified since the last synchronization. |
Full Synchronization | Synchronize all items. |
Settings | Configure synchronization, including automatic synchronization, conflict resolution, and connection, and set folders and filters for synchronization entities. |
Troubleshooting | Resolve synchronization issues. If the Troubleshooting icon is red, then you have existing errors that must be fixed. |
Connection State | Indicate the status of the connection state between Outlook and Microsoft Dynamics NAV. Choose the command to get a message that describes the status. |
Applying Synchronization Settings
You start to establish synchronization settings in the Settings dialog box. You can set synchronization to run automatically and set how frequently that it should run. You can also set how conflicts should be resolved between Microsoft Dynamics NAV and Outlook when changes have been made in each application at the same time.
Because you want to test the synchronization setup manually to make sure that it is working correctly, in this walkthrough, you do not select the automatic synchronization setting. You also do not select the automatic resolution setting.
To set rules for synchronization
In Outlook, on the Add-ins tab, choose Settings. The Settings dialog box opens.
On the General tab, select Show synchronization progress and Show synchronization summary.
Select Resolve conflicts manually. Choose the Apply button.
Establishing a Connection Between Microsoft Dynamics NAV and Outlook
On the Connection tab, you must select a type of connection. You must have a working connection before you can create the synchronization settings.
You can be either a Microsoft Dynamics NAV user or a Windows user. A NAV user requires that you supply a username and password.
You follow these steps to establish your web services connection on the NAV Service tier.
Importante |
---|
When you are connecting to a Microsoft Dynamics NAV Server in Azure, you must specify settings for Internet Explorer.
|
To establish a web services synchronization connection
In the Settings dialog box, choose the Connection tab.
Specify a Web service path in the Web Service Path text box:
On premises (default): http://localhost:7047/DynamicsNAV71/WS/Codeunit/DynamicsNAVsynchOutlook
-or-
Azure: https://<cloud NST URL>:7047/DynamicsNAV71/WS/Codeunit/DynamicsNAVsynchOutlook
Select an authentication type:
On premises: Basic or Windows
-or-
Azure: Basic
Enter the NavUserPassword credentials for the user whose meetings, tasks, and contacts you are synchronizing from Microsoft Dynamics NAV to Outlook.
In the Company Name box, select CRONUS Italia S.p.A.
Choose the Apply button.
Choose the Test Connection button.
If your connection succeeds, then you receive a confirmation message. Choose the OK button. The red X is cleared from the Connection State button in the Add-ins tab. If your connection does not succeed, then you receive an error message. To resolve the error, stop and start the web service again.
Defining Synchronization Folders
Each Microsoft Dynamics NAV entity must be mapped to folders that you create for synchronization in Outlook. The folders must map to the entity type. For contacts, the folder must be created in Outlook Contacts. For tasks, the folder must be created in Outlook Tasks. If you create a new entity, then you set the Outlook item that the entity maps to. You can verify what Outlook item that you have set by selecting the entity in the Outlook Synch. Entities window in Microsoft Dynamics NAV.
To set folders for synchronization entities
Create a new folder in Outlook for each entity that you have set up for synchronization. For example, create a folder named Company Contacts, and then set the folder to contain Contact Items. The following table lists the default entities and the type of folder to create.
Microsoft Dynamics NAV entities Outlook folder item types Microsoft Dynamics NAV Contacts of the Company type
Contacts
Microsoft Dynamics NAV Contacts of the Person type
Contacts
Microsoft Dynamics NAV Salespeople
Contacts
Microsoft Dynamics NAV Meetings
Calendar
Microsoft Dynamics NAV Tasks
Tasks
In Outlook, in the Settings dialog box, choose the Folders tab.
The entities that you set for synchronization are displayed in the Synchronization Folders area. If you add a new entity in Microsoft Dynamics NAV, then it is displayed in this list.
Choose the Browse button, and then map each entity to the folder that you created for it. Choose Apply.
To specify which toolbar commands are displayed
In the Settings dialog box, choose the Customize tab.
Choose the Full Synchronization and Synchronize options. Choose the Apply button, and then choose the OK button.
In addition to the options you have chosen, the Settings command is always available on the ribbon.
Setting Filters
You set filters to define any items that you do not want to be synchronized. For example, if you have personal contacts that you do not want to be synchronized with your Microsoft Dynamics NAV contacts, then you can filter for those. In this procedure, you filter to exclude personal contacts from synchronization by excluding contacts that contain home telephone numbers.
To set a filter
In the Settings dialog box, on the Filters tab, on the Microsoft Dynamics NAV Contacts of the Person type line, choose the Edit button.
In the Field Name box, select HomeTelephoneNumber.
In the Condition box, select is not empty, and then choose Add to List.
Choose the Apply button, and then choose the OK button.
On the Microsoft Dynamics NAV Synchronization toolbar, choose the Synchronize button.
The Synchronization Progress message is displayed. When synchronization is complete, you can view the details for the synchronization.
Passaggi successivi
You have completed the required setup for synchronizing information between Microsoft Dynamics NAV and Outlook. To test your setup, see Procedura dettagliata: Sincronizzazione delle informazioni tra Outlook e Microsoft Dynamics NAV.