Microsoft Dynamics Ax: Number Sequence Framework [AX 2012]

Updated: December 8, 2011

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Microsoft Dynamics AX has a number sequence framework to generate alphanumeric number sequences that are used to identify transaction documents such as sales orders. This topic describes how to implement the number sequence framework for a new module in Microsoft Dynamics AX. The topic will show how a number sequence was implemented for the Facility Management (FCM) sample module. (Some of the following steps might be irrelevant if they have been previously performed for other purposes in your new Microsoft Dynamics AX module.)

For additional information about the number sequence framework for Microsoft Dynamics AX 2012, see the Number Sequence Framework Whitepaper on the Microsoft Download Center.

Creating a Parameter Table and a Number Sequence Module Class

The first step to implementing number sequences for a new module is to create a parameter table and a number sequence module class.

Create a parameter table for the new module: MyModuleParameters. For the Facility Management module, this table is named FCMParameters. The table must, at a minimum, contain a Key field and a find method. The delete and update methods must be overridden. These methods can be copied from one of the other parameter tables, such as BOMParameters.

Create an enumerated value that represents all of the number sequences for the module by adding a new element to theNumberSeqModule base enum. For the Facility Management module, the FCM element was added to the base enum.

Note
Configuration keys are used to detect the active number sequence references in your Microsoft Dynamics AX installation. If the configuration key is not enabled, the module’s number sequence references are not displayed in the general References form. The user cannot see references from modules that are not enabled.

Create a new number sequence class named NumberSeqModule MyModule. This class must extend theNumberSeqApplicationModule class. For the Facility Management module, this class is namedNumberSeqModuleFacilityManagement.
Add the numberSeqModule method to the new number sequence class. This method must return the element for your module from the NumberSeqModule base enum. The following code shows how this is done for the Facility Management module.
X++
public NumberSeqModule numberSeqModule() { return NumberSeqModule::FCM; }
Implement the numberSeqModule method for the parameters table.

Copy this method from one of the other parameter tables such as BOMParameters. Change the return value of thenumberSeqModule method so that it references the number sequence for your module.

For example, the numberSeqModule method from the FCMParameters table returns NumberSeqModule::FCM (the FCM element of NumberSeqModule).
Create a form to display the new parameter table.

It is important that the functionality of number sequence references is copied exactly from one of the other parameter forms (for example, CustParameters). Remember to change the names of the called methods.
The new number sequence framework is now established.

Making Number Sequence Data Types

Next, you will make number sequence data types for the number sequences you are creating for your new module.

In your number sequence module class, override the loadModule method.

In this new method, specify the characteristics of each number sequence data type that you need in the new module. For example, the following code is from the loadModule method of the NumberSeqModuleFacilityManagement class. It defines a number sequence that is used by the Facility Management module to provide work order numbers.

X++

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

    /* Work Order Number */
    datatype.parmDatatypeId(extendedTypeNum(WorkOrderNum));
    datatype.parmReferenceHelp("Unique identifier for work orders");
    datatype.parmWizardIsContinuous(false);
    datatype.parmWizardIsManual(NoYes::No);
    datatype.parmWizardIsChangeDownAllowed(NoYes::No);
    datatype.parmWizardIsChangeUpAllowed(NoYes::No);
    datatype.parmSortField(1);
    datatype.parmWizardHighest(999999);

    datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);
    this.create(datatype);
}

Tip
For details about how to set the properties for a data type, see the descriptions of the methods for the NumberSeqDatatype Class.

Loading Number Sequence Information for a Module

After you create the number sequence module class and define the number sequence data types for your module, you must load the number sequence information into Microsoft Dynamics AX. This must be done only one time. Typically, this is a step that is performed when the module is installed.

A simple way to load the number sequence information for a module is to create a job in the AOT that creates an instance of the number sequence module and runs the loadModule() method. The following example is the InstallFacilityManagement job in the AOT. It creates an instance of the NumberSeqModuleFacilityManagement class, and then calls the loadModule() method. The job must be run only one time by the person who is installing the Facility Management module.

X++

static void InstallFacilityManagement(Args _args)
{
    NumberSeqModuleFacilityManagement n = new NumberSeqModuleFacilityManagement();

    n.loadModule();
}

Generating Number Sequences

After the number sequence information has been loaded for the module, you must use the Set up number sequences wizard to generate the number sequences that you defined.

In the Microsoft Dynamics AX client, choose Organization administration > Common > Number sequences > Number sequences.
Click Generate to open the Set up number sequences wizard.
Complete the wizard to create the number sequences for your new module.

Accessing Your New Number Sequence Data Types

For each data type specified in NumberSeqModule MyModule .loadModule, you must create a static method on your parameter table. Create the MyModule Parameters::numRef MyDataType method.

Copy a numRef method from one of the other parameter tables.
Change the name of the method to numRef MyDataType.
Add code that will return a number sequence reference object for that specific data type. For example, the following method retrieves the number sequence reference object that is used for the WorkOrderNum field. This is the number sequence that is defined for the Facility Management sample application.
X++
client server static NumberSequenceReference numRefWorkOrderNum() { NumberSeqScope scope = NumberSeqScopeFactory::createDataAreaScope(curext()); return NumberSeqReference::findReference(extendedtypenum(WorkOrderNum), scope); }

Using Number Sequences in an Application

To use the number sequence for a form in Microsoft Dynamics AX or in Enterprise Portal, you will typically add code to the data source for the form or data set. You can also retrieve a number sequence value directly in code. For example, the following example retrieves the next available work order number from the number sequence used for the WorkOrderNum field and displays it in the Infolog.

X++

Info(NumberSeq::newGetNum(FCMParameters::numRefWorkOrderNum()).num());

Forms

To use a number sequence for a form in Microsoft Dynamics AX, follow these steps.

In the classDeclaration method 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.
X++
public class FormRun extends ObjectRun { NumberSeqFormHandler numberSeqFormHandler; }

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. The following example shows the code that returns the number sequence form handler for the FCMWorkOrders form of the Facility Management sample module.

X++

NumberSeqFormHandler numberSeqFormHandler()
{
    if (!numberSeqFormHandler)
    {
        numberSeqFormHandler = NumberSeqFormHandler::newForm(
            FCMParameters::numRefWorkOrderNum().NumberSequenceId,
             element,
             FCMWorkOrders_DS,
             fieldnum(FCMWorkOrders, WorkOrderNum)); 
    }
    return numberSeqFormHandler;
}

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 FCMWorkOrders table to support the number sequence for the WorkOrderNum field.

X++

public void create(boolean _append = false)
{
    element.numberSeqFormHandler().formMethodDataSourceCreatePre();
    super(_append);
    element.numberSeqFormHandler().formMethodDataSourceCreate();
}

public void delete()
{
    element.numberSeqFormHandler().formMethodDataSourceDelete();
    super();
}

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

Enterprise Portal

To use a number sequence for a form in Enterprise Portal, follow these steps.

In the classDeclaration method of the data set 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.
X++
public class DatSetRun extends ObjectRun { NumberSeqFormHandler numberSeqFormHandler; }

Add the NumberSeqFormHandler method to the data set. The code in this method will create an instance of the number sequence form handler and return it. The following example shows the code that returns the number sequence form handler for the FCMWorkOrderAddEdit data set of the Facility Management sample module.

X++

NumberSeqFormHandler numberSeqFormHandler()
{
    if (!numberSeqFormHandler)
    {
        numberSeqFormHandler = NumberSeqFormHandler::newForm(
            FCMWorkOrders::numRefFCMWorkOrders().NumberSequenceId,
            element,
            FCMWorkOrders_DS,
            fieldnum(FCMWorkOrders, WorkOrderNum));
    }
    return numberSeqFormHandler;
}

Add create, delete, and write methods to the data source for the data set 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 FCMWorkOrders table to support the number sequence for the WorkOrderNum field.
X++
public void create(boolean _append = false) { element.numberSeqFormHandler().formMethodDataSourceCreatePre(); super(_append); element.numberSeqFormHandler().formMethodDataSourceCreate(); } public void delete() { element.numberSeqFormHandler().formMethodDataSourceDelete(); super(); } public void write() { element.numberSeqFormHandler().formMethodDataSourceWrite(); super(); }

Reset AOS if needed

After following the step by step instructions I got an error while opening the parameters form or generating number sequences, it couldn't find the baseEnum value on the map.

SOLUTION: Just reset AOS and it will be fine.

Loading the number sequence from the parameters form of the module

You could consider placing the call to load in the find method of your parameter table.

If the find method must create the parameter record because it does not already exist, I think it is also safe to assume that the related number sequence has not been loaded:
...
    if (!parameter && !parameter.isTmp())
    {
        Company::createParameter(parameter);        // Load related number sequences

        // Load related number sequences
        new NumberSeqModuleMyModule().load();
    }
...

That would eliminate the need for loading it manually.

Loading Number Sequence Information for a Module

In the x++ code the call should be to load not loadmodule, because the loadmodule method is protected.

Number Sequence Framework [AX 2012]

Forms

Enterprise Portal

Reset AOS if needed

No comments:

Post a Comment