50
Hi,
I wonder if it's possible to generate a list of mandatory fields in AX 2009? For example the mandatory fields when creating a customer.
Can you export this type of data from AX to Excel? It would help me a lot when doing migration since then I know what fields I must have.
*This post is locked for comments
Yes, inside AOT inside AX. But this is part of code what you're should write.
You're should complete the code with export to Excel function with all tables list from AOT.
Hi Rustem,
Thank you for quick response. Your suggestion sounds great but I'm not sure how to generate the list with this code.
Do I do it while I'm inside the AOT inside AX?
Regards
Rikard
Hi Rikard Ekengren!
To get the all mandatory fields from particular table you should use DictTable and DictField classes. For example:
Share
Report
All responses (
Answers (
static void CheckMandatoryFieldsOnTable(Args _args)
{
DictTable dictTable;
DictField dictField;
int i;
TableId tableId = tableNum(CustTable);
;
dictTable = new DictTable(tableId);
for (i=1 ; i <= dictTable.fieldCnt(); i++)
{
dictField = new DictField(tableId, dictTable.fieldCnt2Id(i));
if (dictField.mandatory())
{
info(dictField.name());
}
}
}
But the tables not only the place where mandatory fields can be determine. You can set mandatory property to controls on a form.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156