Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Monday, July 7, 2014

Code to get IP from the syste name / server name belongs to same domain

Hi,

1. Start >  RUN > CMD
2. PING -4 (SERVER NAME / SYSTEM NAME)
 //here You can also enter just directly PING Syste_Name

This will return the IP of the system provided system should be in same domain.
Here my system in the XXXX domain and to get the server IP where my instance is installed.
it returns the ip.

Regards,

Friday, June 27, 2014

How to fetch the standard notes for concern module in Dynamic AX

Hi,

FormLetterRemarks::find(companyinfo::languageId(),
 FormTextType::PurchPurchaseOrder).Txt;
// Here I used to fetch the currecnt user language as 1st parameter
// and for the Purchase Order Notes as 2nd parameter

Regards,

Tuesday, June 24, 2014

Job to print all the roles in Dynamic AX

Hi,

static void AlfasithTotalRolesInAX(Args _args)
{
    SecurityRole        role;
   while select role order by Role.Name asc
    {
        info(strFmt("%1 --- %2",Role.Name,Role.RecId));
    }
    pause;

}

Regards,

Job to list out all roles to current user in Dynamic AX

Hi,

static void AlfasithListOutRoles2User(Args _args)
{
    SecurityRole        role;
    SecurityUserRole    userRole;
    boolean             added;
    UserInfo            userInfo;
    ;
    while select * from userRole
            where
                userRole.User == xUserInfo::find().id
    while select role where role.RecId == userRole.SecurityRole
    {
        info(strFmt("%1 --- %2",Role.Name,Role.RecId));
    }
}

Regards,

Job to assign the user role to all user in that instance in Dynamic AX

Hi,

static void AssignUserRights(Args _arg)
{
   SecurityRole        role;
    SecurityUserRole    userRole;
    boolean             added;
    UserInfo            userInfo;
    ;

    select role where role.Name == "Accountant";
    while select userInfo
    {
        select * from userRole
            where userRole.SecurityRole == role.RecId &&
                userRole.User == userInfo.id;
            if (!userRole || (userRole.AssignmentStatus != RoleAssignmentStatus::Enabled))
        {
            info(strFmt('Role %1 added to the user %2 successfully.', role.Name, userInfo.id));

            userRole.User = userInfo.id;
            userRole.SecurityRole = role.RecId;
            userRole.AssignmentMode = RoleAssignmentMode::Manual;
            userRole.AssignmentStatus = RoleAssignmentStatus::Enabled;
            SecuritySegregationOfDuties::assignUserToRole(userRole, null);
        }
        else
        {
            warning(strFmt('skipping – Role %1 to the user %2.', role.Name, userInfo.id));
        }
    }
    pause;
}

}

Thursday, June 19, 2014

Issue of refresh in form automatically record points to first potion in X++

Hi,
// use below code in datasource refresh of field modified or depends on your requirement
public void refresh()
{
    int i;
    //Alfasith to retain the cursor position by getting the position and setting the position
        i = dnSalaryCalculationTrans_ds.getposition();
  //  info(int2str(i));
   if(i != 1)  // Declare the k & m as int in global declaration
        m = i;
    if(!(k == m && k == i))
        k = m;
    if(k)
    {
        dnSalaryCalculationTrans_ds.research(); // Data source that I used
        dnSalaryCalculationTrans_ds.refresh();
        dnSalaryCalculationTrans_ds.setposition(k);        
    }
    super();
}

Regards,

Get a table ID in SQL / table browser - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' <URL>/?cmp=<CompanyID>&mi=sysTableBrowser...