Dynamics AX 2012

This is very simple tip. That usually found that when we move record to record in list page, from top Action pane button enable or disable as result of this movement.  This functionality required one of my customization from.

For example, I have to enable and disable button on action pane “BtnGenerateLine”  based on status / enum field of table.

Step 1, right click on button and its set its auto declaration property to true.

Now right click on Data Source of form which bind to grid and overwrite SelectionChanged Method

So Code snippet will be something like

public void selectionChanged()

{

super();

if (CustTabletmp.StatusProcessed == StatusProcessed::LineProcessed)

{

BtnGenerateLines.enabled(false);

}

else

{

BtnGenerateLines.enabled(true);

}

}

During development we have to create custom inquiry forms. Or Form where we can  search and filter records on different criteria.

Consider a scenario, where we have to build custom inquiry form for all saleline. In this inquiry or custom list form, we can filter on records on date, customer and amount or discount.

Lets do this,

Create a form with name custom Sales

From expend its designs and right click on design to open its property window

From property window set its design style to simplelist

Now add new data source on form, and sets create and edit property to no, Because we did not want to insert , update and delete operation  on this form.

Now drag and drop following fields form  data source to grid.

ItemId,CustNumber,SalesQty,SalesPrice,

Now right click on grid and set its datasource to salesline.

Now run the form its look like similar

Now above grid, add  group control and set its column property to 2, also set its visible property to true.

Add String Edit control, and button here.

Right click on String Edit control and set its auto delecaration to true, so we can access this control in x++. Set its name as “txtCustomerNum”. And set its lookup property to always.

Now we are going to create Unbound control with lookup,

Right lock on methods under stringEditcontrol and add lookup method.

Add following code to fill the lookup to customer and Name which belongs to current legal entity.

public void lookup()

{

Query query = new Query();

QueryBuildDataSource queryBuildDataSource, qbds, dsView;

QueryBuildRange queryBuildRange;

 

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(CustTable), this);

 

sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));

sysTableLookup.addLookupField(fieldNum(CustTable, Party), false);

 

queryBuildDataSource = query.addDataSource(tableNum(CustTable));

 

qbds = queryBuildDataSource.addDataSource(tableNum(DirPartyTable));

qbds.joinMode(JoinMode::InnerJoin);

qbds.addLink(fieldNum(CustTable, Party), fieldNum(DirPartyTable, RecId));

 

dsView = qbds.addDataSource(tableNum(DirPartyPostalAddressView));

dsView.joinMode(JoinMode::InnerJoin);

dsView.addLink(fieldNum(DirPartyTable, RecId), fieldNum(DirPartyPostalAddressView, Party));

 

 

sysTableLookup.parmQuery(query);

 

sysTableLookup.performFormLookup();

 

 

}

Now run the form lets see the how behave the lookup control.

Man its working. Now check that selected value from this textbox is accessible, then we move to filter the records

Add Click event/ method on button we just added with this string edit button.

And right following code.

void clicked()

{

super();

info(  txtCustomerNumber.text());

}

 

Now run the form, select customer and click on button.

Now right click on Salesline datasource and over rights its execute Query method.

And add following lines to filter it.

public void executeQuery()

{

QueryBuildRange QcustomerFilter;

QcustomerFilter = SysQuery::findOrCreateRange(SalesLine_q.datasourceTable(tableNum(SalesLine)),fieldNum(SalesLine,CustAccount));

if (txtCustomerNumber.text()!=””)

{

QcustomerFilter.value(queryValue(txtCustomerNumber.text()));

 

}

else

{

QcustomerFilter.value(SysQuery::valueUnlimited());

}

super();

}

 

In button click even add this line code

void clicked()

{

super();

SalesLine_ds.executeQuery();

 

}

Now run the form, select the customer and click on button, you will find the filter records on form

In next post will add more filters to this form.

In dynamics if form is created by listpage template, it would not let you write any code on form level.

Best practices says that you have to wrote code in extended interaction classes. But what if we have to write simple method at form levels, For such cases  you can write events or method like modified or clicked on controls.

You can write method or event of button or control by changing “DisplayTarget” property to “Client”.