Ali Raza Zaidi

Dynamics 365 development notes

You are here: Home / Archives for X++

X++

Data Manipulation in Dynamics Ax 2012- Array as Extended Data Type

By

I found a array based field in TSTimesheetLineWeek table, Field TSWeeklyHours Now challenge is to enabled field based on Array. For example need to disabled on day 6. Following code snippet help me to enabled disabled fields generated on the base of array extended Type TSTimesheetLineWeek_ds.object(fieldId2Ext(fieldNum(TSTimesheetLineWeek, Hours), … [Read more...] about Data Manipulation in Dynamics Ax 2012- Array as Extended Data Type

Enum value to Table Insertion Dynamics Ax 2012 R3, D365 for operations

By

Let me share you a small tip, During customization We extend out of box Enum for classification. Later client requirement is extensive usage of new Values for classification. For adding new values in enum results dependency on technical person . So we did customization and provide form and custom table so he can create number of values as he want. But now next challenge was, … [Read more...] about Enum value to Table Insertion Dynamics Ax 2012 R3, D365 for operations

How to run RDP based report from X++ and passing parameter using Data contract.

By

Interesting, I was modifying some RDP based report, I found that parameter was passed to report through custom table, As report will run form button, and based on current selected record. So former developer did that on pressing button, selected value inserted some custom table. When report run, query on table and fetch required value form custom table and whole report logic … [Read more...] about How to run RDP based report from X++ and passing parameter using Data contract.

Unit Conversion Real world scenario, Dynamics Ax 2012 X++

By

A few days ago, I got requirement, where I have to sum up the total quantity and amount of all Purchase line. Here we assume that All lines in Purchase order belongs to same set or convertible unit. You can set these unit conversion settings at Organization administration > Setup > Units > Unit conversions.       Public void … [Read more...] about Unit Conversion Real world scenario, Dynamics Ax 2012 X++

Custom lookup in reference group Dynamics Ax 2012

By

Here is little tip regarding look up. A few days ago, I have to take join with employee with my custom table. if you check that The primary key of HCMWORKER IS RecId. So I have to create worker relation based on primary key i.e recid.\ But when I drop the foreign key on form Grid. It creates reference group. And surprising this create out of the box lookup with similar … [Read more...] about Custom lookup in reference group Dynamics Ax 2012

Try catch and finally in new Dynamics Ax (aka AX7)

By

Finally I found that in new Dynamics Ax finally statement introduce in exception handling statement. try { } catch { } finally { } It means, everything written in finally must be execute. For testing this functionality I just create a runnable class and written following code. class HelloWorld { /// <summary> /// Runs the class with the specified … [Read more...] about Try catch and finally in new Dynamics Ax (aka AX7)

Date in Advance filter Dynamics Ax 2012

By

Consider we are going to build a Inquiry form, where we are applying different filter criteria’s. One of them is date time filter. Consider this post is second part of one of my previous post. Where we created filter on Sales line. http://tech.alirazazaidi.com/how-to-create-a-custom-filter-on-list-or-inquiry-form-in-dynamics-ax-2012/   For this filter add two … [Read more...] about Date in Advance filter Dynamics Ax 2012

How to get trade agreement price for An Item or for customer Dynamics Ax 2012

By

When we make trade agreement, there are 3 possibilities On some products we make discounted price for all Customers. On some products we make discounted for selected Customers All products have discounted or fixed prices for some customers. Third case is exceptional, but there is possibility that organization set sales prices on all items for some customers or all … [Read more...] about How to get trade agreement price for An Item or for customer Dynamics Ax 2012

How to check Dynamics Ax 2012 form is in edit mode

By

During development, I wrote code in clicked event of Button. But requirement is that code will works only if form is in edit mode. I used following code to check it   boolean _bool; supper(); _bool=   element.inViewMode(); if (_bool==boolean::true) { info ("true"); } else { info ("false"); } This  method element.inViewMode() return true when form … [Read more...] about How to check Dynamics Ax 2012 form is in edit mode

VendBankAccount and BankAccountTable address relation Dynamics Ax 2012

By

We can get address for VendBankAccount table and BankAccountTable by following way.   VendBankAccount  table has method which returns address VendBankAccount.addressing() ; For BankAccountTable you can use following query to fetch its address, both table has similar releationship with logistic location table BankAccountTable … [Read more...] about VendBankAccount and BankAccountTable address relation Dynamics Ax 2012