Lookup in form level

/// <summary>



 /// Lookup for admin to select data projects of type import in DMF parameters form for users to use during quote import

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

[FormControlEventHandler(formControlStr(DMFParameters, KGSPP_DMFDefinitionGroup), FormControlEventType::Lookup)]

public static void KGSPP_DMFDefinitionGroup_OnLookup(FormControl sender, FormControlEventArgs e)



{

 SysTableLookup tableLookup;

Query query = new Query();

tableLookup = SysTableLookup::newParameters(tableNum(DMFDefinitionGroup), sender);

tableLookup.addLookupfield(fieldNum(DMFDefinitionGroup, DefinitionGroupName), true);

tableLookup.addLookupfield(fieldNum(DMFDefinitionGroup, OperationType));

QueryBuildDataSource qbds = query.addDataSource(tableNum(DMFDefinitionGroup));

qbds.addRange(fieldNum(DMFDefinitionGroup, OperationType)).value(queryValue(DMFOperationType::Import));



tableLookup.parmQuery(query);

tableLookup.performFormLookup();

}

Comments

Post a Comment

Popular posts from this blog

Event handlers and post handlers in D365

Event handlers and post handlers in D365 Shankar Das  Shankar Das     on 23 Mar 2018 2:03 PM  Let’s discuss today, how to get the table buffers, form control values, class parameters and method arguments etc., while writing our own event-handlers in D365. I’ll elaborate this using example code snippets in this post. There are already very useful posts on this topic you can look into. Here I required these event handlers while doing customization in Item master. Form data source event handler  [FormDataSourceEventHandler(formDataSourceStr(EcoResProductDetailsExtended, InventTable), FormDataSourceEventType::Written)] public static void InventTable_OnWritten(FormDataSource sender, FormDataSourceEventArgs e){     FormRun                 form           = sender.formRun();     FormDataSour...
Read more

Magento Integration Specification ERP Trade Agreement - Product Pricing & Discounts Extract

Magento Integration Specification ERP Trade Agreement - Product Pricing & Discounts Extract: Main table pricediscadmtrans, need to add NoYesId field. And write the code by taking extension of the table for Insert and Update methods  [ExtensionOf(tableStr(PriceDiscAdmTrans))] final class KGSPMIPriceDiscAdmTrans_Extension {     public void  insert()     {         this.KGSPMIIsProcessed  = NoYes::No;         next insert();                 }     public void update()     {         this.KGSPMIIsProcessed  = NoYes::No;         next update();       } } -------------------------------------- For reset for the pricediscadmtrans table of which added field of...
Read more

How to Extend Sales Order Update Functionality to Custom Fields in D365 Finance and Operations

Image
How to Extend Sales Order Update Functionality to Custom Fields in D365 Finance and Operations by Bill Thompson | Feb 6, 2019 | Dynamics 365 for Finance and Operations , Dynamics AX My colleague Jeremy Dobler wrote this nice article on how to extend sales order update functionality to custom fields in AX 2012 . In this post, I’m going to show how to implement sales order update functionality to custom fields in Dynamics 365 Finance and Operations, and what changes are necessary when comparing to Dynamics AX. Sales Order Update Functionality D365 Finance and Operations vs. Dynamics AX New Fields Jeremy’s article states the following: “Once you have added the fields to the SalesTable and the SalesLine table and exposed the fields on the SalesTable form, add the new custom field to the HeaderToLineUpdate field group on the SalesTable Table.” In D365FO, the new fields will need to be added via a table exten...
Read more