Announcements
Hi all,
Can you please let me know I wants to get the new fields which is added in standard table in AX 2012 R3.
Could please send me the sample code to get the list of table with new fields. That I need to send to customer.
Please give me more shed on this.
Thanks!
What exactly do you want?
1) List of new fields added in (one) standard table
2) List of tables that have new fields
And what kind of list does your customer want? Can you share some example of how that list would look like? That's a good starting point for your technical design.
- One option is to run Code upgrade tool in LCS, it gives you a report that lists your customizations.
- Another one is to create AOT project from model in Developer workspace (Tools - Code upgrade - Create project from model), or create new AOT project that contains all table changes on a given layer.
These options would require no development at all.
Thanks Nikoloas,
Let me explain
1. CustTable -- suppose we have added 5 new fields
2. Vend Table - suppose we have added 2 new fields .
So, I need
5 new fields from Cust table and 2 new fields from Vend table.
Like other tables also...
This is my requirements
Please give me more shed on this
Hi Nikoloas,
2nd option - List of tables that have new fields.
Thanks for the clarification.
I don't have a 100% ready code for you, but found this with a quick web search:
1) List tables: dynamicsuser.net/.../how-to-get-list-oftables-table-group-main-tables-in-x
2) List fields in a table: community.dynamics.com/.../1045059
Once you understand those examples, you can apply that understanding and and iterate all tables that exist on custom layer, and then list all fields that exist on that custom layer.
Thanks Nikolas,
The 2nd option "list fields in table " is openings my forum only.
Sorry, here's the correct link: community.dynamics.com/.../ax-2012-loop-through-all-the-fields-of-a-table-in-x
Suppose if they have added new fields in CUS or VAR layer in CustTable .
Then in the above link can I add code for layer?? (Like cus or var)
So, it will return only those columns based on layer not all.
Kindly suggest anyone please
Here's one more blog that shows how to find elements by layer: community.dynamics.com/.../x-cross-reference-for-extended-data-types-1618632832
Hi @rp@n,
There are also system tables called UtilElements and UtilIDElements which can give the information of fields and the layer.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 612
André Arnaud de Cal... 592 Super User 2026 Season 1
Abhilash Warrier 586 Super User 2026 Season 1
