Monday, November 25, 2013

Create location using X++

void CreateLocation(WMSAisleId aisleNo)
{
  WMSAisle WMSaisle;
   wmslocation _wmslocation;
  ;
   try
   {
      select forupdate WMSaisle where WMSaisle.aisleId == aisleNo && WMSaisle.inventLocationId == inventLocationId ;
      if(WMSaisle.RecId==0)
      {
         WMSaisle.clear();
         WMSaisle.initValue();
         WMSaisle.inventLocationId= inventLocationId;
         WMSaisle.aisleId= aisleNo;
         WMSaisle.name= strfmt("%1,aisle%2",inventLocationId,aisleNo);
         WMSaisle.insert();
      }
  }
    catch
    {
    Error(strfmt("Isle already exist %1,%2", inventLocationId,aisleNo));
    }
   select firstonly _wmslocation where _wmslocation.inventLocationId ==inventLocationId && _wmslocation.wMSLocationId == wmsLocationId;
          if(_wmslocation.RecId== 0)
          {
          _wmslocation.clear();
          _wmslocation.initValue();
          _wmslocation.aisleId=aisleNo;
          _wmslocation.wMSLocationId= wmsLocationId;
          _wmslocation.inventLocationId = inventLocationId;
           _wmslocation.insert();
          }
}

No comments:

How to identify the user that was used to change an object from AOT in AX2012

Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...