Number sequence farmework overview in Dynamics AX 2012

For this demo, I will create New module along with NumberSequence, about creating Number Sequence without module you also use same steps just leave some steps base on Design picture above.

Create ETD ContosoId extends num datatype.

Create Contoso Table with ContosoId field.

Create a new enum value Contoso in BaseEnum NumberSeqModule.

This value will be used to link number sequence to the module and to restrict displayed number sequence by module in Form.

Create NumberSeqModuleXXX class

Create a new NumberSeqModuleXXX class, such as NumberSeqModuleContoso, which extends the NumberSeqApplicationModule class. The sample code for creating this class is as follows:

{% highlight csharp %} public class NumberSeqModuleContoso extends NumberSeqApplicationModule { }

protected void loadModule() { NumberSeqDatatype datatype = NumberSeqDatatype::construct(); ;

/* Contoso Id */
datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);


public NumberSeqModule numberSeqModule() { ; return NumberSeqModule::Contoso; } {% endhighlight %}

Use of the DataArea segment in Step 4 to describe the default segment for the extended data types used for ContosoId.

Note In Microsoft Dynamics AX 2009, number sequence references could be initialized by restarting the Application Object Server (AOS). In Microsoft Dynamics AX 2012, the initialization of references to populate the NumberSequenceDatatype and NumberSequenceParameterType tables has moved to the initialization checklist. To initialize the newly created references, run a job that executes the LoadModule method likes below.

{% highlight csharp %} static void loadNumSeq (Args _args) { //define the class variable NumberSeqModuleContoso seqMod = new NumberSeqModuleContoso (); //load the number sequences that were not generated seqMod.load(); } {% endhighlight %}

You can also reinitialize all references by running a job that executes the LoadAll method in the NumberSequenceModuleSetup class. However, for reinitializing all references, you must ensure that there are no existing number sequences already defined in the system.

Then run the wizard in Organization Administration > CommonForms > Numbersequences > Numbersequences > Generate > run the wizard.

Create a Number sequences page in the parameters form of the new module.

You need to Create ContosoParameters Table along with form, See existing forms such as CustParameters or LedgerParameters for examples of the implementation.

These forms are using DetailsFormMaster form parten as Best Practice for Setup form.

  • Add field key, Extends from ParametersKey

  • Properties on Field key Visible = false, AllowEdit = false, AllowEditOnCreate = false

  • Create index name Key with AllowDuplicate = No.

  • Set table properties.

  • TableContent = Default data

  • ConfigurationKey

  • CacheLookup = Found

  • TableGroup = Parameter

  • PrimaryKey = Key

  • ClusterKey = Key

The sample code for creating method this table as below:

{% highlight csharp %} void delete() { throw error("@SYS23721"); } public void initValue() { ; super(); // Key is set to mandatory so set it to 1 this.Key = 1; } static ContosoParameters find(boolean _forupdate = false) { ContosoParameters parameter;

if (_forupdate)

select firstonly RecId from parameter
	where parameter.Key == 1;

if (!parameter && !parameter.isTmp())

return parameter;

} client server static NumberSeqModule numberSeqModule() { ; return NumberSeqModule::Contoso; } public server static NumberSequenceReference numRefContosoId() { ; NumberSeqScopeFactory::CreateDataAreaScope(curext()); return NumberSeqReference::findReference(extendedtypenum (ContosoId));

} {% endhighlight %}

Note This form can only be used for references that have a scope of DataArea. The administration forms described in the Setup and Administration of number sequences section can be used for references that have any scope. These forms can be found in Organization Administration > Common > Number Sequences

The data source of Parameters form likes picture below, you can also refer to CustParameters form for design.

Code example for form methods:

{% highlight csharp %} public class FormRun extends ObjectRun { NumberSeqReference numberSeqReference; boolean runExecuteDirect; TmpIdRef tmpIdRef; NumberSeqScope scope; NumberSeqApplicationModule numberSeqApplicationModule; container numberSequenceModules; }

void init() { ; this.numberSeqPreInit(); super(); ContosoParameters::find(); this.numberSeqPostInit(); }

void numberSeqPostInit() { numberSequenceReference_ds.object(fieldNum(NumberSequenceReference, AllowSameAs)).visible(numberSeqApplicationModule.sameAsActive()); referenceSameAsLabel.visible(numberSeqApplicationModule.sameAsActive()); }

void numberSeqPreInit() { ; runExecuteDirect = false;

numberSequenceModules       = [NumberSeqModule::Contoso];
numberSeqApplicationModule  = new NumberSeqModuleContoso ();
scope                       = NumberSeqScopeFactory::createDataAreaScope();
NumberSeqApplicationModule::createReferencesMulti(numberSequenceModules, scope);


} {% endhighlight %}

Code example for NumberSequenceReference data source methods

{% highlight csharp %} void removeFilter() { ; runExecuteDirect = false; numbersequenceReference_ds.executeQuery(); }

void executeQuery() { if (runExecuteDirect) { super(); } else { runExecuteDirect = true; this.queryRun(NumberSeqReference::buildQueryRunMulti(numberSequenceReference, tmpIdRef, numberSequenceTable, numberSequenceModules, scope)); numbersequenceReference_ds.research(); } } {% endhighlight %}

Set number sequence in Contoso Table

{% highlight csharp %} private void setContosoId() { NumberSeq num; NumberSequenceReference numberSequenceReference; ; numberSequenceReference = CVRParameters::numRefContosoId();

if (numberSequenceReference)
	num = NumberSeq::newGetNum(numberSequenceReference);
	this.Id = num.num();

} {% endhighlight %}

Optional method – in case you don’t want to expose Number sequence on Form Level

{% highlight csharp %} public void initValue() { ; super();

// Initialise the title id
this. setContosoId ();


public void insert() { ; if(!this.Id) { this. setContosoId (); }


} {% endhighlight %}

From now on you can create new record in Contoso Table with number sequence.

How to use on form level (In case you don’t want to expose NS in Table Level)

  • In the class declaration of the form that will be accessing data, add a variable declaration for the number sequence handler. The following example shows the variable definition for a number sequence handler.

{% highlight csharp %} public class FormRun extends ObjectRun { NumberSeqFormHandler numberSeqFormHandlerContosoId; } {% endhighlight %}

  • Add the NumberSeqFormHandler method to the form. The code in this method will create an instance of the number sequence form handler and return it.

{% highlight csharp %} public NumberSeqFormHandler numSeqFormHandlerContosoId() { if (!numberSeqFormHandlerContosoId) { numberSeqFormHandlerContosoId = NumberSeqFormHandler::newForm(ContosoParameters:: numRefContosoId().NumberSequenceId, element, Contoso_ds, fieldNum(Contoso, ContosoId) ); } return numberSeqFormHandlerContosoId; } {% endhighlight %}

  • Add create, delete, and write methods to the data source of the table that contains the field for which the number sequence is being used. The following code examples show these methods that are added to the data source for the Contoso table to support the number sequence for the ContosoId field.

{% highlight csharp %} public void create(boolean _append = false) { //before create, (ensure the number seuence has not run out of numbers) element.numSeqFormHandlerContosoId().formMethodDataSourceCreatePre();

// start: inherited table code
// we need to let the create happen so the user can
// choose the type

//number sequence, create action, (get next number)

} public void delete() { //release the number sequence value. element. numSeqFormHandlerContosoId().formMethodDataSourceDelete();

//delete the record

} public void write() { super(); element. numSeqFormHandlerContosoId().formMethodDataSourceWrite(); }

public boolean validateWrite() { boolean ret; ret = super(); ret = element.numberSeqFormHandler().formMethodDataSourceValidateWrite(ret) && ret; if (ret) { Contoso.validateWrite(); } return ret; } Link Active() public void linkActive() { ; element.numberSeqFormHandler().formMethodDataSourceLinkActive(); super(); } {% endhighlight %}

Continuous sequence

To avoid having gaps for continuous sequence you should add this code to the delete of the table.

{% highlight csharp %} public void delete() { super(); NumberSeq::releaseNumber(ContosoParameters::numRefContosoId().NumberSequenceId, this.ContosoId); } {% endhighlight %}

Testing Number sequence by Job

{% highlight csharp %} static void Max_numberSeqRefCustAccount(Args _args) { NumberSequenceReference numberSeqRefCustAccount = CustParameters::numRefCustAccount(); NumberSeq numSeqCustAccount; try { //Use the TTS level to decide whether sequence is consumed or not. ttsBegin; if (numberSeqRefCustAccount) { numSeqCustAccount = NumberSeq::newGetNum(numberSeqRefCustAccount); if (numSeqCustAccount) { info(numSeqCustAccount.num()); } } ttsCommit; } catch (Exception::Error) { info(“Caught ‘Exception::Error’."); } } {% endhighlight %}

Thank you for reading!