Monday, September 18, 2017

Employee/Worker status in AX 2012

HcmEmployment hcmEmployment;

select firstonly RecId from hcmEmployment where hcmEmployment.Worker == HcmWoker.RecId;
    if (hcmEmployment.RecId != 0)
    {
        HcmWorkerStatus::Employed;
    }
    else
    {
        hcmEmployment.clear();
        select firstonly ValidTimeState(now, maxDateTime) hcmEmployment
        where hcmEmployment.Worker == this.RecId && hcmEmployment.ValidFrom > now;
        if (hcmEmployment.RecId != 0)
        {
            HcmWorkerStatus::Pending;
        }
        else
        {
            HcmWorkerStatus::Terminated;
        }
    }

No comments:

Post a Comment

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...