web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Field not appearing in field picker when accessing a table via the Excel Add-in

(0) ShareShare
ReportReport
Posted on by 2,007

I have searched the Internet in an attempt to not have to post this, but none of the solutions I have seen have worked, so I am wondering if anyone has any other suggestions.

I have a custom table with two fields. Both fields are 64 bit integer fields. Originally, one field had a label and the other did not. The field with label appears in the field picker when we access the field via the Excel Add-in, the one that did not doesn't. After searching this forum, we added a label to the missing field as the post indicated this would resolve the issue. It didn't. 

I then followed the advice to run a full CIL build, clear caches, refresh AIF services and redeploy the AIFGDS service group. This also did not resolve the issue.

An examination of the properties of both fields show that apart from the initial state of not having a label, these two fields have identical properties. The only other difference is that the table has a field relationship defined for the field that appears and the one that is missing does not.

Does anyone have any other suggestions of how we can make the missing field appear?

*This post is locked for comments

I have the same question (0)
  • Otavio Anaga Profile Picture
    216 on at

    You can try to create an identical table to see if when you do all the steps from the start, the things works fine.

    When you cleaned the caches, did you deleted the .AUC e .KTI files? this is an important step when you have problems like this

    let me know if it worked!

  • Verified answer
    Martin Dráb Profile Picture
    237,757 Most Valuable Professional on at

    What does the field represent? Isn't it actually a reference to RecId of another field (and the missing relationship prevents AX from expanding the foreign key to the natural key of the referenced table)?

  • Brandt Fundak Profile Picture
    2,007 on at

    Martin,

    This was precisely the issue. The table is essentially a bridge between two other tables. Once I added the second table relationship, they were able to see the fields they were looking for.

    Thanks for the response.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#2
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

#2
Rahul.p Profile Picture

Rahul.p 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans