Want filter on display method on form in AX 2012

Here I want filter on ItemGroupName field of InventOnHandItem form

You need to write display method on form datasource and pass buffer as parameter.

display ItemGroupId itemGroupId(InventSum _inventSum)

{

   InventItemGroupItem inventItemGroup;

   select ItemGroupId from inventItemGroup 

            where inventItemGroup.ItemId  == _inventSum.ItemId

                && inventItemGroup.ItemDataAreaId == _inventSum.dataAreaId;

   return inventItemGroup.ItemGroupId;

}

display Name inventItemGroupName(InventSum _inventSum)

{

          return InventItemGroup::find(this.itemGroupId(_inventSum)).Name;

}

void context()

{

   int selectedMenu;

   real test;

   formrun fr;

   Args ag;

   Name strtext;

   querybuilddataSource qb1, qb2;

   queryrun qr;

   query q;

   PopupMenu menu = new PopupMenu(element.hWnd());

   int a = menu.insertItem('Find');

   int b = menu.insertItem('Filter');

   int c = menu.insertItem('Remove Filter');

   selectedMenu = menu.draw();

   switch (selectedMenu)

   {

       case -1:

           break;

       case a:

           ag = new args('SysformSearch');

           fr = new formrun(ag);

           fr.run();

           fr.wait();

           strtext = fr.design().controlName('FindEdit').valueStr();

           if(strtext)

           {

               q   = InventSum_ds.query();

               if ( ! q.dataSourceTable(tableNum(InventItemGroupItem)) )

               {

                   qb1 = q.dataSourceTable(tablenum(InventSum));

                   qb1 = qb1.addDataSource(TableNum(InventItemGroupItem));

                   qb1.relations( false );

                   qb1.addLink(FieldNum(InventSum,ItemId),FieldNum(InventItemGroupItem,ItemId));

                   qb1.addLink(FieldNum(InventSum,DataAreaId),FieldNum(InventItemGroupItem,ItemDataAreaId) );                            

                   qb1.joinMode(JoinMode::ExistsJoin);

                   qb2= qb1.addDataSource( tableNum( InventItemGroup) );

                   qb2.relations( false);

                   qb2.addLink( fieldNum(InventItemGroupItem, ItemGroupId), fieldNum(InventItemGroup, ItemGroupId));

                   qb2.joinMode(JoinMode::ExistsJoin);

                   qb2.addRange(FieldNum(InventItemGroup,name)).value(queryValue(strtext));

                   InventSum_ds.query(Q);

               }

               else

                   q.dataSourceTable(tableNum(InventItemGroup)).addRange(FieldNum(InventItemGroup,name)).value(queryValue(strtext));

               InventSum_ds.executeQuery();

           }

           break;

       case b:

               q   = InventSum_ds.query();

               if ( ! q.dataSourceTable(tableNum(InventItemGroupItem)) )

               {            

                   qb1 = q.dataSourceTable(tablenum(InventSum));

                   qb1 = qb1.addDataSource(TableNum(InventItemGroupItem));

                   qb1.relations( false );

                   qb1.addLink(FieldNum(InventSum,ItemId),FieldNum(InventItemGroupItem,ItemId));

                   qb1.addLink(FieldNum(InventSum,DataAreaId),FieldNum(InventItemGroupItem,ItemDataAreaId) );            

                   qb1.joinMode(JoinMode::ExistsJoin);

                   qb2= qb1.addDataSource( tableNum( InventItemGroup) );

                   qb2.relations( false);

                   qb2.addLink( fieldNum(InventItemGroupItem, ItemGroupId), fieldNum(InventItemGroup, ItemGroupId));

                   qb2.joinMode(JoinMode::ExistsJoin);

                   qb2.addRange(FieldNum(InventItemGroup,name)).value(queryValue(this.valueStr()));

                   InventSum_ds.query(Q);

               }

               else

                   q.dataSourceTable(tableNum(InventItemGroup)).addRange(FieldNum(InventItemGroup,name)).value(queryValue(this.valueStr()));                    

               InventSum_ds.executeQuery();

               break;

       case c :

           InventSum_DS.query().dataSourceTable(Tablenum(InventItemGroup)).clearRanges();

           InventSum_DS.executeQuery();            

           break;

       Default:

           break;

   }

}

Get CountryRegionId of company in ax 2012

ComapnyInfo        companyInfo;

companyInfo =  CompanyInfo::find();

companyInfo.postalAddress().CountryRegionId;

Find Duns number of customer in AX 2012 using X++.

DirOrganizationBase     dirOrganizationBase;
CustTable                        custTable;

custTable = CustTable::find("0001");

select firstonly DunsNumberRecId
                 from dirOrganizationBase
                    where dirOrganizationBase.RecId == custTable.Party;
     
 DirDunsNumber::find(dirOrganizationBase.DunsNumberRecId).DunsNumber;

Change the color of single column in AX 2012

Override the displayOption() method of the form's datasource 
to change appearance of any row in the grid. You can set either the 
foreground or the background color of the row.

public void displayOption(Common _record, FormRowDisplayOption _options)
{
   _options.backColor(WinApi::RGB2int(0,255,0)); 
} 

For highlighting one or more cells, override the 

To highlight one or more individual cells, use 
the ._options.affectedElementsByControl() method. 

public void displayOption(Common _record, FormRowDisplayOption _options)
{
  _options.backColor(WinApi::RGB2int(0,255,0));
  _options.affectedElementsByControl(Control1.id());
  _options.affectedElementsByControl(Control2.id());
} 

You can change multiple cells this way but you cant 
assign different colors to different cells. You have to use only one 
color for any of the cells in the row.

Find SID - AX 2012

1. Open Command Prompt.
2. Once Command Prompt is open, type the following command exactly as shown here, including spaces or lack thereof:

   wmic useraccount get name,sid

   and then press Enter. 

3. You should see a table, similar to the following, displayed in the Command Prompt window:

   Name            SID
   Admin           S-1-5-21-1180699209-877415012-3182924384-581
   Guest           S-1-5-21-1180699209-877415012-3182924384-604
   John            S-1-5-21-1180699209-877415012-3182924384-134

4. This is a list of each user account in Windows, listed by user name, followed by the account's corresponding SID.
   

Get Item purchase price in AX 2012 through code

container price ;

price = PriceDisc::findItemPriceAgreement(ModuleInventPurchSales::Purch, ItemId, InventDim,                 Unit, today(), Qty, VendAccountNum, CurrencyCode, "0");

purchPrice            = conPeek(price, 0);

Get Filepath and Filetype from Filename in ax 2012

str filePath;
str fileNameString;
str fileType;
     
         
[filePath, fileNameString, fileType]  =  fileNameSplit(fileName);