Problem after deleting Active Directory User Account

I found my self in a strange situation after disabling a user from Microsoft Dynamics CRM 4.0 and the deleting the user from Active Directory. I couldn’t enable again the user because there was no Active Directory User associated with it. I tried many solutions to bypass this problem but they did not worked for me. The only solution that worked was to remove the company from the deployment (I made a backup first, just in case) and then I import the same company. When importing a company Microsoft Dynamics CRM 4.0 make new associations of crm users with active directory users, so I matched the disabled user with a new account of active directory.

Different sorting on Temporary and Normal Tables in Navision

Last week I had a problem with a client witch was that the export of dimensions on analysis view was wrong. After a lot of research I found the following detail. Navision sorting on Code field is different when the table is normal and when the table is temporary.

Lets say that we have a table with a key field (ID => Code 10). If we insert into table values ‘1000’, ‘1000-1’, ‘1001’ and we open the table we will see the following sorting

1000

1000-1

1001

If we create then a form with SourceTableTemporary = Yes on form properties

and insert the same values, the sorting will be like this

1000

1001

1000-1

Error Reinstalling CRM 4.0

The following error occurred when trying to reinstall MS Dynamics CRM 4.0. The problem is that the uninstall process of CRM does not make a complete removal of all the security principals from the system.

In order to make a proper uninstall of Microsoft Dynamics CRM 4.0 product, I followed the steps below:


1. I made the uninstall of all crm products from add/remove programs


2. I deleted all contents of crm directory. Mine was ‘C:\Program Files\Microsoft Dynamics CRM’


3. From Active Directory I removed all the crm principals

Principals in you deployment may be placed on other folder in Active Directory depending of the installation you have made


4. From Sql Server I made a backup and then a delete of all crm databases (*_MSCRM, *_CONFIG)
5. From Sql Server I removed all the crm principals

6. I deleted CRM registry settings HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM (I had a trace flag on, and a language pack)

After all this I made a brand new installation without any problem.


This post help me to come with this solution

How to determine if a Table has data per company in Microsoft Dynamics Nav

In order to find out if table data of Table is per company we are going to use a special table called Object. First we make the declaration of the record

Next at C/AL we can do the following

recTable.RESET;

recTable.SETRANGE(Type, recTable.Type::TableData);

recTable.SETRANGE("Company Name", '');

recTable.SETRANGE(ID, DATABASE::"Item Ledger Entry");  // Here use table id witch you want to inspect

IF recTable.FINDFIRST THEN

  // Table has not data per company

When Microsoft Dynamics Nav 2009 sp1 will be released for Greece

Well nobody knows for sure, but I heard unofficial from microsoft that the new version will be released at 1st of May. I' m looking forward to it