Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Find Field In Table But I Cannot Find in AOT

Posted on by 175

I'm Create Custom Field The field is show in SQL table  But the field not show in AOT 

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Find Field In Table But I Cannot Find in AOT

    Hi Abd, 

    Could you share some screenshots about your issue, and let us know the exact steps that were used to create the fields. Right now it's unclear, first you talked about not seeing field in AOT, now you say you don't see entity field in SQL. Or is this already a different question than your first one?

    Please keep us updated, and remember that the better details you share, the better help you will get. 

    Thanks! 

  • Abd Alsameea Nat Profile Picture
    Abd Alsameea Nat 175 on at
    RE: Find Field In Table But I Cannot Find in AOT

    Hi Sir ,

    I'm create custom field  and this field show inside table in sql ,, But when create entity the field is not show !!

    thank you

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: Find Field In Table But I Cannot Find in AOT

    Hi Abd,

    I do assume you are using the configuration option for the custom fields. Nikolaos is correct that these fields only exists on run-time. You can't use them for any additional x++ logic. I wrote a blog about this before: Custom fields: Handle with care (Microsoft Dynamics 365 for Finance and Operations) (dynamicspedia.com)

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Find Field In Table But I Cannot Find in AOT

    Hi Abd,

    1) Which version are you working with? AX2012 or D365 F&O?

    2) How did you create the field? If you created a D365 "Custom field" via the user interface, it's indeed not stored in AOT but it exists in the SQL database. Only fields that are added by the developer using Visual Studio are shown in the AOT.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans