Microsoft Dynamics Axapta Technical,Functional Coverage

How Group by clause work in Axapta x++ If we use group by clause in ax then we should know how it work . for example select tabletest group by testno,testgroup; it means you will get record by grouping of testno and testgroup but it there is no field selected that means its internally two fields testno,testgroup is in select query means actual query working like this. select testno,testgroup from tabletest group by testno,testgroup; you can also select group by clause with while like this while select tabletest group by testno,testgroup { statements; ----------- ---------- } if we take aggregate funtion with group by clause like this select count(recid) from tabletest group by testno,testgroup; then actual query will work like this select count(recid),testno,testgroup from tabletest group by testno,testgroup;

AOS Tasks • X++ run time: It runs the X++ code which provides most of the business logic in Microsoft dynamics AX. • Security: It enforces security to manage access to data and functionality. Record level security • Session management: It manages client sessions. • Web services: It is a web service endpoint.

Some times we face this error which is SQL Error " can not select record from table abc " in axapta application. This error comes due to some index problem or record duplication in table to resolve this problem we can do following. 1. Find index which creating problem you can re index that index. 2. Restore table using right click on table restore option. 3. Synchronize table if problem still not resolved. 4. If problem still not resolved then try to synchronize whole data dictionary in AOT. 5. If you are facing problem due to duplication of records then try to delete duplicate records. By using above steps I hope your problem will resolve.

User name and password screen form for axapta applicaiton: If you want to set separate login screen for axapta application then its very difficult to implement but I want to share some hint to help you because this things is in high demand. 1. First you can create table for login details with field user-id and password. extended data type for user id should be userid to select user id for password you can set property password type to yes then you can use different event to maintain password in * character through code. 2. Create login form to enter login details to store it. 3. Create another login form put control for userid and password to check from table you can write validation code on that form. 4. put that form in display menu. 5. call that login form in  application class in start-up post method. this will work if everything done well.

Send report to email using batch process in axapta To send any report to particular email of person throgh batch process we need to follow folloing steps and points 1. set email parameter set outgoing email,local host, user name and passwords. 2. set email template there you can give sender name,email, description,language etc. 3. set email in report dialog and select pdf print option, 4 . Make sure server is added to allow send mail etc in different applications which restrict to send email through axapta batch process. 5. set reccurence in batch process of report to set time etc. if you do all those steps completely than you can get success in this task .

Example of validate method in Ax using lanugage x++ void clicked() { super(); if(str2num(rlSrNo_Update.valueStr()) == 0) { Warning("Not Valid Roll No"); } else if(strEmployeeName_Update.valueStr() == "") { Warning("Pleae Enter Employee Name"); } else if(cmbTravellingThrough_Update.selection() == test_Travelling_Through::None) { Warning("Pleae Enter Traveling Through"); } else { element.Update_test_Emp_Travel(); } }

Example of executeQuery in axapta x++ language public void executeQuery() { QueryBuildDataSource qbds_test_Emp_Travel; ; qbds_test_Emp_Travel = this.query().dataSourceTable( tablenum(test_Emp_Travel) ); qbds_test_Emp_Travel.addOrderByField(fieldnum(test_Emp_Travel, SrNo),SortOrder::Descending); super(); }