Friday, July 10, 2015

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();
}

2 comments:

  1. QUICK EASY EMERGENCY URGENT LOANS LOAN OFFER EVERYONE APPLY NOW +918929509036 financialserviceoffer876@gmail.com Dr. James Eric

    ReplyDelete

I will appreciate your comments !

How to enable new Microsoft teams - Public Preview!

New Microsoft Teams is just AWESOME, quick but useful post below shows how you have this preview feature to make your life EASY!  Open Micr...