"createdDateTime" field doesn't exist in the "InventTable" of AOT

(0) Share

Report

Posted on by Community Member

Hi everyone,

I have a problem in the AOT which is, I can't find the "createdDateTime" field in the "InventTable". It exists in AX forms and also contains data, but is not found in AOT invenTable.

Can anyone help why this is happening and how can I solve it?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Florian Hopfner 2,460 on at

Like (1)

Report

RE: "createdDateTime" field doesn't exist in the "InventTable" of AOT

createdDateTime is a system field that is activated by the property "CreatedDateTime" on the table node. System fields are never shown in the list of fields under the Fields node of a table. As far as I know there is no way to make it show up in that list or to change properties of system fields.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 299,507 Super User 2025 Season 2 on at

Like (1)

Report

RE: "createdDateTime" field doesn't exist in the "InventTable" of AOT

Hi,

This field will be enabled if you set the property CreatedDateTime to Yes on the InventTable in the Tables node of the AOT. Note this is a small customization; it changes the standard object.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: "createdDateTime" field doesn't exist in the "InventTable" of AOT

Many thanks for your reply.

What I want to do is to create a report and add a field in it referencing the CreateDateTime field of the inventTable. Can you help me how to add this field to a query?

Thanks & Best Regards

Was this reply helpful? Yes No
Verified answer

Florian Hopfner 2,460 on at

Like (1)

Report

RE: "createdDateTime" field doesn't exist in the "InventTable" of AOT

Instead of dragging&dropping a field from a table into a query, you can right click the field node in a query data source and choose "New > Field". In the field property, enter the name of the field (e.g. createdDateTime). This way you can also add system fields. In AX 2012 you can also set the "Dynamic" property of the field node of the query datasource to "Yes", this will automatically add all fields including the system fields.

Was this reply helpful? Yes No
Tahir Baashar 20 on at

Like (0)

Report

RE: "createdDateTime" field doesn't exist in the "InventTable" of AOT

having the same issue create date and time is not showing, but i added "Balance + journal" and i follow your steps and started to show amount to table grids. .. thanks

Was this reply helpful? Yes No