You experience slow performance when you do a sales tax settlement in India in Microsoft Dynamics AX 2009 SP1

This article applies to Microsoft Dynamics AX for the India (in) region.

Symptoms

You experience slow performance in India in Microsoft Dynamics AX 2009 Service Pack 1 (SP1) when you try to do sales tax settlement that has many tax transactions.

Resolution

Extra terms are used to reduce the performance cost sqls.

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:

https://mbs.microsoft.com/support/newstart.aspx 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:

Partners

https://mbs.microsoft.com/partnersource/support/Customers

https://mbs.microsoft.com/customersource/support/information/SupportInformation/global_support_contacts_eng.htmIn 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 SP1 installed to apply this hotfix.

Restart requirement

You must restart the Application Object Server (AOS) service after you apply this hotfix.

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 name

File version

File size

Date

Time

Platform

Axupdate.exe

Not Applicable

62,120

05-May-2013

01:49

x86

Kb2840943-glp-cons.cab

Not Applicable

4,550,483

05-May-2013

01:49

Not Applicable

Kb2840943-syp-cons.cab

Not Applicable

5,572,740

05-May-2013

01:49

Not Applicable

Axsetupsp.exe

5.0.1100.45

1,637,040

05-May-2013

01:49

x86

Cabextractor.dll

Not Applicable

19,632

05-May-2013

01:48

x86

Microsoft.dynamics.setup.reportingservices.dll

5.0.1100.9

150,440

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

539,328

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

17,336

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,824

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,824

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

539,328

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,824

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

539,328

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1500.1212

16,320

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,824

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

543,424

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

17,848

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,824

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

535,232

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

547,520

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

18,872

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

559,808

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

20,408

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

531,136

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

16,312

12-Apr-2013

14:38

x86

Axsetupsp.resources.dll

5.0.1100.40

527,040

05-May-2013

01:49

x86

Microsoft.dynamics.setup.reportingservices.resources.dll

5.0.1000.45

15,800

12-Apr-2013

14:38

x86

Cabextractor.dll

Not Applicable

23,216

05-May-2013

01:49

x64


Validation of the application hotfix installationTo validate the installation of the application hotfix, open the SysHotfixManifest class in the Application Object Tree (AOT). Then, verify that there is a method whose name includes the Knowledge Base (KB) article number of the installed hotfix. Additionally, you can cross-check the affected objects by comparing the KBXXXXXX.txt file against the objects in the AOT. By doing this, you can make sure that the objects are changed correctly in the SYP layer or in the GLP layer.

Note The XXXXXX placeholder represents the KB article number of the installed 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:

974255 Impact Analysis feature for Dynamics AX 2009

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×