Thursday, May 14, 2015

AX2012 Location of table CompanyInfo in SQL Server

Recently, I had a serious problem about field dataAreaId. The issue is when creating a new record on InventTable, It always got a wrong dataAreaId. (For example, I hope it created 'c01', but it did 'c99' instead.)









After check, I found that method initValue() generate that dataAreaId from somewhere else which not in table CompanyInfo.

So it would save a lot of time if we know the exact table in SQL Server which kept AX's table CompanyInfo.

Here it's.
SQL Server ---> table 'DataArea' or view 'CompanyView'
AX             ---> table 'CompanyInfo'










From above, I can get the cause of this issue. The wrong dataAreaId came from the virtual company and table collection setting cause.

Have a good day!

No comments:

Post a Comment