How to use delegate in Microsoft Dynamics AX 2012

Click here for delegate in Microsoft Dynamics AX 2012

How to use pre or post Event Handler in Microsoft Dynamics AX 2012

Click here to know about How to use pre or post Event Handler in Microsoft Dynamics AX 2012

How to Create EDT relation in AX 2012

setp 1. First create New Edit.

setp 2.Create New Table Name is "TestParent" Table

then drag and drop the newly created Edt in "TestParent" Table

setp 3.Create Index for new created EDT in "TestParent" Table

the properties on index is AllowDuplicates to No and Alternativekey to Yes

setp 4.then select the "TestParent" Table and right click on it select properties sheet set the "primary index" property i.e the newly created index

setp 5.Then go to EDT and right click on it ,select property sheet then go to "Reference Table" property Set it to "TestParent" Table Name

setp 6.Create a Second Table i.e child Table

setp 7.Then Drag and drop the EDT

then it will prompt the one dialog box

in that dialog box click Yes button then lookup will created on that field.

Happy Daxing... :-)

Cannot execute a data definition language command on (). The SQL database has issued an error. ion AX 2009 force to DB synchronize

Use the below job to to find out the tables for synchronize errors

static void DB_Synchronize_force(Args _args)
{
Dictionary dict;
int idx, lastIdx, totalTables;
TableId tableId;
Application application;
SysOperationProgress progress;
StackBase errorStack;
ErrorTxt errorTxt;
;

application = new Application();
dict = new Dictionary();
totalTables = dict.tableCnt();
progress = new SysOperationProgress();
progress.setTotal(totalTables);
progress.setCaption("@SYS90206");
errorStack = new StackBase(Types::String);

lastIdx = 0;
try
{
for (idx = lastIdx+1; idx <= totalTables; idx++)
{
tableId = dict.tableCnt2Id(idx);
progress.setText(dict.tableName(tableId));

lastIdx = idx;
application.dbSynchronize(tableId, false, true, false);
progress.incCount();
}
}
catch (Exception::Error)
{
errorTxt = strFmt("Error in table '%1' (%2)", tableId, dict.tableName(tableId));
errorStack.push(errorTxt);
retry;
}

setPrefix("@SYS86407");
errorTxt = errorStack.pop();
while (errorTxt)
{
error(errorTxt);
errorTxt = errorStack.pop();
}
}