Skip to main content What is Dynamics 365? Guided tours Customer stories Try our products CRM ERP Sales Service Sales Customer Insights Customer Service Contact Center Field Service Supply Chain Management Commerce Finance Project Operations Human Resources Business Central Pricing Business application topics Training & certifications Migrate to the cloud Documentation Events Dynamics 365 Blog Product updates Onboarding and implementation Community Find a partner Software Development Companies Partner resources Microsoft Marketplace Product documentation Technical support On-premises product support Contact us Try for free Sign in
  • 1 min read

Slow opening of form “Business relations details” after updating to MS Dynamics AX 2009 SP 1 RU 8


If you work with a reasonable amount of companies per database (>20) then it might take nearly 1 minute to open form “Business relations details” by pressing button function “Convert to customer” or “Convert to vendor”
Creating the following index may speed up the process quite a lot. So check it out in your test environment first if you like:

“Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability or fitness for a particular purpose. This mail message assumes that you are familiar with the programming language that is being demonstrated and the tools that are used to create and debug procedures.”

Table address

Index Name: RedIDDataAreaID

Index fields: RecID, DataAreaID

Important note: Please be aware that the filed sequence in the new index is important!

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.