By in group by is optional

public static void GroupBy(Args _args)
{
InventTable inventTable;
while select inventTable
group by itemGroupid
{
info(inventtTable.itemGroupId);
}
while select inventTable
group itemGroupId
{
info(inventTable.itemGroupId);
}

}

Here both will give same output. Really funny.

AX 2012 form templates and form best practices

Microsoft Dynamics AX 2012 form templates and form best practices

From the Amir's Nazim wordpress, we can see the new form templates

http://msdax.wordpress.com/2011/05/01/dynamics-ax-2012-form-templates-and-form-bp-checks/

Microsoft Dynamics AX 6.0 (2011) New X++ Editor

Hi All,

Here is new x++ editor for Ax 6.0

Microsoft Dynamics AX 6.0 (2011) New X++ Editor

AX 2012 - What’s New in Microsoft Dynamics AX 2012 for Developers

following link provides a summary of the developer features that will be implemented in Microsoft Dynamics AX 2012.

http://blogs.msdn.com/b/dynamics_ax_horizon/archive/2011/04/14/ax-2012-what-s-new-in-microsoft-dynamics-ax-2012-for-developers.aspx

How to identify unused labels in application

We often creates labels in our development environment and we not use the labels.Following is a job to identify unused labels in application .

Here my label file is IFC

static void I4C_UnusedLabels(Args _args)
{
str 50 labelId;
int i;
int maxLabel = 2000;
xRefNames names;
XRefReferences ref;

str info = "LabelId#LabelStr\n"
;

while (i <= maxLabel) {
labelId = "@IFC" + int2str(i);
// The particular label file.
select recid from names
where names.Name == labelid
exists join ref
where names.RecId == ref.xRefNameRecId;

if (! names.RecId)
{
info += strfmt("%1#%2\n", labelId,

SysLabel::labelId2String(labelId));
}

i++;
}

}