Tips and tricks

Today I was configuring POS on Azure test/dev environment, I got very strange errors during compilation  of classes node.

All these classes were belong to Payroll modules.

Error described that Symmetry variable is not declare.

 

Later I discover that reference of ste-net.dll is missing in AOT.

This mysterious dll (mysterious for me) is found at  C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin

 

Yu can add  its reference by right click on reference node In AOT

 

Click on browse and go to  C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin

Select

Select and click on ok

As reference is added into AOT. Compilation errors are gone.

 

Reference:  https://community.dynamics.com/ax/f/33/t/150222

 

Today I come across a scenario where, I have to read data from csv file.

 

Reading data from csv file is very easy with IO operation. For example I have csv file with following student first name and last name which I have to migrate into custom ax table.

 

 

Custom Ax table.

 

 

Following a simple code snippet which read csv file and insert data into custom data

static void Job9(Args _args)

{

#File

IO  iO;

Name FirstName;

Name LastName;

StudentInfo _StudentInfo;

FilenameOpen        filename = “c:\\StudentInfo.csv”;//To assign file name

Container           record;

boolean first = true;

;

    iO = new CommaTextIo(filename,#IO_Read);

if (! iO || iO.status() != IO_Status::Ok)

{

throw error(“@SYS19358”);

}

while (iO.status() == IO_Status::Ok)

{

record = iO.read();// To read file

if (record)

{

if (first)  //To skip header

{

first = false;

}

else

{

 

FirstName = conpeek(record, 1);//To peek record

LastName = conpeek(record, 2);

_StudentInfo.FirstName=FirstName;

_StudentInfo.LastName =LastName;

_StudentInfo.insert();

//     info(strfmt(‘%1–%2’,custAccount,custname));

}

}

}

}

 

 

After running the ax job, I found following data into Ax table.

 

If you saw, first row of csv is missing in table. The reason for that above code snippet consider first row as header so it did not require to insert it.

 

One thing I missed, The reference, original code snippet is belongs to “Jitendra Kumar Singh”

http://axaptacorner.blogspot.com/2012/09/how-to-read-csv-files-in-ax-2012.html

I was configuring Dynamics AX 2012 R3 reporting extension on one of Virtual machine. Here is my notes with step by step screen shot.

First step to run step up and then add or modify component option.

Click on next button and select reporting extension  form

Click on next and from next window click on

Validate it, if any component is missing then download and install it.

When validate and click on next.

 

From next screen enter Business connector, as on my R&D virtual machine

 

From next screen select the required reporting server.

If you want to deploy report just after the installation, check the deploy reports.

Click next to run the installation process,

 

 

Now a power shell window opens report deployment is started.

 

Let it completed.

 

After let it complete, Open Dynamics Ax client by right click on its icon and run as administer.

 

Now go at Administrator module and click

And ad server name and click on validate button

Now report server configured successfully and all reports will successfully run.

Microsoft Dynamics Connector and installation and configuration step by Step.

 

I configured the Microsoft Dynamics Connector on my local configured virtual machine where standard Microsoft Dynamics Ax 2012 R3 installed.

Here are step by step and my notes

 

First step to run the setup form and choose add or modify component option

 

Click on next and select the connector from very below end

Next to validate, if validation failed then download required component to made it validate.

 

Click next button

 

From next step select the default server on which you are installed the connector.

Enter the service account and click on next.

Here is trick, Setup required a user, I created a separate user in my domain control with administrator rights. Like “dynamicworlds\AXIntUsr”.  Select the “create new account”.

If you want to use existing ax user then select “Use existing account” and enter its name against Ax user ID.

I used the create a new user ax option, It will added the domain user into Ax with following groups

 

Click next and complete the step. And check the log file if there is failure else complete it.

 

Now run the Dynamics connector with administrator rights

 

And select Dynamics Ax adapter.

Set its configuration with newly created user

 

Click on configure Microsoft Dynamics Ax 2012 link to open second screen

 

Click on refresh services.

And select the required service. And click on configure button

Now close this window and click on click on test button. This will also result on success.