Microsoft Dynamics Axapta Technical,Functional Coverage

Problem : Do you have any ideas to solve with AX hanging when I start "Marge code automatically" in SOFTWARE UPDATE CHECKLIST (It's just updating AX 2012 R2 to AX 2012 R2 CU7) It's screenshot with stage on which I have hangs: Solution : During checklist system generate log at database side . Need to check whether disk space is enough at the time of process. Check Memory utilization at database side and AOS Side. There should be enough RAM on database side. Check kernal and application version it should be same. Check batch group is attached in proper batch server.

If you have written code to import data in Ax Table using Excel template and getting value blank in any column which is string type but value is mentioned in Excel column. After checking that column value getting that number entered in string field and import code not able to pick number in string field  to handle that situation you need to write below code for particular field . switch(Cells.Item(Rownum, 11).value().variantType()) { case COMVariantType::VT_BSTR: accNo = strFmt("%1", Cells.Item(Rownum, 11).value().bStr()); break; case COMVariantType::VT_DECIMAL, COMVariantType::VT_R4, COMVariantType::VT_R8: accNo = strFmt("%1", any2int(Cells.Item(Rownum, 11).value().double())); break; case COMVariantType::VT_I1, COMVariantType::VT_I2, COMVariantType::VT_I4: accNo = strFmt("%1", Cells.Item(Rownum, 11).value().int()); break; case COMVariantType::VT_UI1, COMVariantType::VT_UI2, COMVariantT

Error description: Stopped workflow suddenly and throwing below error Cannot select a record in Work items (WorkflowWorkItemTable). User: abc, Check and Approve Purchase Order. The SQL database has issued an error. Solution: Give Full CIL then error not resolved.  We check batch job and showing there  batch job for workflow work item and due date getting stopped with error shown above. I changed the status of job to waiting.System Administrator->inquiries->Batch Jobs After that workflow error resolved.

 There is simple View creation for Workflow status tracking for work item in Ax 2012. You can get table details in below diagram. Workflow status tracking for header table is workflowtrackingstatustable and to get different approval task for that table is workflowtrackingtable and same way to track workflow item-wise you can select table workflowworkitemtable and task status item wise is workflowtrackingworkitem. You can define range for status field for pending ,cancel or stopped workflow. You can give other column for range in view to check with small number of records. If repetitive records come then you can use group by in your query.

Development Interface for Rainier This is the AOT Overview where you can see data model,user interface, security,  services, code, resources,label files etc.  Data model include tables,views,Queries,Maps ,table collection etc. Dynamics Ax7 tool is import where you ca deploy new changes,import project,build model,synchronize database,label details,addins ,option etc.  User Interface module include forms,tiles,menus,menu-items etc

Task Recorder If you want to use Task Recorder in Microsoft Dynamics AX7 code named Rainer-AX 2015 then you can use option as below. Go to Option then Select task recorder. Click on create new task. Assign name of Task then click on start. After finishing the process you need to stop task recorder. If you want to generate document you can do that by downloading word document option.

Dynamics Ax overview Dynamics Ax Features .

Convert Container value to String format in axapta To Convert Container value to String format in axapta  you can use con2Str method. Below is the sample of code to tryout in your job to check the string value. container TestCont; TestCont+= "He is not a permanent "; info(con2Str(abc)); TestCont+= "Employee and belongs to Sales Department"; info(con2Str(TestCont));

Database information,Re index,Synchronize table database, Truncate table in Axapta To get Database information for your AX Just following following step 1. Click Area Page node: Administration -> Inquiries -> Database -> Database information. 2. Close the Database information form. Reindex Table 1. Click Area Page node: Administration -> Periodic -> SQL administration. Select all table 2. Click the Index actions -> Reindex menu button. To Check/Synchronize Table 1.Click Area Page node: Administration -> Periodic -> SQL administration. 2. Click the Table actions -> Check/Synchronize menu button. Same way you can use other option Like Synchronize database 1. Click Area Page node: Administration -> Periodic -> SQL administration. 2. Click the Table actions -> Synchronize Database. Truncate Table -If you want to delete all records of particular table then you can use truncate option. 1. Click Area Page node: Administration -

Display Address from multiple to single line in axapta Mostly we face issue to Display Address from multiple to single line in axapta report in Ax 2009 . Following is the way to do it very easily. Code snaps is as below.. str lineall; ; lineall =lineall +strline(CompanyInfo::find().Address,0); lineall =lineall +strline(CompanyInfo::find().Address,1); lineall =lineall +strline(CompanyInfo::find().Address,2); lineall =lineall +strline(CompanyInfo::find().Address,3); lineall =lineall +strline(CompanyInfo::find().Address,4); lineall =lineall +strline(CompanyInfo::find().Address,5); return lineall;

Validate Name in Axapta To Validate Name in Axapta  you can refer below code. --------------------------------------Code block---------------------------- boolean validatestrName(str strName) { Boolean valid,flag; System.Boolean flagTest; str matchstrNo = "^[a-z, ,A-Z]+$"; System.Text.RegularExpressions.Match myMatch; New InterOpPermission(InteropKind::ClrInterop).assert(); myMatch =System.Text.RegularExpressions.Regex::Match(strName,matchstrNo); flagTest = myMatch.get_Success(); flag = flagTest; CodeAccesspermission::revertAssert(); if(strName == "") return true; else return flag; } --------------------------------------End Code block-------------------------