Lookup in UI Builder Class with multiple Tbales D365fox++

 public void lookupVendorID_New(FormStringControl _control)

    {

        PurchTable                      purchtable;

        PurchLine                       purchline;

        VendInvoiceJour                 vendInvoiceJour;

        GeneralJournalEntry             GeneralJournalEntry ;

        GeneralJournalAccountEntry      GeneralJournalAccountEntry;

        VendTable                       vendtable;

        Query                           query;

        QueryBuildDataSource            qbds;

        QueryBuildRange                 qbr;

        SysTableLookup                  systablelookup;

        SalesTable                      salesTable;


        query = new Query();

        qbds = query.addDataSource(tableNum(vendtable));



        //New Lookup

        sysTableLookup = SysTableLookUp::newParameters(tableNum(vendtable), _control);

        sysTableLookup.addLookupfield(fieldNum(vendtable, AccountNum));


            while 

            select ACCOUNTNUM

            from VENDTABLE


            join purchtable

            where purchtable.ORDERACCOUNT == VENDTABLE.ACCOUNTNUM

            && purchtable.DATAAREAID == VENDTABLE.DATAAREAID


            join vendinvoicejour

            where vendinvoicejour.PurchId == purchtable.PurchId


            join GeneralJournalEntry

            where GeneralJournalEntry.SubledgerVoucher == vendInvoiceJour.LedgerVoucher


            join GeneralJournalAccountEntry

                

            group by VENDTABLE.ACCOUNTNUM

            where GeneralJournalAccountEntry.GeneralJournalEntry == GeneralJournalEntry.RecId


            && (GeneralJournalAccountEntry.PostingType == LedgerPostingType::PurchAdvance || GeneralJournalAccountEntry.PostingType == LedgerPostingType::PurchAdvanceApplication)

            && VENDTABLE.DATAAREAID == curExt()

            {

                qbr = qbds.addRange(fieldNum(vendtable, AccountNum));

                qbr.value(VENDTABLE.ACCOUNTNUM);

            }


            if(!VENDTABLE)

            {

                qbr = qbds.addRange(fieldNum(vendtable, AccountNum));

                qbr.value("--Don't Remove Filter--");

            }


            qbr.status(RangeStatus::Hidden);



        systablelookup.parmUseLookupValue(false);

        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();

    }

Comments

Post a Comment

Popular posts from this blog

Get Current Worker data in d365 fo x++

  In Dynamics 365 F&O, we have HcmWorkerHelper class which gives much information about worker such as department, primary position, current legal entity and so on. The code to get worker’s current position. This gives current worker record. HcmWorkerRecId hcmWorkerRecId = HcmWorker::userId2Worker(curUserId()); HcmPositionRecId hcmPositionRecId = HcmWorkerHelper::getPrimaryPosition(hcmWorkerRecId); The code to get current worker manager. HcmWorker currentWorker = HcmWorker::find(HcmWorkerLookup::currentWorker()); HcmWorker currentWorkerManager = HcmWorkerHelper::getManagerForWorker(currentWorker.RecId); The code to get current worker department. HcmWorker currentWorker = HcmWorker::find(HcmWorkerLookup::currentWorker()); OMOperatingUnit department = HcmWorkerHelper::getPrimaryDepartment(currentWorker.RecId); The code to get current worker legal entity. HcmWorker currentWorker = HcmWorker::find(HcmWorkerLookup::currentWorker()); CompanyInfo legalEntity = HcmWorkerHelper::getL...
Read more

Table Level Event Handler in d365 fo x++

[DataEventHandler(tableStr(PurchAgreementHeader), DataEventType::ModifiedField)] public static void PurchAgreementHeader_onModifiedField(Common sender, DataEventArgs e) { ModifyFieldEventArgs    event = e as DataEventArgs; PurchAgreementHeader    purchAgreementHeader = sender as PurchAgreementHeader; FieldId                 fieldId = event.parmFieldId(); date                    emptyDate; switch(fieldId) { case fieldNum(PurchAgreementHeader, BankGuarantee): if(purchAgreementHeader.BankGuarantee == NoYes::No) { purchAgreementHeader.BankGuaranteeExpirationDate = emptyDate ; purchAgreementHeader.BankGuaranteeNumber         = “”; purchAgreementHeader.Bank                         = “”; } break; } }   OnInserting - This method will be called during insertion of the record on the table. [DataEvent...
Read more