Usecase
Some of the customers want to use multiple number sequence for
single table that is not currently available in AX 2009.
i.e. In invent module to create different types of items one
required to use different sequence, here addon comes into picture.
Technical
Section
Create new class “NumberSeqDialog” and add methods as listed
below.
class
NumberSeqDialog extends RunBase
{
NumberSequenceCode parentCode;
NumberSequenceCode selectedCode;
DialogField dialogFieldNumberSeq;
Dialog dialog;
}
public
Object dialog()
{
;
dialog = super();
dialog.caption("Select number
sequance");
dialog.allowUpdateOnSelectCtrl(true);
dialogFieldNumberSeq =
dialog.addField(TypeID(NumberSequenceCode),"Select Number Sequence:
");
return dialog;
}
public void
dialogPostRun(DialogRunbase _dialog)
{
;
_dialog.formRun().controlMethodOverload(true);
_dialog.formRun().controlMethodOverloadObject(this);
super(_dialog);
}
Below method
will give you answer of populer question
“How to override Control’s event method?”
Also gives
you an idea of
“How to create lookup field on Dialog?”
public void
Fld1_1_lookup()
{
Object control =
dialog.formRun().controlCallingMethod();
;
NumberSequenceTable::lookupNumberSequenceCode(control,
this.parmParentCode());
}
public
boolean getFromDialog()
{
;
this.selectedNumberSeqCode(dialogFieldNumberSeq.value());
return true;
}
Below to
method say, if you don’t want to use “pack unpack” create me like this!!!
container
pack()
{
return connull();
}
boolean
unpack(container _packedValues)
{
return true;
}
NumberSequenceCode
parmParentCode(NumberSequenceCode _parentCode = parentCode)
{
parentCode = _parentCode;
return parentCode;
}
NumberSequenceCode
selectedNumberSeqCode(NumberSequenceCode _selectedCode = selectedCode)
{
selectedCode = _selectedCode;
return selectedCode;
}
Modify NumberSequenceTable table
Add below fields
to NumberSequenceTable
“NumberSequenceParent” to set parent Number
sequence. EDT, which will refer to NumberSequenceCode.
“Search for
parent” to NoYes type enum field.
So finally
it will look like,
Modify “NumberSeqFormHandler” class
Create
instance of above class in “NumberSeqFormHandler” class.
Put below
code in to newForm method
if(NumberSequenceTable::find(_numberSequenceCode).SearchForParent)
{
numberSeqDialog = new
NumberSeqDialog();
numberSeqDialog.parmParentCode(_numberSequenceCode);
if(numberSeqDialog.prompt())
{
_numberSequenceCode =
numberSeqDialog.selectedNumberSeqCode();
}
}
So after
adding above code your newForm method will look like,
static
NumberSeqFormHandler newForm(NumberSequenceCode _numberSequenceCode,
ObjectRun
_callerForm,
FormDataSource
_formDataSource,
fieldId _fieldIdNum,
boolean
_dontThrowOnMissingRefSetUp = false
)
{
NumberSeqFormHandler numberSeqFormHandler;
NumberSeqDialog numberSeqDialog;
;
if (!_formDataSource || !_fieldIdNum)
throw
error(strfmt("@SYS70841",funcname()));
//<Intech>
if(NumberSequenceTable::find(_numberSequenceCode).SearchForParent)
{
numberSeqDialog = new
NumberSeqDialog();
numberSeqDialog.parmParentCode(_numberSequenceCode);
if(numberSeqDialog.prompt())
{
_numberSequenceCode =
numberSeqDialog.selectedNumberSeqCode();
}
}
//</Intech>
numberSeqFormHandler =
NumberSeqFormHandler::construct(_formDataSource);
numberSeqFormHandler.parmNumberSequenceCode(_numberSequenceCode);
numberSeqFormHandler.parmFormDataSource(_formDataSource);
numberSeqFormHandler.parmFieldIdNum(_fieldIdNum);
numberSeqFormHandler.parmDontThrowOnMissingRefSetUp(_dontThrowOnMissingRefSetUp);
return numberSeqFormHandler;
}
Direction
of use
First of all you have to decide on which form you want to
use multiple number sequence. Let’s say you have chosen InventTable and want to
create items on item details page with different number sequence.
Next step is, go to Basic Setup> Number Sequences. Find which number sequence is currently y in
use to create new item. Let’s say its “Inv_60”, Remember this Number Sequence
will be treat as BASE or say PARENT
number sequence.
Now, create different number sequences, as I have created “RM_61”,
“FG_62” and “SFG_63” . Select “Inv_60” against
these create number sequences.
One more thing required to active this functionality, that
is “Search for parent” option must be ticked on setup tab for “Inv_60” number
sequence.
Have you done with all above steps?? If yes, you are ready
to use this addon, Just go to Item details page. While creating new item it
will search Three number sequences 61 to 63 created above.
and pop up with box shown below.
Select number
sequence which you want to use for current item.
Furthermore, you want to give Number manually along with
auto number sequence. Just select any of the above (61 to 63) as manually. You will be having auto + manually number sequences!!!
Any suggestions and questions are Welcomed.
Happy DAXing J
