How to add custom lookup (Multi tables)in Dynamics AX 2012 Through X++

-

 

How to add custom lookup (Multi tables)in Dynamics AX 2012 Through X++

public static void lookupInvoice(FormControl _formControl, str _filterStr)
{
    Query                                       query                               = new Query();
    QueryBuildDataSource            qbds;
    QueryBuildDataSource            qbds_HcmWorker;
    QueryBuildDataSource            qbds_DirPerson;
    SysMultiTableLookup             SysMultiTableLookup;

    qbds                                = query.addDataSource(tableNum(CustInvoiceJour));
    qbds_HcmWorker          = qbds.addDataSource(tableNum(HcmWorker));
    qbds_HcmWorker.joinMode(JoinMode::InnerJoin);
    qbds_HcmWorker.addLink(fieldNum(CustInvoiceJour, WorkerSalesTaker), fieldNum(HcmWorker, RecId));
    qbds_DirPerson          = qbds_HcmWorker.addDataSource(tableNum(DirPerson));
    qbds_DirPerson.joinMode(JoinMode::InnerJoin);
    qbds_DirPerson.addLink(fieldNum(HcmWorker, Person), fieldNum(DirPerson, RecId));


    SysMultiTableLookup = SysMultiTableLookup::newParameters(_formControl, query);
        
    SysMultiTableLookup.addLookupField(fieldNum(CustInvoiceJour, InvoiceId));
    SysMultiTableLookup.addLookupField(fieldNum(CustInvoiceJour, InvoiceAccount));
    SysMultiTableLookup.addLookupField(fieldNum(CustInvoiceJour, SalesId));
    SysMultiTableLookup.addLookupField(fieldNum(CustInvoiceJour, InvoiceDate));
    SysMultiTableLookup.addLookupField(fieldNum(CustInvoiceJour, OrderAccount));
    SysMultiTableLookup.addLookupField(fieldNum(DirPerson,Name),3,false,"Second salesman");
    SysMultiTableLookup.performFormLookup();
}

Comments

Post a Comment

Popular posts from this blog

How to loop through enum in dynamics ax 2012 using x++

-
    Method 1:     SysDictEnum                 sysDictEnum = new SysDictEnum(enumnum(InventTransType));     InventTransType             currentElement;              currentElement= sysDictEnum.firstValue();     do     {         info(strFmt("%1",currentElement));                  currentElement= sysDictEnum.nextValue(currentElement);              } while (currentElement != sysDictEnum.firstValue()); Method 2:     SysDictEnum                 sysDictEnum = new SysDictEnum(enumnum(InventTransType));     InventTransType             currentElement;     int                         iLoop;              for (iLoop=0 ; iLoop < SysDictEnum.values(); iLoop++)     {         info(SysDictEnum.index2Label(iLoop));     }
Read more

How to read from csv file in Dynamics AX 2012 Through X++

-
How to read from csv file in Dynamics AX 2012 Through X++ static void readFromCSV(Args _args) {     #File     CommaTextIO          csvFile;     container                   readCon;     Dialog                       dialog;     DialogField               dfFileName;     FileName                  fileName;     int                              row;     CustAccount            custAccount;     ItemId                      itemId;     Qty                           qty;     dialog = new Dialog("Read data from csv file");     dfFileName = dialog.addField(extendedTypeStr("FilenameOpen"));     dialog.filenameLookupFilter(['csv','*.csv']);     if (dialog.run())     {         csvFile = new CommaTextIo(dfFileName.value(), 'r');         csvFile.inFieldDelimiter(',');         readCon = csvFile.read();         ttsBegin;         while(csvFile.status() == IO_Status::OK)         {             readCon = csvFile.read();    
Read more

How to Create Transfer Journal in Dynamics AX 2012 Through X++

-
How to Create Transfer Journal in Dynamics AX 2012 Through X++ static void createTransfer(Args _args) {     InventJournalTable              inventJournalTable;     InventJournalNameId          inventJournalName   = 'Journal Name';     InventJournalTrans              inventJournalTrans;     InventDim                            inventDim_From,inventDim_To;     InventJournalCheckPost      journalCheckPost;     //header     inventJournalTable.clear();     inventJournalTable.JournalType  = InventJournalType::Transfer;     inventJournalTable.initFromInventJournalName(InventJournalName::find(inventJournalName));     inventJournalTable.insert();     //lines     inventDim_From.clear();     inventDim_From.InventLocationId     = '01';     inventDim_From.modifiedField(fieldNum(InventDim,InventLocationId));     inventDim_From                      = InventDim::findOrCreate(inventDim_From);     inventDim_To.clear();     inventDim_To.InventLocationId  = '02
Read more