Crystal Report: the text data type cannot be selected as distinct because it is not comparable

Go to the Database menu.  Is "Select Distinct Records" greyed out?  If not, turn it on.

Activate Analytical Accounting Manually

The case after installing and configuring the AA normally I noticed that the AA is not activated at the company and after investigation I activated it Manually from the Dynamics.db open AAG00104 then select the company and modify the aaCompanyStatus to 4 then you will find the AA is activated at the relevant database.

But don’t forget to backup your databases before  :)

Error message when you try to post a journal entry that contains Analytical Accounting assignments in Microsoft Dynamics GP : "Cannot insert the value NULL into column 'aatrxsource' table"

Cause:

This problem occurs because an Analytical Accounting record is missing in the SY01000 table.

Solution:

Run the following script in an appropriate SQL query tool against the company database.

insert into SY01000 VALUES (0,2,0,'Analytical Accounting','AATRX',1,'')

Wish it will help.

BR,

Mohammed Tohamy