Skip to main content

Some important function which used in axapta

Get current user id
str s;
  ;
  s = curuserid();
  print "Current user ID is " + s;
  pause;


Field id to field Name
str name;
  tableid _tableId;
  fieldid _fieldid;
  ;

  _tableId = tablename2id("Address");
  _fieldId = fieldname2id(_tableId, "Name");
  name = fieldid2pname(_tableId, _fieldid);
  print name;
  pause;

To get next month of given date
  date d;
      ;
      d = nextmth(today()); //For example, NextMth(29\02\1996) returns the date '29\03\1996', but NextMth(31\01\1996) returns the date '29\02\1996' (leap year).
      print "Next month is " + date2str(d, 2, 2, -1, 2, -1, 4); 
      pause;


To delete string from string
str s;
  ;
  s = strdel("TESTstring", 5, 6);
  print s;
  pause;

Find string using strfind
int i;
  ;
  i = strnfind("test", "s", 3, 4);
  print "i = " + int2str(i);


scan string from string using strscan
int i;
  ;
  i = strscan("Teststring", "string", 4, 6);
  print "i = " + int2str(i);
  pause;

Popular posts from this blog

strScan and Find a first occurrence of a string in a string using x++

strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));

Get record from table on the basis of field id in Microsoft dynamics axapta x++

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole