NAV 2009R2 - Outlook Synchronization Filter Error

c.bakker

Hello,

I'm trying to get Outlook Synchronization working in NAV 2009R2 NL with Webservices and Outlook 2007 SP2 (Dutch Localization for Outlook Add-in "OutlookAddIn.Local.Nl.msi" installed).

For a start i did use the "Walktrough: Setting Up Outlook Synchronisation" found on MSDN (http://msdn.microsoft.com/en-us/library/dd338966.aspx).

To keep it simple at the beginning i only synchronize contacts.
Running the synchronization from Outlook without filters acts like expected: it works fine!

But:
Setting Conditions for the Contact Entities in Nav results in an error message on the synchronization from Outlook:
NST Asynch Call completed with Error: A '=' is missing in TransferFormulaData. WHERE(Verkoper=CONST(NAVDEMO),Type=CONST(0));

Trying to solve the issue i did use the "Troubleshooting: Microsoft Office Outlook Integration and Synchronization" document also found on MSDN (http://msdn.microsoft.com/en-us/library/dd983823.aspx). I verified several things, including the section "Configuring Microsoft Dynamics NAV Synchronization Add-in on Localized Versions of Microsoft Dynamics NAV"

Further on I found out that the language for the Outlook Add-in NST session via Web Services is determined bij the language selected in the last Classic/RTC session of the applicable user (which can be found in Table 2000000073).
After starting Nav Classic with the same windows user account as used for Outlook and setting the language in the Nav userinterface to Dutch the NST error message was translated to Dutch!
Still i got stuck with te following error message:
NST Asynch Call completed with Error: Een '=' ontbreekt in TransferFormulaData. WHERE(Verkoper=CONST(NAVDEMO),Type=CONST(0));
Hope so anyone can help me on this issue.

Best regards,

Cees

thmartin

http://dynamicsuser.net/blogs/navdev/archive/2008/10/16/using-web-services-with-outlook-synchronization-in-a-localized-environment.aspx

BTW, is CONST = CONST in the Dutch version? In the German version CONST = KONST. This shit is also language dependent.

c.bakker

Hello Thomas,

Thanks for your reply. The suggested link however adresses the NST language issue which i did change by setting the language in Navision for the applicable user to Dutch.
And yes.. CONST is CONST in Dutch.

thmartin

And "Type" is not by any chance "Soort" in the Dutch version?

c.bakker

Wow Thomas, sharp eye!
Type is not translated to the dutch translation Soort indeed.
The type clause is added by code, so I will take a look in the code.
Thanks for your contribution!

c.bakker

Yes! Finally got it working.

Exploring the code i found out that there some default query parts are stored in the Nav database (Table 5303). Those are language dependent and English in the standard database.
The way to get them to the right localization is to reset the Outlook Synch. Entities to default running the Nav client in the local language (Classic: Administration/Application Setup/Microsoft Office Outlook Integration/Outlook Synch. Entities => function Sync. Entity/Reset to Defaults).

The document http://blogs.msdn.com/b/nav/archive/201 ... 9-sp1.aspx was very helpfull to me to setup the localized Nav Outlook Integration.
Don't look at the version split (50SP1/2009SP1) simply walk trough the complete document!