FIND('=<>') statement works incorrectly in Microsoft Dynamics NAV 2013

This article applies to Microsoft Dynamics NAV for all countries and all language locales.

Symptoms

If you use FILTERGROUP with a FIND('=><') statement in Microsoft Dynamics NAV 2013 the filtered list always shows one record that is not within the filter.

Resolution

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website: You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

PartnersCustomersIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.


How to obtain the Microsoft Dynamics NAV hotfix or update files

After you request a Microsoft Dynamics NAV hotfix, a hyperlink will be sent to you in an e-mail.


The e-mail will contain a hyperlink and a password. You can use the hyperlink to download the Microsoft Dynamics NAV hotfix or the update files. When you click the hyperlink, the File Download – Security Warning dialog box opens. Then, you are prompted to run, to save, or to cancel the download.


If you click Run, the files start the download and the extraction process. You must specify a folder for the new files, and then provide the password.


If you click Save, you must specify a path for saving the compressed file. When you open the file that you saved, you are prompted to specify a path for the files. Then, you must provide the password provided in the e-mail.


If you click Cancel, the download process stops.


How to install a Microsoft Dynamics NAV platform hotfix

The Microsoft Dynamics NAV platform hotfixes are made available as single files. To install a Microsoft Dynamics NAV hotfix, you must replace the existing Microsoft Dynamics NAV installation files with the hotfix files. To do this, follow these steps.

Step 1: Replace the files in the Microsoft Dynamics NAV Server installation

In the Microsoft Dynamics NAV Server installation, replace the files by using the hotfix files.
File nameFile versionFile sizeDateTimePlatform
Microsoft.dynamics.framework.patterns.dll7.0.34194.071,91215-Jan-201306:43x64
Microsoft.dynamics.framework.ui.dll7.0.34194.01,173,20815-Jan-201306:43x64
Microsoft.dynamics.framework.ui.mapping.dll7.0.34194.016,61615-Jan-201306:43x64
Microsoft.dynamics.framework.ui.navigation.dll1.5.11910.9826,44015-Jan-201304:30x64
Microsoft.dynamics.framework.ui.ux2006.dll7.0.34194.087,27215-Jan-201306:43x64
Microsoft.dynamics.nav.client.builder.dll7.0.34194.0225,00015-Jan-201306:43x64
Microsoft.dynamics.nav.client.serviceconnection.dll7.0.34194.0114,43215-Jan-201306:43x64
Microsoft.dynamics.nav.client.testpageclient.dll7.0.34194.036,60015-Jan-201306:44x64
Microsoft.dynamics.nav.client.ui.dll7.0.34194.0674,52815-Jan-201306:43x64
Microsoft.dynamics.nav.language.dll7.0.34194.04,132,05615-Jan-201306:43x64
Microsoft.dynamics.nav.management.dll7.0.34194.0133,85615-Jan-201306:44x64
Microsoft.dynamics.nav.management.dll-help.xmlNot applicable293,02808-Dec-201204:30Not applicable
Microsoft.dynamics.nav.navuseraccount.dll7.0.34194.014,56815-Jan-201306:43x64
Microsoft.dynamics.nav.ncl.dll7.0.34194.01,583,31215-Jan-201306:44x64
Microsoft.dynamics.nav.server.exe7.0.34194.0136,92015-Jan-201306:44x64
Microsoft.dynamics.nav.server.vsswriter.core.dll7.0.34194.070,39215-Jan-201306:44x64
Microsoft.dynamics.nav.server.vsswriter.dll7.0.34194.022,76015-Jan-201306:44x64
Microsoft.dynamics.nav.server.vsswriterservice.exe7.0.34194.016,12015-Jan-201306:44x64
Microsoft.dynamics.nav.service.dll7.0.34194.0180,95215-Jan-201306:44x64
Microsoft.dynamics.nav.service.odataservice.dll7.0.34194.017,65615-Jan-201306:44x64
Microsoft.dynamics.nav.service.odataserviceprovider.dll7.0.34194.072,45615-Jan-201306:44x64
Microsoft.dynamics.nav.service.runtime.dll7.0.34194.070,88815-Jan-201306:44x64
Microsoft.dynamics.nav.service.webmetadata.dll7.0.34194.041,71215-Jan-201306:44x64
Microsoft.dynamics.nav.service.webservices.dll7.0.34194.0108,27215-Jan-201306:44x64
Microsoft.dynamics.nav.types.dll7.0.34194.0726,23215-Jan-201306:43x64
Microsoft.dynamics.nav.watson.dll7.0.34194.064,72815-Jan-201306:43x64
Navadmintool.ps1Not applicable10,23215-Jan-201306:51Not applicable
Nclcsrts.dll7.0.34194.02,360,49615-Jan-201306:44x64
Sqmapi.dll6.1.7600.16385241,98415-Oct-201216:55x64
Microsoft.dynamics.framework.ui.extensibility.dll7.0.34194.021,75215-Jan-201306:43x64
Microsoft.dynamics.nav.client.businesschart.model.dll7.0.34194.034,04815-Jan-201306:43x64
Microsoft.dynamics.nav.client.codeviewertypes.dll7.0.34194.014,07215-Jan-201306:43x64
Microsoft.dynamics.nav.ewswrapper.dll7.0.34194.034,01615-Jan-201306:43x64
Microsoft.dynamics.nav.olsync.common.dll7.0.34194.020,20015-Jan-201306:43x64
Microsoft.dynamics.nav.olsync.olsyncsupplier.dll7.0.34194.036,60015-Jan-201306:43x64
Microsoft.dynamics.nav.do.clientproxywrapper.dll7.0.34194.059,64015-Jan-201306:43x64
Microsoft.dynamicsonline.doclientproxy.dll7.1.23.0336,27215-Oct-201216:41x64
Microsoft.dynamicsonline.doclientproxy.paymentservice.dll7.1.23.0119,69615-Oct-201216:41x64
Microsoft.dynamicsonline.doclientproxy.usermanagement.dll7.1.23.0101,26415-Oct-201216:41x64
Microsoft.dynamics.nav.openxml.dll7.0.34194.055,00015-Jan-201306:43x64
Microsoft.dynamics.nav.smtp.dll7.0.34194.026,83215-Jan-201306:43x64
Microsoft.dynamics.framework.ui.winforms.datavisualization.timeline.dll1.5.11910.98170,36815-Jan-201304:30x64
Microsoft.dynamics.nav.client.timelinevisualization.dll7.0.34194.034,56815-Jan-201306:43x64
Microsoft.dynamics.nav.timer.dll7.0.34194.014,55215-Jan-201306:43x64


To replace the existing Microsoft Dynamics NAV files, follow these steps:
  1. Stop the Microsoft Dynamics NAV Server service.
  2. Copy the files in the NST folder from the files that you downloaded.
  3. Paste the files into the Microsoft Dynamics NAV Server installation directory. The Microsoft Dynamics NAV Server is usually installed in the following directory:
    C:\Program Files\Microsoft Dynamics NAV\70\Service
  4. Click Yes to overwrite the files in the directory.
  5. Start the Microsoft Dynamics NAV Server service.

Step 2: Replace the files in the Microsoft Dynamics NAV RoleTailored (Windows) client installation

In the Microsoft Dynamics NAV RoleTailored client installation, replace the files by using the hotfix files.
File nameFile versionFile sizeDateTimePlatform
Finhlink.exe7.0.34194.0435,88815-Jan-201306:51x86
Finsql.exe7.0.34194.012,559,52815-Jan-201306:44x86
Microsoft dynamics nav server.mscNot applicable63,87115-Oct-201216:55Not applicable
Microsoft.dynamics.framework.patterns.dll7.0.34194.071,91215-Jan-201306:44x86
Microsoft.dynamics.framework.ui.dll7.0.34194.01,173,20815-Jan-201306:44x86
Microsoft.dynamics.framework.ui.extensibility.dll7.0.34194.021,75215-Jan-201306:44x86
Microsoft.dynamics.framework.ui.mapping.dll7.0.34194.016,61615-Jan-201306:44x86
Microsoft.dynamics.framework.ui.navigation.dll1.5.11910.9826,44015-Jan-201304:30x86
Microsoft.dynamics.framework.ui.ux2006.dll7.0.34194.087,27215-Jan-201306:44x86
Microsoft.dynamics.framework.ui.ux2006.winforms.dll7.0.34194.0119,04015-Jan-201306:44x86
Microsoft.dynamics.framework.ui.windows.dll7.0.34194.099,04815-Jan-201306:44x86
Microsoft.dynamics.framework.ui.winforms.controls.dll1.5.11910.982,348,37615-Jan-201304:30x86
Microsoft.dynamics.framework.ui.winforms.datavisualization.dll1.5.11910.98137,57615-Jan-201304:30x86
Microsoft.dynamics.framework.ui.winforms.dll7.0.34194.01,380,08015-Jan-201306:44x86
Microsoft.dynamics.nav.client.builder.dll7.0.34194.0225,00015-Jan-201306:44x86
Microsoft.dynamics.nav.client.exe7.0.34194.0116,95215-Jan-201306:44x86
Microsoft.dynamics.nav.client.pagedesigner.dll7.0.34194.023,28015-Jan-201306:44x86
Microsoft.dynamics.nav.client.serviceconnection.dll7.0.34194.0114,43215-Jan-201306:44x86
Microsoft.dynamics.nav.client.ui.dll7.0.34194.0674,52815-Jan-201306:44x86
Microsoft.dynamics.nav.client.winclient.dll7.0.34194.0191,72015-Jan-201306:44x86
Microsoft.dynamics.nav.client.winforms.dll7.0.34194.0353,00015-Jan-201306:44x86
Microsoft.dynamics.nav.client.winforms.tlbNot applicable2,66415-Jan-201304:56Not applicable
Microsoft.dynamics.nav.dotnetbridge.dll7.0.34194.0223,96815-Jan-201306:44x86
Microsoft.dynamics.nav.exceladdin.dll7.0.34194.093,92015-Jan-201306:44x86
Microsoft.dynamics.nav.exceladdin.dll.manifestNot applicable35,06815-Jan-201308:26Not applicable
Microsoft.dynamics.nav.exceladdin.vstoNot applicable15,66115-Jan-201308:29Not applicable
Microsoft.dynamics.nav.language.dll7.0.34194.04,132,05615-Jan-201306:44x86
Microsoft.dynamics.nav.managementui.dll7.0.34194.0388,83215-Jan-201306:44x86
Microsoft.dynamics.nav.openxml.dll7.0.34194.055,00015-Jan-201306:44x86
Microsoft.dynamics.nav.transformation.reporting.dll7.0.34194.0111,87215-Jan-201306:44x86
Microsoft.dynamics.nav.types.dll7.0.34194.0726,23215-Jan-201306:44x86
Microsoft.dynamics.nav.watson.dll7.0.34194.064,72815-Jan-201306:44x86
Microsoft.office.interop.excel.dll14.0.4733.10001,550,20015-Oct-201216:52x86
Microsoft.office.interop.outlook.dll14.0.4733.1000972,66415-Oct-201216:52x86
Microsoft.office.tools.common.v4.0.utilities.dll10.0.30319.132,66418-Jan-201100:26x86
Microsoft.office.tools.excel.v4.0.utilities.dll10.0.30319.1236,95218-Jan-201100:26x86
Microsoft.windows.shell.dll3.5.41019.1167,80815-Oct-201216:52x86
Ndbcs.dll7.0.34194.01,388,20015-Jan-201306:51x86
Nsobjectxproxy.dll7.0.34194.021,17615-Jan-201306:51x86
Office.dll14.0.4733.1000448,36015-Oct-201216:52x86
Ribboncontrolslibrary.dll3.5.41019.1778,61615-Oct-201216:52x86
Rotaccess.dll7.0.34194.0175,79215-Jan-201306:51x86
Microsoft.dynamics.bapiwrapper.dll7.0.34194.020,18415-Jan-201306:44x86
Microsoft.dynamics.nav.client.businesschart.dll7.0.34194.018,68015-Jan-201306:44x86
Microsoft.dynamics.nav.client.businesschart.model.dll7.0.34194.034,04815-Jan-201306:44x86
Microsoft.dynamics.nav.client.codeviewer.dll7.0.34194.028,91215-Jan-201306:44x86
Microsoft.dynamics.nav.client.codeviewercommon.dll7.0.34194.014,07215-Jan-201306:44x86
Microsoft.dynamics.nav.client.codeviewertypes.dll7.0.34194.014,07215-Jan-201306:44x86
Microsoft.dynamics.nav.client.codeviewer.coderendering.dll7.0.34194.058,64015-Jan-201306:44x86
Microsoft.visualstudio.coreutility.dll10.0.30319.151,07215-Oct-201216:52x86
Microsoft.visualstudio.extensibilityhosting.dll10.0.30319.1138,13615-Oct-201216:52x86
Microsoft.visualstudio.language.intellisense.dll10.0.30319.171,06415-Oct-201216:52x86
Microsoft.visualstudio.language.standardclassification.dll10.0.30319.128,59215-Oct-201216:52x86
Microsoft.visualstudio.platform.vseditor.dll10.0.30319.11,716,62415-Oct-201216:52x86
Microsoft.visualstudio.platform.vseditor.interop.dll10.0.0.056,73615-Oct-201216:52x86
Microsoft.visualstudio.text.data.dll10.0.30319.1134,01615-Oct-201216:52x86
Microsoft.visualstudio.text.internal.dll10.0.30319.149,54415-Oct-201216:52x86
Microsoft.visualstudio.text.logic.dll10.0.30319.187,93615-Oct-201216:52x86
Microsoft.visualstudio.text.ui.dll10.0.30319.1113,52815-Oct-201216:52x86
Microsoft.visualstudio.text.ui.wpf.dll10.0.30319.1115,07215-Oct-201216:52x86
Microsoft.visualstudio.ui.text.wpf.keyprocessor.implementation.dll7.0.34194.020,25615-Jan-201306:44x86
Microsoft.visualstudio.ui.undo.implementation.dll7.0.34194.028,92015-Jan-201306:44x86
Microsoft.dynamics.nav.client.dynamicsonlineconnect.dll7.0.34194.044,80815-Jan-201306:44x86
Microsoft.dynamics.nav.management.dsobjectpickerwrapper.dll7.0.34194.018,70415-Jan-201306:44x86
Microsoft.dynamics.nav.mx.dll7.0.34194.065,23215-Jan-201306:44x86
Microsoft.dynamics.elstertransferhandler.dll7.0.34194.040,17615-Jan-201306:44x86
Microsoft.dynamics.nav.ewswrapper.dll7.0.34194.034,01615-Jan-201306:44x86
Microsoft.dynamics.nav.integration.office.dll7.0.34194.027,37615-Jan-201306:44x86
Microsoft.dynamics.nav.olsync.common.dll7.0.34194.020,20015-Jan-201306:44x86
Microsoft.dynamics.nav.olsync.olsyncsupplier.dll7.0.34194.036,60015-Jan-201306:44x86
Microsoft.dynamics.nav.do.clientproxywrapper.dll7.0.34194.059,64015-Jan-201306:44x86
Microsoft.dynamicsonline.doclientproxy.dll7.1.23.0336,27215-Oct-201216:41x86
Microsoft.dynamicsonline.doclientproxy.paymentservice.dll7.1.23.0119,69615-Oct-201216:41x86
Microsoft.dynamicsonline.doclientproxy.usermanagement.dll7.1.23.0101,26415-Oct-201216:41x86
Microsoft.dynamics.nav.openxml.dll7.0.34194.055,00015-Jan-201306:43x86
Microsoft.dynamics.nav.client.pingpong.dll7.0.34194.015,08015-Jan-201306:44x86
Microsoft.dynamics.nav.smtp.dll7.0.34194.026,83215-Jan-201306:44x86
Microsoft.dynamics.framework.ui.winforms.datavisualization.timeline.dll1.5.11910.98170,36815-Jan-201304:30x86
Microsoft.dynamics.nav.client.timelinevisualization.dll7.0.34194.034,56815-Jan-201306:44x86
Microsoft.dynamics.nav.timer.dll7.0.34194.014,55215-Jan-201306:44x86
Microsoft.dynamics.nav.navuseraccount.dll7.0.34194.014,56815-Jan-201306:44x86



To replace these files, follow these steps:
  1. Close the Microsoft Dynamics NAV RoleTailored client.
  2. Copy the files in the RTC folder from the files that you downloaded.
  3. Paste the files into the Microsoft Dynamics NAV RoleTailored client installation directory. The Microsoft Dynamics NAV RoleTailored client is usually installed in the following directory:
    C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client
  4. Click Yes to overwrite the files in the directory.

Note These steps must be followed for each Microsoft Dynamics NAV RoleTailored (Windows) client.

Step 3: Replace the files in the Microsoft Dynamics NAV Web client installation

If you have the Microsoft Dynamics NAV Web client installed, replace the files in the Microsoft Dynamics NAV Web client installation by using the hotfix files.
File nameFile versionFile sizeDateTimePlatform
Microsoft.dynamics.framework.patterns.dll7.0.34194.071,91215-Jan-201306:43x86
Microsoft.dynamics.framework.ui.clientservice.dll7.0.34194.035,57615-Jan-201306:44x86
Microsoft.dynamics.framework.ui.dll7.0.34194.01,173,20815-Jan-201306:43x86
Microsoft.dynamics.framework.ui.mapping.dll7.0.34194.016,61615-Jan-201306:43x86
Microsoft.dynamics.framework.ui.navigation.dll1.5.11910.9826,44015-Jan-201304:30x86
Microsoft.dynamics.framework.ui.ux2006.dll7.0.34194.087,27215-Jan-201306:43x86
Microsoft.dynamics.framework.ui.web.dll7.0.34194.02,155,23215-Jan-201306:44x86
Microsoft.dynamics.framework.ui.web.webclient.dll7.0.34194.01,178,36015-Jan-201306:44x86
Microsoft.dynamics.framework.ui.webbase.dll7.0.34194.081,64015-Jan-201306:44x86
Microsoft.dynamics.nav.client.builder.dll7.0.34194.0225,00015-Jan-201306:43x86
Microsoft.dynamics.nav.client.clientservice.dll7.0.34194.034,04015-Jan-201306:43x86
Microsoft.dynamics.nav.client.serviceconnection.dll7.0.34194.0114,43215-Jan-201306:43x86
Microsoft.dynamics.nav.client.ui.dll7.0.34194.0674,52815-Jan-201306:43x86
Microsoft.dynamics.nav.client.webclient.dll7.0.34194.057,57615-Jan-201306:43x86
Microsoft.dynamics.nav.client.webclientrunner.dll7.0.34194.011,51215-Jan-201306:43x86
Microsoft.dynamics.nav.client.webcommon.dll7.0.34194.0103,65615-Jan-201306:43x86
Microsoft.dynamics.nav.language.dll7.0.34194.04,132,05615-Jan-201306:43x86
Microsoft.dynamics.nav.types.dll7.0.34194.0726,23215-Jan-201306:43x86
Microsoft.dynamics.nav.watson.dll7.0.34194.064,72815-Jan-201306:43x86
Microsoft.reportviewer.webforms.dll10.0.40219.12,136,96015-Oct-201216:49x86
Microsoft.web.commandui.dll14.0.6016.1000137,06415-Oct-201216:39x86
Controls.cssNot applicable27,13115-Jan-201304:52Not applicable
Dlgframe.cssNot applicable1,17215-Jan-201304:52Not applicable
Main.cssNot applicable97,47015-Jan-201304:52Not applicable
Webclient.cssNot applicable6,41815-Jan-201304:52Not applicable


To replace these files, follow these steps:
  1. Close the Microsoft Dynamics NAV Web client.
  2. Copy the files in the WEB CLIENT folder from the files that you downloaded.
  3. Paste the files into the Microsoft Dynamics NAV Web client installation directory. The Microsoft Dynamics NAV Web client is usually installed in the following directory:
    C:\Program Files\Microsoft Dynamics NAV\70\Web Client
  4. Click Yes to overwrite the files in the directory.

Note These steps must be followed for each Microsoft Dynamics NAV Web client.

Step 4: Replace the files in the Microsoft Office Outlook Integration installation

If you have Microsoft Office Outlook Integration installed, replace the files in the Microsoft Office Outlook Integration installation by using the hotfix files.
File nameFile versionFile sizeDateTimePlatform
Mapihelper.dll7.0.34194.0105,13615-Jan-201306:44x86
Microsoft.dynamics.nav.olsync.navsyncaddin.dll7.0.34194.0604,91215-Jan-201306:44x86


To replace the files, follow these steps:
  1. Copy the files in the OUTLOOK folder from the files that you downloaded.
  2. Paste the files into the Microsoft Office Outlook Integration directory. Microsoft Office Outlook Integration is usually installed in the following directory:
    C:\Program Files(x86)\Microsoft Office\Office xx

    Note The xx placeholder represents the version of Microsoft Office that you have installed.
  3. Click Yes to overwrite the files in the installation directory.
  4. Copy the following file from the files that you downloaded:
    Microsoft.Dynamics.NAV.OLSync.NAVSyncAddIn.dll
  5. Paste the file into the language folders in the Microsoft Office Outlook Integration directory. The language folders are installed in the following directories:
    C:\Program Files (x86)\Microsoft Office\Office\xx-XX

    Note The xx-XX placeholder represents the language version, for example, en-US.

Step 5: Replace the files in the Microsoft Dynamics NAV Automated Data Capture System (ADCS) installation

If you have Automated Data Capture System (ADCS) installed, replace the following files in the Automated Data Capture System installation by using the hotfix files.
File nameFile versionFile sizeDateTimePlatform
Microsoft.dynamics.nav.vt100plugin.exe7.0.34194.072,41615-Jan-201306:44x86
Vt100_w2k_and_otherclients.xslNot applicable1,53615-Oct-201216:33Not applicable
Vt100_xphyperterminal.xslNot applicable1,75215-Oct-201216:33Not applicable


To replace the files, follow these steps:
  1. Copy the files in the ADCS folder from the files that you downloaded.
  2. Paste the files into the Automated Data Capture System installation directory. Automated Data Capture System is usually installed in the following directory:
    C:\Program Files (x86)\Microsoft Dynamics NAV\70\Automated Data Capture System
  3. Click Yes to overwrite the files in the directory.

Prerequisites

You must have Microsoft Dynamics NAV 2013 installed to apply this hotfix.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Propiedades

Id. de artículo: 2795296 - Última revisión: 30 ene. 2017 - Revisión: 4

Comentarios