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");

This is code sample to Get or split values from range in Ax 2012. For example you provided range from 100 to 110 and want both value start value and end value in some variable then you can use container to split range values. str range; str startValue,endValue; List ledgerRange= new list(Types::String); ListIterator listiterator; container con; range = "100..110"; rangevalue= strSplit(range,".."); listiterator = new listiterator(rangevalue); while(listiterator.more()) { con += listiterator.value(); listiterator.next(); } startValue = conpeek(con,1); endValue = conPeek(con,3); info(startValue); info(EndValue);    

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)