Alfasith AX

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

Wednesday, May 7, 2014

Adding indicators to the table in Dynamic AX

Hi,

display ImageRes showIndicatorImage()
{
    #resAppl

    int ret;
    ;
    ret = 0;
//By Alfasith for the requirement of red and green indicator
    if (this.ExpiryDate > systemDateGet() )//  == AnotherTable::find(this.ForeignKeyField).MyField)
        ret = #ImageAgingPeriod2_small;
   else
        ret = #ImageAgingPeriod5_small;

    return ret;
}

Regards,

Generate random password in Dynamic AX

Hi,

Just like OTP (one time password) for email this below code generates for alphabet.

static void Generate_Password_Random()
 {
     int i;
     RandomGenerate random = new RandomGenerate();
     str password;
     int passwordLength = 8;
     ;

     for (i=1; i<= max(2, passwordLength); i++)
     {
         if (i mod 2)
             password += num2char(random.randomInt(char2num('a', 1), char2num('z', 1)));
         else
             password += num2char(random.randomInt(char2num('0', 1), char2num('9', 1)));
     }

     info(password);
 }

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...