Alfasith AX

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

Tuesday, February 13, 2018

Query not value enum in AX 2012

Hi,

    qbrLogStatus    = qbdsDASProjLogLines.addRange(fieldnum(DASProjLogLines,ProjLogStatus));
    qbrLogStatus.value(SysQuery::valueNot(enum2str(DASProjLogStatus::Superseded)));

Thanks,

Saturday, January 13, 2018

Dialog date field and OK CANCEL in job AX 2012

public static void dialogDate()
{
    Dialog      dialog;
    DialogField field;
    ;
    dialog = new Dialog("Submitted Date");
    dialog.addText("Select submitted date:");
    field = dialog.addField(identifierStr(TransDate));

    dialog.run();
    if (dialog.closedOk())
    {
        info(field.value());
    }
}

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...