You cannot use the Office add-in to generate documents that contain data that was valid in past or will be valid in future in Microsoft Dynamics AX 2012

This article applies to Microsoft Dynamics AX for all regions.

Symptoms

Assume that you use a static Application Object Tree (AOT) query that uses the HcmEmployment table as data source in Microsoft Dynamics AX 2012. When you try to apply the query in Microsoft Word by using the Office add-in, employment details of exiting employees are returned. However, the employment details of past and future employees are not returned. Therefore, you cannot use Office add-in to generate documents that contain data that was valid in past or will be valid in future.

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.


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 2012 installed to apply this hotfix.

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the 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.
File nameFile versionFile sizeDateTimePlatformService branch
Aximpactanalysis.exeNot applicable60,28022-May-201220:06x86Not applicable
Axupdate.exeNot applicable60,26422-May-201220:06x86Not applicable
Clientoba32.mspNot applicable21,127,16810-Jul-201216:29Not applicableNot applicable
Clientoba64.mspNot applicable21,127,16810-Jul-201216:29Not applicableNot applicable
Components32.mspNot applicable18,468,86410-Jul-201216:29Not applicableNot applicable
Components64.mspNot applicable35,725,31210-Jul-201216:29Not applicableNot applicable
Helpserver64.mspNot applicable901,12010-Jul-201216:29Not applicableNot applicable
Objectserver32.mspNot applicable7,278,59210-Jul-201216:29Not applicableNot applicable
Objectserver64.mspNot applicable9,240,57610-Jul-201216:29Not applicableNot applicable
Retaildatabaseutility.mspNot applicable270,33610-Jul-201216:29Not applicableNot applicable
Retailheadquarters32.mspNot applicable765,95210-Jul-201216:29Not applicableNot applicable
Retailheadquarters64.mspNot applicable765,95210-Jul-201216:29Not applicableNot applicable
Retailpos.mspNot applicable2,822,14410-Jul-201216:29Not applicableNot applicable
Retailposplugins.mspNot applicable147,45610-Jul-201216:29Not applicableRETAILPOSP
Retailstoreconnect32.mspNot applicable122,88010-Jul-201216:29Not applicableNot applicable
Retailstoreconnect64.mspNot applicable122,88010-Jul-201216:29Not applicableNot applicable
Retailtransactionservice.mspNot applicable122,88010-Jul-201216:29Not applicableNot applicable
Setupsupport32.mspNot applicable11,804,67210-Jul-201216:29Not applicableNot applicable
Setupsupport64.mspNot applicable19,083,26410-Jul-201216:29Not applicableNot applicable
Traceparser.mspNot applicable442,36810-Jul-201216:29Not applicableNot applicable
Axsetupsp.exe6.0.1108.12881,378,53610-Jul-201209:32x86Not applicable
Axutillib.dll6.0.1108.806821,48022-May-201220:06x86Not applicable
Microsoft.dynamics.servicing.operations.dll6.0.888.43635,75222-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491382,84822-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491378,75222-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201220:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491407,42422-May-201220:06x86Not applicable

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.
Properties

Article ID: 2733638 - Last Review: 2017 ots. 17 - Revision: 3

Microsoft Dynamics AX 2012, Microsoft Dynamics AX Application Object Server

Oharrak