Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

To Remove spaces from Text you can get idea from below code sample. Here we are update name fields which include spaces on right and left side . Dirpartytable Dirpartytable; Name Name; ; while select forUpdate Dirpartytable { ttsBegin; Name= strRTrim(strLTrim(Dirpartytable.Name)); Dirpartytable.Name = Name; Dirpartytable.doUpdate(); ttsCommit; } info("Done");

To get AOT element in current layer by code in axapta you can  get help from below code. You can get other layer element by change enum value of utillevel. UtilElements _UtilElements; while select _UtilElements where _UtilElements.recordType == UtilElementType::ExtendedType && _UtilElements.utilLevel == global::currentAOLayer() { info(strfmt("%1",_UtilElements.name)) ; }

You can use Not Exists Join in Axapta 2012 following way. LedgerTable ledgerTable; LedgerTrans ledgerTrans; while select AccountNum, Name from ledgerTable notExists join * from ledgerTrans where (ledgerTable.AccountNum == ledgerTrans.AccountNum)