How to get all the planned orders for a particular demand. in Ax2012

When we create a sales order in Ax. Basically we are creating demand in system and when we run scheduling in system it generates the planned production or purchase orders.

Following is the step by step process.

·         Create sales order. And check the explosion from salesline->Product and supply. Initially there are no planned orders. So there is no record in explosion.

·         Check the explosion from salesline

·         Now run the planning from Master planning ->Periodic->Master scheduling

·         Check the explosion from sales line

·         If we want to get all the planned production orders detail we can get it through following x++ code. We can get top level planned order from REqPo table where on the basis of pegging reference of sales order we can find top level planned production order. We can use that planned order as a parameter in a method and retrieve all the lower level orders.

private void doUpdateReferences(reqPo   _reqPo)

{

    ReqTransExplode         reqTransExplode;

    Map                     mapReqTransLocal;

    MapEnumerator           enumerator;

    container               conMapReqTrans;

    Map                     mapReqTrans;

    reqTrans                reqTrans;

    ReqPO                   reqPo = _reqPo;

    Map                     plannedOrderMap = new Map(Types::Int64, Types::Record);

   

    ;

    while (reqPo)

    {

        if (!plannedOrderMap.exists(reqPo.RecId) )

        {

           reqTransExplode = reqTransExplode::newReqTrans(reqPo.reqTrans(),ReqExplodeType::Down,true);

           reqTransExplode.run();

            conMapReqTrans = reqTransExplode.packMapReqTrans();

mapReqTransLocal    = (conMapReqTrans)  ? Map::create(conMapReqTrans) : new    Map(typeName2Type(extendedtypestr(recId)), Types::Record);

            mapReqTrans = new Map(typeName2Type(extendedtypestr(recId)), Types::Record);

            enumerator = mapReqTransLocal.getEnumerator();

            while(enumerator.moveNext())

            {

                reqTrans = reqTrans::findRecIdCrossCompany(enumerator.currentKey());

                if (reqTrans.RefType == ReqRefType::BOMPlannedOrder)

                {

                    Info(reqtrans.reqpo().refid);

                }

            }

        }

        next reqPo;

    }

}

RPC Server Is Unavailable.

Yesterday I was working on Ax reports. And suddenly a message occured .
RPC server is unavailable when I was trying to open report even AOT.

Then I found "Print Spooler" service was stoped. So I started that service and My ax application was working fine.

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++;
}

}