This blog contains posts from the Microsoft Dynamics AX support team highlighting interesting features or issues within Microsoft Dynamics AX.
The configuration key Sales tax (ledgerbasicSalesTax) has been turned off in the system. When running example the retail statement posting, the performance is very poor.
The slow response is originated in every call to TaxParameters::find().
When analyzing the sql server queries we see a large number of Temporary table been generated which all take 150-200 msec.
We have explained what is happening in this article.
TempDB Tables forDisabled Tables
You can disable a regularpersisted database table by disabling the configuration keythat controls the table. Disabling the key causes the system to automaticallycreate a TempDB style of temporary table that matches the fields and schema ofthe database table. This temporary table exists in the underlying SQL Serverdatabase and is managed by the Application Object Server (AOS).
The purpose of automaticallycreating this TempDB table is to enable AOT objects that reference the disabledtable to continue to compile and run. You can read and write to this TempDBtable even though the configuration key is disabled.
All table buffer variablesinherit the methods of the xRecord class. One suchmethod is setTmp, which creates an InMemory temporarytable that has the same schema as the regular table. However, the setTmp method cannot create an InMemory table from a TempDBtable. You can call the method isTempDb to determinewhether the setTmp method is available.
Turn it on again.
In the example with sales tax use a tax percentage of 0,00% instead
Author: Kim Truelsen
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics