The "Inventory by inventory dimension aging" report displays incorrect data if the current on-hand quantity is zero when you run the report in Microsoft Dynamics AX 2009

Applies to: LogisticsMicrosoft Dynamics AX 2009

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.
This article applies to Microsoft Dynamics AX for all regions.

Symptoms


When you run the "Inventory by inventory dimension aging" report in Microsoft Dynamics AX 2009, the report displays incorrect data. This problem occurs if the current on-hand quantity is zero when you run the report.

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

If you have customizations for one or more of the methods or the tables that are affected by this hotfix, you must follow these steps:
  1. Review the changes that are documented in the .xpo file.
  2. Apply these changes in a test environment before you apply the hotfix in a production environment.
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 Microsoft Dynamics AX 2009 or Microsoft Dynamics AX 2009 Service Pack 1 installed to apply this hotfix.

Restart requirement

If you are prompted to restart the computer, you must 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.
Microsoft Dynamics AX 2009
File nameFile versionFile sizeDateTimePlatform
Axpatch.exeNot applicable61,27204-Feb-200905:42x86
Kb967497-syp.cabNot applicable10,06204-Feb-200905:42Not applicable
Licensetermsar.rtfNot applicable105,43012-Jun-200809:42Not applicable
Licensetermscs.rtfNot applicable91,18112-Jun-200809:42Not applicable
Licensetermsda.rtfNot applicable101,27712-Jun-200809:42Not applicable
Licensetermsde.rtfNot applicable117,30312-Jun-200809:42Not applicable
Licensetermsen.rtfNot applicable102,69812-Jun-200809:42Not applicable
Licensetermses.rtfNot applicable96,27012-Jun-200809:42Not applicable
Licensetermset.rtfNot applicable103,76912-Jun-200809:42Not applicable
Licensetermsfi.rtfNot applicable108,28012-Jun-200809:42Not applicable
Licensetermsfr.rtfNot applicable128,73012-Jun-200809:42Not applicable
Licensetermshu.rtfNot applicable96,22012-Jun-200809:42Not applicable
Licensetermsis.rtfNot applicable109,43812-Jun-200809:42Not applicable
Licensetermsit.rtfNot applicable116,56012-Jun-200809:42Not applicable
Licensetermsja.rtfNot applicable102,32912-Jun-200809:42Not applicable
Licensetermslt.rtfNot applicable124,66412-Jun-200809:42Not applicable
Licensetermslv.rtfNot applicable105,94912-Jun-200809:42Not applicable
Licensetermsnb-no.rtfNot applicable116,07312-Jun-200809:42Not applicable
Licensetermsnl.rtfNot applicable112,35812-Jun-200809:42Not applicable
Licensetermspl.rtfNot applicable115,77312-Jun-200809:42Not applicable
Licensetermspt-br.rtfNot applicable101,12712-Jun-200809:42Not applicable
Licensetermsru.rtfNot applicable141,29112-Jun-200809:42Not applicable
Licensetermssv.rtfNot applicable114,26212-Jun-200809:42Not applicable
Licensetermsth.rtfNot applicable151,46812-Jun-200809:42Not applicable
Licensetermstr.rtfNot applicable102,18412-Jun-200809:42Not applicable
Licensetermszh-hans.rtfNot applicable100,01112-Jun-200809:42Not applicable
Axsetupsp.exe5.0.593.3771,619,81604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0579,44804-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,24804-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0575,35204-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,24804-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0575,35204-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0575,35204-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0579,44804-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,24804-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0575,34404-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0575,35204-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,24804-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0587,64004-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,24804-Feb-200905:42x86
Axsetupsp.resources.dll5.0.593.0595,83204-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0571,25604-Feb-200905:43x86
Axsetupsp.resources.dll5.0.593.0567,16004-Feb-200905:43x86
Microsoft Dynamics AX 2009 with Service Pack 1
File nameFile versionFile sizeDateTimePlatformSP requirement
Axupdate.exeNot applicable61,28804-Feb-200903:24x86SP1
Kb967497-syp.cabNot applicable10,10404-Feb-200903:24Not applicableSP1
Licensetermsar.rtfNot applicable2,59512-Dec-200808:20Not applicableSP1
Licensetermscs.rtfNot applicable93,32412-Dec-200808:20Not applicableSP1
Licensetermsda.rtfNot applicable103,94712-Dec-200808:20Not applicableSP1
Licensetermsde.rtfNot applicable119,65412-Dec-200808:20Not applicableSP1
Licensetermsen.rtfNot applicable104,52212-Dec-200808:20Not applicableSP1
Licensetermses.rtfNot applicable98,78412-Dec-200808:20Not applicableSP1
Licensetermset.rtfNot applicable104,18912-Dec-200808:20Not applicableSP1
Licensetermsfi.rtfNot applicable106,43612-Dec-200808:20Not applicableSP1
Licensetermsfr.rtfNot applicable133,25112-Dec-200808:20Not applicableSP1
Licensetermshu.rtfNot applicable94,07012-Dec-200808:20Not applicableSP1
Licensetermsis.rtfNot applicable35,12512-Dec-200808:20Not applicableSP1
Licensetermsit.rtfNot applicable118,32112-Dec-200808:20Not applicableSP1
Licensetermsja.rtfNot applicable107,22912-Dec-200808:20Not applicableSP1
Licensetermslt.rtfNot applicable125,42012-Dec-200808:20Not applicableSP1
Licensetermslv.rtfNot applicable107,62212-Dec-200808:20Not applicableSP1
Licensetermsnb-no.rtfNot applicable119,19812-Dec-200808:20Not applicableSP1
Licensetermsnl.rtfNot applicable113,59812-Dec-200808:20Not applicableSP1
Licensetermspl.rtfNot applicable119,21112-Dec-200808:20Not applicableSP1
Licensetermspt-br.rtfNot applicable103,07812-Dec-200808:20Not applicableSP1
Licensetermsru.rtfNot applicable151,25512-Dec-200808:20Not applicableSP1
Licensetermssv.rtfNot applicable118,80412-Dec-200808:20Not applicableSP1
Licensetermsth.rtfNot applicable155,18912-Dec-200808:20Not applicableSP1
Licensetermstr.rtfNot applicable105,02912-Dec-200808:20Not applicableSP1
Licensetermszh-hans.rtfNot applicable101,74312-Dec-200808:20Not applicableSP1
Axsetupsp.exe5.0.1100.91,538,91215-Jan-200905:56x86SP1
Cabextractor.dllNot applicable18,80004-Feb-200903:24x86None
Microsoft.dynamics.setup.reportingservices.dll5.0.1100.9150,44015-Jan-200905:56x86None
Axsetupsp.resources.dll5.0.1100.11523,12015-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,33612-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11519,02415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11519,02415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82412-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11519,02415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82412-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11523,12015-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82412-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11519,02415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82412-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11523,12015-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,84812-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11519,02415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82412-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11519,02415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11531,31215-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4518,87212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11539,50415-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4520,40812-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11514,92815-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31212-Dec-200808:45x86None
Axsetupsp.resources.dll5.0.1100.11510,83215-Jan-200905:56x86None
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4515,80012-Dec-200808:45x86None
Cabextractor.dllNot applicable22,38404-Feb-200903:24x64None

Objects that are affected

This hotfix affects the following object:
  • \Reports\InventAgeDim\methods\calcAll

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 KB967497.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.