Microsoft Dynamics Axapta Technical,Functional Coverage

How to use Struct in axapta Struct s = new Struct ("str name; int age"); ; // Set the values s.value("name", "Jane Dow"); s.value("age", 34); // Print the values print s.value("name"); print s.value("age"); pause;

Get ODBC Type using axapta code ODBCConnection connection; SqlSystem sqlSystem = new SqlSystem(); LoginProperty loginProperty = sqlSystem.createLoginProperty(); Statement statement; ResultSet resultSet; SqlStatementExecutePermission sqlStatementExecutePermission; str sqlStatement; loginProperty = sqlSystem.createLoginProperty(); loginproperty.setOther(strfmt('dsn=abc;uid=xyz;pwd=dds')); connection = new ODBCConnection(loginProperty); statement = connection.createStatement(); sqlStatement = "select * from test "; sqlStatementExecutePermission = new SqlStatementExecutePermission(sqlStatement); qlStatementExecutePermission.assert(); resultSet = statement.executeQuery(sqlStatement); while(resultset.next()) { info(strfmt("%1 %2", resultset.getString(1), resultset.getString(2))); }

Get Time difference in axapta DateTimeUtil::getDifference(DateTimeUtil::getSystemDateTime(), abcDateTime)

1) Axapta Table Backup - Using “Definition Group” 2) SQL Backup (Axapta Table backup and Olap database backup) 3) Application Back-up ( Customization Back-up) 4) OLAP Visual Studio project backup 1. Axapta Table Backup - Using “Definition Group”: Go to Administration > Periodic > Data Export / Import > Definition Group > Create new Definition group “ Table Back up” Identify the name of a definition group. Click on “Include Table Groups” tab. Select all the check boxes including the transactions also. Click OK. A definition group will get created in the form Data exporting will start and two files with extension *.dat and *.def will be saved in selected location.

Creating a new number sequence is achieved by creating a new reference for the sequence. Follow these steps to create a new number sequence: 1. Create a new Extended Data Type (EDT). Often this EDT extends num. This is not mandatory, but it is a best practice. 2. Decide which module’s parameters this number sequence reference should be included in, and find the corresponding NumberSeqReference sub class. 3. The loadModule() method shows a number of blocks of code, which creates records in the table NumberSequenceReference. 4. Copy one of these blocks and change the following fields: a. DataTypeID is the type Id of the new data type. b. referenceLabel is the description shown in the left column of the Number sequence tab on the parameters form. c. referenceHelp is the longer description of the reference shown in the top part of the Number sequence tab of the parameters form. d. sortfield defines the sequence that the references are displayed on the Num

Microsoft Certified IT Professional: Applications for Microsoft Dynamics AX 2009 Note You must pass one required exam and three elective exams to obtain a certification. Exam title Exam number Required: Financials in Microsoft Dynamics AX 2009 Exam MB6-818 Elective: Trade and Logistics in Microsoft Dynamics AX 2009 Exam MB6-817 Elective: Development Introduction in Microsoft Dynamics AX 2009 Exam MB6-819 Elective: Production in Microsoft Dynamics AX 2009 Exam MB6-822 Elective: Project Series in Microsoft Dynamics AX 2009 Exam MB6-823 Elective: Human Resource Management in Microsoft Dynamics AX 2009 Exam MB6-824 Elective: Product Builder in Microsoft Dynamics AX 2009 Exam MB6-826 Elective: Payroll in Microsoft Dynamics AX 2009 Exam MB6-827 Microsoft Certified IT Professional: Developer for Microsoft Dynamics AX 2009 Note You must pass two required exams and two elective exams to obtain a certification. Exam title Exam number Req

Microsoft Dynamics AX development certification •Development – Introduction •Development – Enterprise Portal •Development – MorphX Solution •Financials •Human Resources Management •Installation and Configuration •Product Builder •Production •Project Series •Questionnaire •Sales and Marketing •Shop Floor Control •Trade and Logistics