Dynamics AX Blogs

We often need to check check date time is null or not during coding. Dynamics AX provide global class which contains some helper methods one of them is datenull. You can use it compare date whether is null or not. Global::DateNull() There is another way to achieve it but this is not correct approach but it can be used. mydate != mkdate(1,1,1900) Here we are just checking date is set to minimum value  or not.

Dynamics AX Full Compilation takes too much time to complete. From Dynamics AX 2012 R2 CU7 you can do full compile much faster with the help of AXBuild.exe. It runs in parallel executing on the AOS instead of AX client. You can found AXBuild.exe from this location. C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin Open AXBuild.exe in command prompt and run full compile with following command axbuild.exe xppcompileall /s=01 /altbin=”C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin” /log:”C:\Temp”

Today i faced the problem when run full compile. Dynamics AX give me error "The given key was not present in the dictionary". Quick fix is to see what is problem in log file "C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL\Dynamics.Ax.Application.dll.log". Log file will give the AOT object name which is creating problem, fix the error and compile to make sure no other error exists in AOT object.

I was start getting error "Parameter is missing a value" when i left blank parameter of report. To make report parameter optional you have to follow these steps. 1. Open report in Visual Studio. 2. Go to Parameters and open the properties of your parameter.   3. Set Allow Blank to true. 4 Set Nullable to true. 5. Build and deploy the report. 6. In AOT, goto SSRS report and right click on your report and select Deploy Element. 7. Run your report.

Use following methods to get Month Start Date and Month End Date. Pass any date of month in parameter. Month Start Date :    TransDate dateInMonth=today(); TransDate firstDateOfMonth; ; firstDateOfMonth = DateStartMth(dateInMonth); Month End Date : TransDate dateInMonth=today(); TransDate endDateOfMonth; ; endDateOfMonth= endmth(dateInMonth);

In Dynamics AX  2012 there is a problem in form data source that newly created field often not display data and "UnRetrieved" is display on the form. This error can be resolve by restarting AX or restating Dynamics AX 2012 service. When ever you crate new filed in table, you have to refresh the form so the new filed will be added in form datasource.

Today i got this error when i try to run my code. Actually this error is telling that tts level in unbalanced and cant perform edit operations. To resolve this error this TTS level should be ZERO, Run this job to get rid of that error, this job will find the tts level where its greater than zero and make it zero by calling TTSABORT. tts b egin : marks the beginning of a transaction. This ensures data integrity, and guarantees that all updates performed until the transaction ends (by  tts c ommit  or  tts a bort ) are consistent (all or none). ttsCommit: marks the successful end of a transaction. This ends and commits a transaction. MorphX guarantees that a committed transaction will be performed according to intentions. static void TheAxaptaResetTTS(Args _args) { while (appl.ttsLevel() > 0) { info(strfmt("Level %1 aborted",appl.ttsLevel())); ttsAbort; } }

I got required to display exact age of employee in days, month and years. I used some DateTimeUtil method and achieve my output. public static void getAge(Args args) { int years, months; int64 days; utcDateTime birthDayCurrentYear; str ageInWords; date _birthDate ; months = mthOfYr(systemdateget()) - mthOfYr(_birthDate); years = year(systemdateget()) - year(_birthDate); if (dayOfMth(systemdateget()) < dayOfMth(_birthDate)) { months--; } if (months < 0) { years--; months += 12; } #timeConstants birthDayCurrentYear = DateTimeUtil::addMonths(DateTimeUtil::newDateTime(_birthDate,0), ((years * 12) + months)); days = DateTimeUtil::getDifference(DateTimeUtil::newDateTime(systemdateget(),0) , birthDayCurrentYear) / #secondsPerDay; ageInWords = strFmt("%1 years, %2 months, days %3", years, months, days); info(ageInWords);

During development in Dynamics AX 2009 and using business connector to get data from Dynamics AX i faced a problem that result were stored in cache and not reflecting the changes, to resolve this issue when i made changes on Dynamics AX i restart the AX service but after some time it stops working and it again not reflecting the changes, so i add following line of code in business connector code after logging in and it start working. Axapta ax = new Axapta(); ax.LogonAs(credentials.UserName, credentials.Domain, new System.Net.NetworkCredential(credentials.UserName, credentials.Password), null, null, null, null); ax.CallStaticClassMethod("SysFlushAOD","doFlush"); ax.CallStaticClassMethod(“SysFlushAOD”, “doFlush”);

Retrieves the nonnumeric ID that represents the current user. curUserId(); Following function will return the name associated with the current user. XUserInfo::find(false, curUserId()).name; In order find out the employee linked to the current user. AX 2009: EmplTable::find(SysCompanyUserInfo::find(curUserId()).EmplId); AX 2012: HcmWorker::find(DirPersonuser::findUserWorkerReference(curUserId())).name();