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
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
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.
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (