The query selection of a product group in the setup of Enterprise Portal in Administration returns an incorrect result in Microsoft Dynamics AX 2009

Applies to: Microsoft Dynamics NAV 2009 Service Pack 1Dynamics NAV 2009

Template: AX Hotfix Template
This article applies to Microsoft Dynamics AX 2009 for all regions.

Symptoms


Consider the following scenario in Microsoft Dynamics AX 2009: you have several product groups whose type is Item node in the setup of Enterprise Portal in Administration. Then, you specify different values in the Criteria field in the select query of the select items for the product groups. When you view the value in the Criteria field in the select query of the select items for a product group, the value is incorrect. Therefore, the result that is returned by the select query is incorrect.

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 Web site: 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 Web sites:

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.

Installation information

For more information about how to install this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:

893082 How to install a Microsoft Dynamics AX hotfix

Prerequisites

You must have one of the following products installed to apply this hotfix:
  • Microsoft Dynamics AX 2009 Service Pack 1
  • Microsoft Dynamics AX 2009
Note Two hotfix files are available. Use the hotfix file that is appropriate for the specific product.

Restart requirement

You are not required to restart the computer after you apply this hotfix.

File information

The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

For Microsoft Dynamics AX 2009 Service Pack 1

File nameFile versionFile sizeDateTimePlatformSP requirement
Axupdate.exeNot applicable61,28813-Feb-200905:23x86SP1
Kb967923.xpoNot applicable2,99513-Feb-200905:14Not applicableSP1
Metadata.xmlNot applicable7013-Feb-200905:14Not applicableSP1
Axsetupsp.exe5.0.1100.91,538,91214-Jan-200919:28x86SP1
Cabextractor.dllNot applicable18,80013-Feb-200905:23x86None
Microsoft.dynamics.setup.reportingservices.dll5.0.1100.9150,44014-Jan-200919:28x86None
Axsetupsp.resources.dll5.0.1100.11523,12014-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,33631-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11519,02414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11519,02414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82431-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11519,02414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82431-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11523,12014-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82431-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11519,02414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82431-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:03x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11523,12014-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,84831-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11519,02414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82431-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11519,02414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11531,31214-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4518,87231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11539,50414-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4520,40831-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11514,92814-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31231-Dec-200803:04x86None
Axsetupsp.resources.dll5.0.1100.11510,83214-Jan-200919:28x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4515,80031-Dec-200803:04x86None
Cabextractor.dllNot applicable22,38413-Feb-200905:23x64None

For Microsoft Dynamics AX 2009

File nameFile versionFile sizeDateTimePlatform
Axpatch.exeNot applicable61,27213-Feb-200908:22x86
Kb967923.xpoNot applicable2,99413-Feb-200903:48Not applicable
Metadata.xmlNot applicable7013-Feb-200903:48Not applicable
Axsetupsp.exe5.0.593.4161,619,80013-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0579,44013-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0575,35213-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0575,34413-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,24813-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0575,34413-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,24813-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,24813-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0579,44013-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0575,35213-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0575,34413-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0571,25613-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0587,63213-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0571,24813-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0595,83213-Feb-200908:23x86
Axsetupsp.resources.dll5.0.593.0571,24813-Feb-200908:24x86
Axsetupsp.resources.dll5.0.593.0567,15213-Feb-200908:24x86

Objects that are affected

This hotfix affects the following objects:
  • \Classes\InventProductGroupSelectItem\main
  • \Classes\InventProductGroupSelectItem\initParmDefault

Validation of the application hotfix installation

To validate the installation of the application hotfix, open the SysHotfixManifest class in the Application Object Tree (AOT), and then verify that there is a method whose name is the same as the KB article number of the installed hotfix.

Additionally, you can cross-check the affected objects by viewing the KB967923.txt file against the objects in the AOT. Therefore, you can make sure that the objects are changed correctly in the SYP layer or the GLP layer.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.