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 :
Finance | Project Operations, Human Resources, ...
Answered

Created by and Created date and time field not appearing

(0) ShareShare
ReportReport
Posted on by 535

Hi,

I've extended  "VendPurchOrderJour" table and modified the property "No" to "Yes" for Created by and Created date & time field.

Finally, I have sync and build the project. but, i'm unable to fetch the field using select statement. "Field is not appearing".

Kindly check an help me pls

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    Remember to build before sync. The database sync is based on the compiled binaries so if you sync before you built your changes, the new fields will not appear.

  • Vignesh R Profile Picture
    535 on at

    Hi Nikolaos,

    As you suggested, I've tried. Still, I'm unable to access the Created by and Created date time field

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,170 Super User 2025 Season 2 on at

    Hi AXDeveloper,

    What exactly do you mean with field is not appearing? Is it about intelli-sense which is not showing the field? In that case, try to type the field name in your select statement.

  • Vignesh R Profile Picture
    535 on at

    Intelli-Sense is not showing the extended Created by and Created date and time field

  • Verified answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    Ok but can you still actually use the fields in your code? If you just type the field, can you compile succesfully and does your code work?

  • Vignesh R Profile Picture
    535 on at

    Hi Nikolaos,

    I have typed manually the field name "CreatedBy" in code and build the project. I haven't reached any error message in my code.

    Why does Intelli-Sence is not showing the created by field?

  • Suggested answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    In general IntelliSense seems quite buggy with D365FO. So, it's a bug. You can report it to Microsoft support, that will definetely help getting it fixed.

  • Vignesh R Profile Picture
    535 on at

    Thank you Nikolaos

  • Tahir Baashar Profile Picture
    20 on at

    created date and time is blank also balance is 000. pastedimage1667829382889v1.png

  • Suggested answer
    GirishS Profile Picture
    27,827 Moderator on at

    I think you don't get created date and time values for old records.

    It will be available for newly created records after enabling created date time in table.

    Thanks,

    Girish S.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans