Microsoft_MVP_banner

Show methods in AX lookups

This sample code is used to show Customer Name in lookup, In AX 2009 we had name field in CustTable but now its moved to DirPartyTable. We still have name() in CustTable which we can use to display name in lookups.


AX 2009
client static void lookupInterCompanyItemId(FormStringControl  
lookupCtrl, DataAreaId _dataAreaId = “”)
{
    SysTableLookup          sysTableLookup =
SysTableLookup::newParameters(tablenum(InventTable), lookupCtrl);
    Query                   query = new Query();
    QueryBuildDataSource    qbds =
query.addDataSource(tablenum(InventTable));
    ;
   
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemId));
   
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemName));
   
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemGroupId));
   
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemType));
    if(_dataAreaId)
        qbds.company(_dataAreaId);
    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();

}
AX 2012
 client static void lookupInterCompanyItemId(FormStringControl  
lookupCtrl, DataAreaId _dataAreaId = “”)
{
    SysTableLookup          sysTableLookup =
SysTableLookup::newParameters(tablenum(InventTable), lookupCtrl);
    Query                   query = new Query();
    QueryBuildDataSource    qbds =
query.addDataSource(tablenum(InventTable));
    ;
   
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemId));
    sysTableLookup.addLookupfield(fieldnum(InventTable, NameAlias));
   
sysTableLookup.addLookupMethod(tableMethodStr(InventTable,itemGroupId));
   
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemType));
    if(_dataAreaId)
        qbds.company(_dataAreaId);
    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();
}

Share:

Send Us A Message

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Post

From Digitization to Intelligence: The Era of AI Agents

From Digitization to Intelligence: The Era of AI Agents

Faisal Fareed AI | AI Agents
Read more
AI Agents in Microsoft Business Applications: Dynamics 365 F&O, Business Central, CE & Power Platform

AI Agents in Microsoft Business Applications: Dynamics 365 F&O, Business Central, CE & Power Platform

Faisal Fareed AI | Business Applications
Read more
Exploring Microsoft Copilot Architecture

Exploring Microsoft Copilot Architecture

Faisal Fareed AI | Microsoft Copilot | News
Read more

FaisalFareed@2025. All rights reserved

Design by T3chDesigns

Linkedin