Lookup Event handler in d365

 [FormControlEventHandler(formControlStr(EcoResProductDetailsExtended, CST_MixNMatch_CST_MixMatchRevItemId), FormControlEventType::Lookup)]

    public static void CST_MixNMatch_CST_MixMatchRevItemId_OnLookup(FormControl sender, FormControlEventArgs e)

    {

        SysTableLookup      sysTableLookup  = SysTableLookup::newParameters(tableNum(InventTable), sender);

        InventTable inventTable;


        Query query = new Query();

        QueryBuildDataSource qbds;

        QueryBuildRange queryBuildRange;

        FormDataSource  formDataSource = sender.dataSourceObject();

        InventParameters inventParameters = formDataSource.cursor();


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

        qbds.addRange(fieldNum(InventTable, CST_MixNMatch)).value(queryValue(NoYes::Yes));


        sysTableLookup.parmQuery(query);

        sysTableLookup.addLookupfield(fieldNum(InventTable, ItemId));

        sysTableLookup.performFormLookup();


        FormControlCancelableSuperEventArgs cancelSuperEventArgs = e as FormControlCancelableSuperEventArgs;

        cancelSuperEventArgs.cancelSupercall();

    }


// lookup should come if the cst_flavours is yes

 [FormControlEventHandler(formControlStr(EcoResProductDetailsExtended, CST_MixNMatch_CST_MixMatchRevItemId), FormControlEventType::Lookup)]

    public static void CST_MixNMatch_CST_MixMatchRevItemId_OnLookup(FormControl sender, FormControlEventArgs e)

    {

        FormDataSource  formDataSource_ds = sender.formRun().dataSource();

        InventTable     inventTable = formDataSource_ds.cursor();


        if(inventTable.CST_Flavours == NoYes::Yes)

        {

            SysTableLookup      sysTableLookup  = SysTableLookup::newParameters(tableNum(InventTable), sender);

            Query query = new Query();

            QueryBuildDataSource qbds;

            QueryBuildRange queryBuildRange;

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

            qbds.addRange(fieldNum(InventTable, CST_MixNMatch)).value(queryValue(NoYes::Yes));

            sysTableLookup.parmQuery(query);

            sysTableLookup.addLookupfield(fieldNum(InventTable, ItemId));

            sysTableLookup.performFormLookup();

            FormControlCancelableSuperEventArgs cancelSuperEventArgs = e as FormControlCancelableSuperEventArgs;

            cancelSuperEventArgs.cancelSupercall();

        }

    }

    

Comments

Post a Comment

Popular posts from this blog

how to post trade agreement journals automatically using x++ code

  In Microsoft Dynamics AX, you can post trade agreement journals automatically using X++ code. Here are the steps to do so: Create a new job in X++. Write a code to fetch data from the trade agreement table. Create a journal header and journal lines based on the fetched data. Call the post() method of the journal header to post the journal. Repeat steps 2 to 4 for each trade agreement. Here's a sample code in X++: static void postTradeAgreementJournals(Args _args) { TradeAgreementTable tradeAgreementTable; GeneralJournalHeader generalJournalHeader; GeneralJournalLine generalJournalLine; // Fetch data from the Trade Agreement table select tradeAgreementTable where tradeAgreementTable.JournalPosting == NoYes::No; // Loop through each trade agreement while (tradeAgreementTable) { // Create a journal header generalJournalHeader = new GeneralJournalHeader(); generalJournalHeader.initValue(); generalJournalHeader.tra...
Read more

How to Create a wizard in x++ d365

Image
 step1: Create a form and apply form pattern as wizard step2 : create a class and extend the class with SysWizard. code :            class BAS_WIzardScreen extends SysWizard {     #MACROLIB.AviFiles     FormName formname()     {         return formstr(BAS_WIzardForm);  // name of the wizard form     }     public void run()     {         info(strFmt("Thankyou"));     }     public void setupNavigation()     {     }     public boolean validate()     {         return true;     }     public static str description()     {         return "BASOFA WIZARD";  // title of the wizard     }     public static void main(Args _args)     {         BAS_WIzardScreen wizard = new BAS_WIz...
Read more

x++ code to submit and approve and reject the invent movement workflow in d365 F&O

 class Class1 {     public  void submitworkflow()     {         InventJournalTable journalTable;     WorkflowWorkItemTable   WorkflowWorkItemTable;    WorkflowVersionTable        workflowVersionTable;                journalTable = InventJournalTable::find('00446');               // submit to workflow         if (journalTable.WorkflowApprovalStatus == InventJournalWorkflowApprovalStatus::NotSubmitted)         {             Workflow::activateFromWorkflowType(workFlowTypeStr(InventJournalMovementTemplate), journalTable.RecId,                                     'Workflow submitted by button', false, Curuserid());         }    ...
Read more