Field "fieldname" in Table "tablename" has not been explicitly selected in AX 2012

(0) Share

Report

Posted on by Giuseppe Caradonna

1,421

Hi all,

I've a Dynamics AX 2012 installation in my enviroment. When I open several forms (like Target Entities in Data Import Export Framework, or CustTrans, or VendTrans) I receive this error: Field "fieldname" in Table "tablename" has not been explicitly selected in AX 2012.

Can you tell me what can be the cause of this error?

*This post is locked for comments

I have the same question (0)

All responses (22)

Answers (3)

Petr Janík 975 on at

Like (0)

Report

Hi Guiseppe,

I have seen this error a few times. It can be caused by an illegal data in a table , e.g. it contains NULL value, which is not allowed in AX (except table inheritance). Sometimes it helps me to restart a client or AOS. Of course I assumed that you did full compile without errors and synchronized the database.

Was this reply helpful? Yes No
Giuseppe Caradonna 1,421 on at

Like (0)

Report

Hi Petr,

Unfortunately I have already compiled and synchronized the application without errors and restarted the AOS...Any other ideas?

Was this reply helpful? Yes No
Martin Dráb 237,959 Most Valuable Professional on at

Like (0)

Report

It means that the field was read but its value wasn't retrieved from database. See Tutorial: AX 2012 - Invalid field access or Accessing unretrieved fields for more detailed explanation.

Was this reply helpful? Yes No
Petr Janík 975 on at

Like (0)

Report

You are right Martin, but this is true if you select existing record from a table. In this case is evident that the user open the form DMFEntity for the first time. So, the table DMFEntity is empty and the init method of the DMFEntity form wants to populate this table with default mapping and calls the validateWrite method before insert.

Was this reply helpful? Yes No
Giuseppe Caradonna 1,421 on at

Like (0)

Report

Petr, is it a bug?

Was this reply helpful? Yes No
J. Pospisil 90 on at

Like (0)

Report

Hi,

I have the some problem with AX 2012R2:

This is the error msg when I run Sales Tax Report:

Stack trace: Field 'VATNum' in table 'CompanyInfo' has not been explicitly selected.

Stack trace

(S)\Classes\TaxReportingDP\insertTaxReportingTmp - line 82

(S)\Classes\TaxReportingDP\processReport - line 101

(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 57

(S)\Jobs\

Stack trace error appears also - for example - when I export data from the database.

Can somebody help me, please?

thx!

Was this reply helpful? Yes No
Gustavo Bagno on at

Like (0)

Report

I believe the original "select" is using a Field List, and the field DMFEntity is probably not in the field list, or for some other reason (aggregate functions maybe) the field may be not retrieved.

There is no problem on calling validateWrite before Insert. It's actually a good practive, but if the validateWrite is overridden in the Form Datasource, then there might be a need for a technical intervention.

Check that.

Was this reply helpful? Yes No
Giuseppe Caradonna 1,421 on at

Like (0)

Report

I get the same error in other places...CustTrans table --> postLoad() method, VendTrans table --> postLoad() method...What can I do to fix it?

Was this reply helpful? Yes No
Verified answer

Giuseppe Caradonna 1,421 on at

Like (1)

Report

Hi all,

I'm receiving this error in some other methods in AX. I am solving by changing the select statements adding the required field.

Was this reply helpful? Yes No
Kim Lee 5 on at

Like (0)

Report

What do you mean by "changing the select statements adding the required field"?

Was this reply helpful? Yes No