How to override the lookup in D365

 When we Need To Override A Lookup Form?


-> I have a form named DeptForm.


-> In this form I have a data source called Departments having two fields(Dept_Id,Dept_Name).


->I would like to filter the lookup of the Dept_Id to ensure it only shows Emp_Name relating to the Dept_Name the user has already entered.


// Here is the code


[Form]

public class DeptForm extends FormRun

{



    [DataSource]

    class Departments

    {

        [DataField]

        class Dept_Id 

        {

            /// <summary>

            ///

            /// </summary>

            /// <param name = "_formControl"></param>

            /// <param name = "_filterStr"></param>

            public void lookup(FormControl _formControl, str _filterStr)

            {

                SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(Employees), _formControl);


                //Create a new query

                Query                   query = new Query();

                QueryBuildDataSource    queryBuildDataSource;

                QueryBuildRange         queryBuildRange;


                //Specify the name of the table the lookup should show data from.


                queryBuildDataSource = query.addDataSource(tableNum(Employees)); // it will show data from this employees table


                //Filter the data on the Dept_Name field on the Employees table. // it will filter the data based on the dept_name we select 


                queryBuildRange = queryBuildDataSource.addRange(fieldNum(Employees,Dept_Name));


                //Only show records where the Dept_Name field matches the value in


                //Departments.MakeId, on the currently selected record.


                queryBuildRange.value(queryValue(Departments.Dept_Name));


                //Specify which fields should be shown  in the lookup form.


                //  field returned is the first field referenced


                sysTableLookup.addLookupfield(fieldNum(Employees,Emp_Name));


                sysTableLookup.addLookupfield(fieldNum(Employees,Dept_Name));

               

 

                sysTableLookup.parmQuery(query);


                sysTableLookup.performFormLookup();


            }


        }


    }


} 

Comments

Post a Comment

Popular posts from this blog

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

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

X++ code to CREATE AND POST A TRADE AGREEMENT IN MICROSOFT DYNAMICS 365 in D365 F & O

Reuirement : I have to create a table called BASTradeAgreementTable with fields like following Item number Product Name ToDate FromDate InventSiteId InventLocationId Amount From Unit Step2: After Creating Table I have to create a form and add the created table into the form datasource and add all the fields of that datasource to form grid. I have to create a button called Post whenever user clicks on that button i have to create and post Trade Agreement Journals with the data provided in the form grid. [Control("Button")]     class Post     {         /// <summary>         ///         /// </summary>         public void clicked()         {             int             recordsCount;              BASTradeAgreementTable    tradeAgreement;     ...
Read more