Skip to main content

Number Sequence creation through code in axapta

Number sequence Creation

Add method current form where number sequence needed

 NumberSeqFormHandler numberSeqFormHandler;  
 NumberSeqFormHandler numberSeqFormHandler()  
 {  
 if (!numberSeqFormHandler)  
 {  
 numberSeqFormHandler = NumberSeqFormHandler::newForm(ProdParameters::numRefSrNo().NumberSequence,element,TableName_ds,fieldnum(TableName,SrNo));  
 }  
 return numberSeqFormHandler;  
 }  
 public void delete()  
 {  
 element.numberSeqFormHandler().formMethodDataSourceDelete();  
 super();  
 }  
 public void write()  
 {  
 ;  
 ttsbegin;  
 super();  
 element.numberSeqFormHandler().formMethodDataSourceWrite();  
 ttscommit;  
 }  
 void create(boolean _append = false, boolean extern = false) //If created externally  
 {  
 ;  
 element.numberSeqFormHandler().formMethodDataSourceCreatePre();  
 super(_append);  
 if (!extern)  
 {  
 element.numberSeqFormHandler().formMethodDataSourceCreate();  
 }  
 //GODInstrumentCalibrationHeader.Responsibility =curuserid();  
 To parametertable  
 server static NumberSequenceReference numRefSrNo()  
 {  
 return NumberSeqReference::findReference(typeId2ExtendedTypeId(typeid(SrNo)));  
 }  
 Add to class Number sequence reference like production  
 numRef.dataTypeId = typeId2ExtendedTypeId(typeid(SrNo));  
 numRef.referenceHelp = literalstr("Serial No.");  
 numRef.wizardContinuous = true;  
 numRef.wizardManual = NoYes::No;  
 numRef.wizardAllowChangeDown = NoYes::No;  
 numRef.wizardAllowChangeUp = NoYes::No;  
 numRef.sortField = 7;  
 this.create(numRef);  
 //end  
 public static NumberSeqModule numberSeqModule()  
 {  
 return NumberSeqModule::Prod;  
 }  

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