Microsoft Dynamics Axapta Technical,Functional Coverage

How to call job to another job in axapta using x++ code 1. Create simple job job_test  and add it to action menu item in AOT. 2. Call job_test in other job using following code.    Args                    args;     ;         args = new Args();     args.name(identifierStr(Jobs_Test));     new menuFunction(menuItemActionStr(Jobs_Test), MenuItemType::Action).run(args); If you want to add job in action menuitem then just right click on aot menuitem on action type then create new menuitem. After that you can set that job in object selection property of menuitem.  You can not direction drag job to action menuitem.

How to get current active company in Axapta If you want to get name of current active company then curExt() is right method to get it just try following code in job info(CurExt()); It will show you current active or selected company.

Simple Example of using tables in Query in axapta Reprts     Query q;     QueryRun qr;     QueryBuildDatasource qbds;     QueryBuildRange qbr;    InventTable inventtab;     ;     q = new Query();     qbds = q.addDataSource(tablenum(InventTable));     qbr = qbds.addRange(fieldNum(InventTable,Status));     qbr.value(queryValue(NoYes::No));     qr = new SysQueryRun(q);     while(qr.next())     {     inventtab = qr.get(tableNum(InventTable));     info(inventtab.Itemid);     }

select * from USERINFO where  ID = 'userid' update USERINFO set ENABLE = 1 where ID = 'userid' update USERINFO set SID = 'write correct SID' where ID = 'userid'

Code to send email with attachment using dynamics axapta x++ void SendEMail() {     System.Net.Mail.MailMessage              Message;     System.Net.Mail.Attachment              attachment;     System.Net.Mail.AttachmentCollection    attachementCollection;     System.Net.Mail.SmtpClient              smtpClient;     System.Net.Mail.MailAddress             emailfrom;     System.Net.Mail.MailAddress             emailto;     str                     ...

Add tables to query build datasource ,addlink,relation static void QBDSExample(Args _args) { Query query; QueryBuildDatasource datasource; ; query = new Query(); // Add purchtable main datasource datasource = query.addDataSource(tableNum(purchtable)); // Add child datasource "purchline" datasource = datasource.addDataSource(tableNum(purchline)); // Set the join mode datasource.joinMode(JoinMode::InnerJoin); datasource.relations(false); datasource.addLink(fieldNum(purchtable, purchid), fieldNum(purchline, purchid)); info(query.xml()); }

You can write following code  to get all table ids from AOT using dynamics axapta x++ language. Axapta is developed on .Net platform and its object base programming. You need to understand object concept before starting programming in axapta. You can declare object for tables,forms,reports,class,views etc . //variable declaration Dictionary dictionary1; TableId tableId1; ; // initialize object dictionary1 = new Dictionary(); // set initial table id tableId1 = dictionary.tableNext(0); // start table id loop while (tableId1) { info(int2str(tableId1)); tableId1 = dictionary1.tableNext(tableId1); } // end table id loop

How to Print table data without declaring object variable of table static void Job_GetDatawithouttableobject(Args _args) { ; print (select Empltable).Name; pause; }

How to show current company lanugaue in message box in axapta Public static void showLanguagecurrent() { info(infolog.language()); }

How to get day,month,year from your date variable using axapta x++ to Get day from date dayOfMth(your date variable or date value) to Get month from date mthOfYr(your date variable or date value) to Get year from date year(your date variable or date value)

Create user defined mod method in axapta There is no inbuilt function to get mod of two values to we can create our own function to get mod by following way. real UserDefinedMod(real x, real y) { ; return (x - ((trunc(x / y) * y))); }

Count total number of records of query in axapta through code to count record from first datasources  write code in following manner. SysQuery::countTotal(queryRun) to count records from all attached table to query wrtie following code. SysQuery::countLoops(queryRun)

 Browse table through code in microsoft dynamics axapta x++ If you want to open table in axapta without touching table then you can open any table by only 2 line code which is below. SysTableBrowser sysTableBrowser = new SysTableBrowser(); ; SysTableBrowser.run(tablenum(emplTable));

How to open executable file from dynamics axapta through code If you want to open exe file from dyanmics axapta application then you can write following line in your form on any event where you want. just put following code with correct path of exe file. WinAPI::shellExecute(path of the file);

How to Use Query in form at runtime in microsoft dynamics axapta Write following code in init method of form. you must create MyQr first which is name of query. QR QR; Args args = new Args(); ; super(); args.name(querystr(MyQR)); QR = classfactory.QRClass(args); this.query(QR.query());

Application Files Back-up In Application file Backup, you will be taking back up of all the customizations you have made in the system. IMP: Please STOP the “Services” before taking Application Back-up. To stop the services follow the following process. 1. start > Run 2. type “services.msc” and press enter. 3. Following window will appear select the “Dynamics AX Object server 5.0$03-AXTEST service. 4. Right click on the service and select stop Similarly stop Dynamics AX Object Server 5.0$02-AXTEST service also. After Stopping service take backup of a. D:\Microsoft Dynamics AX\ Application\appl\AXTEST50 b. C:\Program file\Microsoft Dynamics AX\ Application\ appl\AXTEST c. Take one time backup of D:\Microsoft Dynamics AX\ Application\ appl\copy* It is recommended that after any customization backup of above folders is done after STOPPING THE SERVICES. After Doing all this please start the services which we have stopped earlier.

The cause of these errors are due to the Business Connector Proxy and Internet Information Server (IIS) Application Pool owners having insufficient rights on the IIS Server. Resolution To Resolve the errors, you will need to: 1) Make sure the Business Connector Proxy user and the IIS Application Pool owner for the Enterprise Portal website match. 2) Add the Business Connector Proxy and IIS Application Pool owner to the following local Windows Groups on the IIS server: Power Users Performance Monitor Users group 3) Reset IIS (Click Start, Click Run, type: IIS Reset, and click 'ok'

Source: SharePOint Event ID:104 Description: Failed to register SharePoint services. An exception of type System.ArgumentException was thrown.   Additional exception information: Error during encryption or decryption. System error code 997. System.ArgumentException: Error during encryption or decryption. System error code 997.    at Microsoft.SharePoint.Administration.SPCredentialManager.DecryptWithMasterKey(Byte[] rgbEncryptedPassphrase)    at Microsoft.SharePoint.Administration.SPEncryptedString.GetSecureStringValue()    at Microsoft.SharePoint.Administration.SPEncryptedString.get_SecureStringValue()    at Microsoft.SharePoint.Administration.SPProcessIdentity.get_SecurePassword()    at Microsoft.SharePoint.Administration.SPProcessIdentity.Provision()    at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.ProvisionCredentials()    at Microsoft.SharePoint.Administration.SPWi...

SharePoint Central Administration Pool properties setting 1) Go to Start>Administrative tools>Internet Information Services(IIS) Manager 2) Open Application Pools 3) Right click "SharePoint Central Administration" and choose "Properties" 4) Go to Identity page 5) Choose "Predefined" "Network Service" and click [Apply] and [OK 6) Right click "SharePoint Central Administration" and choose "Recycle"

Error "User, group, or role 'WSS_Content_Application_Pools' already exists in the current database" Solution: Start>>Run>>cmd Type Following command: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\ Stsadm –o upgrade –inplace –url http://<.....>

Below is the List of Software’s Required for Installation of AX 4.0 and Enterprise Portal: Software Required for Installation of AX 4.0: Windows Server 2003 (with Active Directory Structure Installed) (Product CD) SQL Server 2005 / SQL Server 2000 with SP4 (Product CD) AX 4.0 (Product CD) Windows Installer 3.0 Internet Explorer 6.0 with SP2 or later Software Required for Installation of AX Enterprise Portal: Windows SharePoint Services 3.0 .NET Framework 3.0 Microsoft Internet Information System 6.0

If you are facing this error like Error  Not enough right to use table ABC that means its configuration problem just go to menu Administration > Setup > System > Configuration  and check tick and no tick check box for particular module or tables. Once you selected your module then it will go for synchronization process. Once its done then  you can check your tables and changes in AOT. I hope this will help you to solve this error.

Summary: If you want to  import XPO file to AOT in Microsoft dynamics axapta x++ applications through code then you can write following job in job sections of Axapta Details static void ImportXPOthroughJob(Args _args) { SysImportElements sysImportElmt1 = new SysImportElements(); ; sysImportElmt1.newFile("E:\\test.xpo");// This is to assign path of XPO filename sysImportElmt1.parmImportAot(true); sysImportElmt1.parmImportWithIds(false);//This to import without using xpo object ids sysImportElmt1.import(); }

Some keyword list for microsoft dyanmics axapta lovers Summary: These are keyword list which is related to micorsoft dynamics axapta ERP using language x++. If you are daily blogger then you can use these keywords for your blog also. using macro axapta dynamics ax posting invoice flow disabling the route category in Axapta 2009 dynamics ax section group one page ax lookup field language dynamics ax validatedelete on datasource code developer jpg dynamics ax sleep 100 invoice journal set permissions ax how to uncheck mandatory credit limit from ax 2009 how to remove all mandatory credit limit from ax 2009 dynamics ax exist join dynamics ax 2009 timezones import purchase orders dynamics ax report execute method  how to handle import purchase order functionality in microsoft dynamics ax which includes duty, insu  x++ string compare  dynamics ax+commaio read  ax query range wildcard  x++ lookup report dialog  dynamics ax runbase tutori...

Dear Friends, Currently following exam available for Microsoft axapta 2012 which is for development introduction and its very easy to clear because course contents is too short and  you can prepare easily . Available exam name and code is  Exam MB6-869: Microsoft Dynamics AX 2012 Development Introduction

Create Web Modules in Enterprise portal in axapta 1. Create your module as a sub module to Home. Do not create it as a sibling to Home module. 2. Set the Quick-launch and MenuItemName property. Both are required for the module to work 3. To get this new module in an existing EP site, mark that EP site as the Dev AOT site in the websites form in AX client and right click on the newly created module and deploy. Note you can only deploy the web module once. It won’t redeploy if that subsite already exists. 4. After deploying reset IIS and AOS for it to appear in the top nav.