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