Sunday, January 15, 2012

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"

This problem occurs because an Analytical Accounting record is missing in the SY01000 table.
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.
Mohammed Tohamy

No comments:

Post a Comment