NAV 2009R2 - Outlook Synchronization Filter Error

c.bakker
Member Posts: 13
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
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
Choose a job you love, and you will never have to work a day in your life.
Confucius 500 BC
Confucius 500 BC
0
Comments
-
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.Thomas Martin
NAV Developer0 -
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.Choose a job you love, and you will never have to work a day in your life.
Confucius 500 BC0 -
And "Type" is not by any chance "Soort" in the Dutch version?Thomas Martin
NAV Developer0 -
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!Choose a job you love, and you will never have to work a day in your life.
Confucius 500 BC0 -
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!Choose a job you love, and you will never have to work a day in your life.
Confucius 500 BC0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions