Skip to main content

Posts

Showing posts from December, 2010

Get ODBC Type using axapta code

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))); }

Data Backup in Microsoft Dynamics AX

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.

Create a new number sequence

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 Dynamics AX certification

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

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

Microsoft certification most valuable courses in Axapta

Microsoft certification most valuable courses in Axapta Exam MB6-817: Trade and Logistics in Microsoft Dynamics AX 2009  • Exam MB6-818: Financials in Microsoft Dynamics AX 2009  • Exam MB6-819: Development Introduction in Microsoft Dynamics AX 2009  • Exam MB6-820: Installation and Configuration in Microsoft Dynamics AX 2009  • Exam 70-432: TS: Microsoft SQL Server 2008 Implementation and Maintenance

Number Sequence creation through code in axapta

Number sequence Creation Add method current form where number sequence needed NumberSeqFormHandler numberSeqFormHandler; NumberSeqFormHandler numberSeqFormHandler() { if (!numberSeqFormHandler) { numberSeqFormHandler = NumberSeqFormHandler::newForm(ProdParameters::numRefSrNo().NumberSequence,element,TableName_ds,fieldnum(TableName,SrNo)); } return numberSeqFormHandler; } public void delete() { element.numberSeqFormHandler().formMethodDataSourceDelete(); super(); } public void write() { ; ttsbegin; super(); element.numberSeqFormHandler().formMethodDataSourceWrite(); ttscommit; } void create(boolean _append = false, boolean extern = false) //If created externally { ; element.numberSeqFormHandler().formMethodDataSourceCreatePre(); super(_append); if (!extern) { element.numberSeqFormHandler().formMethodDataSourceCreate(); } //GODInstrumentCalibrationHeader.Responsibility =curuserid(); To par

Axapta Coverage

As per my experience and knowledge following places in India have nice axapta market. 1 Mumbai- Here Godrej infotech,TCS(Tata consultancy Services),NDS,L &T Info-tech etc working well in Axapta and lot of other companies also implemented Axapta. 2. Ahmedabad:- DevITP(Dev Information technology Pvt. Ltd) Ahmedbad,Indusa etc 3. Vadodara:- TDW,GERI(Gujarat Engineering Research Institute)  implemented Axapta etc 4. Pune 5. Bangalore 6. Hyderabad-Accenture 7. Delhi 8. Jaipur 9.Udaipur 10.Gurgaon 11.New Delhi 12-Gandhinagar-Gujarat Other Place like  Jamnagar etc also have good scope for axapta.

call form through class in axapta

This code is to how to call any form using class.I think this is challenging for new developpers. create mathod create form protected FormRun createForm(identifiername identifiername) { Args args; FormRun formRun; ; args = new Args(); args.caller(this); formRun = new MenuFunction(identifiername, MenuItemType::Display).create(args); formRun.run(); formRun.wait(); return formRun; } Public boolean prompt() { Object formRun; ; formRun = this.createForm(menuitemdisplaystr(Formaname)); Code = formrun.formmathod(); return formRun.okPressed(); }