X++ code to filter a lookup field on form in ax2012

lookup for custaccount field, when open the custtable (custaccount field)  form

public void lookup()
{
Query query = new Query();
QueryBuildDataSource qbds_CustTable;
SysTableLookup sysTableLookup;
QueryBuildRange qbr;
//super();
sysTableLookup = SysTableLookup::newParameters(tablenum(CustTable), this);
qbds_CustTable = query.addDataSource(tableNum(CustTable));
sysTableLookup.addLookupfield(fieldnum(CustTable, AccountNum), true);
sysTableLookup.addLookupfield(fieldnum(CustTable, CustGroup),true);
qbr = qbds_CustTable.addRange(fieldNum(CustTable,CustGroup));
qbr.value(‘ENDUSER’);
sysTableLookup.parmUseLookupValue(false);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
About these ads

Comments

  1. UnknownMarch 11, 2016 at 6:53 AM

    where should i write this code?

    ReplyDelete
  2. RajkumarAugust 14, 2017 at 10:03 PM

    lookup method not calling.i have add the script in Budget register entry for Budget code.but my code is not calling.

    ReplyDelete

Post a Comment

Popular posts from this blog

Understanding the Product structure:

In this post, I would like to share some Product information in Ax 2012  that will help to understand  Inventory structure . In AX 2012 Inventory structure has been completely changed. So in brief  we can understand the same as: Understanding the Product structure: Product type    Item type - This option will be selected if the product is an inventoried product        Service type - This option will be selected if the product is a non-inventoried product Product sub type                   Product master -   Products of this sub-type must have a product dimension group that          specifies the product dimensions that are active for the product (color, size, and configuration) o      Configuration technology §    Predefined variant - This type should be chosen if the product will not be   configured, b...
Read more

D365 – Data Entity Method Call Sequence

Image
  1. initValue 2. validateField 3. validateWrite 4. update 4.1. doUpdate 4.1.1. persistEntity 4.1.1.1. doPersistEntity 4.1.1.1.1. initializeDataSources 4.1.1.1.1.1. initializeEntityDataSource Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.2. mapEntityToDataSources Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.3. saveDataSources 4.1.1.1.3.1. updateEntityDataSource 4.1.1.1.4. mapEntityToDataSource (maybe for another record) 4.1.1.1.5. saveDataSources 4.1.1.1.5.1. updateEntityDataSource for update operation and (insertEntityDataSource for insert) 4.1.1.1.5.1.1. mapDataSourceToEntity 4.1.1.1.5.1.2. doSaveDataSource 4.1.1.1.5.1.2.1. updateDataSource 4.1.1.1.5.1.2.1.1. preupInsertDataSource 4.1.1.1.5.1.2.1.1.1. validateWrite of table Plus: postLoad This method is called during the export for setting the value to unmapped fields after entity is downloaded to datasource. EXPORT:        Entity- postLoad...
Read more

Dynamics Ax 2012 Interview Questions:

Interview Questions: 1.       Difference between following condel   :- Use condel to delete one or more items from a container. confind :- Use confind to locate a sequence of items in a container.  conins   :- Use conins to insert some items into a container. conlen   :- Use conlen to find out how many items there are in a container. connull  :- Use connull to explicitly dispose of the contents of a container. conpeek :- Use conpeek to extract an item from a container, and to convert it into another data type   conpoke :- Use conpoke to replace (poke) an item in a container. 2.       Difference between edit and display method Display  Indicates that the method's return value is to be displayed on a form or a report. The value cannot be altered in the form or report Edit  Indicates that the method's return type is to be used to provide information for ...
Read more