How to Create new module in ax 2012

New Module:

1- First of all, create a "Parameter" table in "Table" node of AOT (Like – “OfcAdminParameters”).

2- Create "Key" field in that table.

3- Create "Index" for "Key" field.

4- Create several methods in "Methods" node of "Parameter" table in AOT. (Like - Delete, Update, exist, and Find, NumberSeqModule)
************************************************************************************
Methods –on Parameter table level 
Delete:
Void delete ()
{
    Throw error ("@SYS23721");
}
Update:
Void update ()
{
    Super ();
    //just write flush Parameter table name
    Flush OfcAdminParameters;
}
Exist:
Static Boolean exist ()
{
    Return (select firstonlyRecId from OfcAdminParameters).RecId != 0;
}
Find:
//AOSRunMode::CalledFrom
Static OfcAdminParameters find (Boolean _forupdate = false)
{
    OfcAdminParameters parameter;

parameter.selectForUpdate(_forupdate);

    Select firstonlyparameter Index Key     Where parameter.Key == 0;
    If (!parameter&& !parameter.isTmp())
    {
        Company::createParameter(parameter);
    }
    Return parameter;
}



NumberSeqModule:-
Static client server NumberSeqModulenumberSeqModule ()
{
    Return NumberSeqModule::OfcMgmt;
}

// If you want to create another module then -
5- Now, add an element to "NumberSeqModule"BaseEnum.
*************************************************************************************
6- Create a new Number Sequence Class Named "NumberSeqModuleModuleName"

7- Add a method "NumberSeqModule" to that class.

Method’s for NumberSeqModuleModuleName class – 
1.Class Declaration:-
public class NumberSeqModuleOfficeManagement extends NumberSeqApplicationModule
{

}

2.NumberSeqModule:-
Public NumberSeqModulenumberSeqModule ()
{
   Return NumberSeqModule::OfcMgmt;
}
*************************************************************************************
8- Create a "Form" to display the new “parameter table's data”.
9- In Class "NumberSeqModuleModuleName" add override method "load module".
Coding  of Load Module =>
  Public void loadModule ()
  {
NumberSeqDatatypedatatype = NumberSeqDatatype::construct ();
    ;
    //Gulshan
datatype.parmDatatypeId(extendedtypenum(CourierID));
datatype.parmReferenceHelp(literalstr("@SYS32633"));
datatype.parmWizardIsContinuous(true);
datatype.parmWizardIsManual(NoYes::No);
datatype.parmWizardIsChangeDownAllowed(NoYes::No);
datatype.parmWizardIsChangeUpAllowed(NoYes::No);
datatype.parmWizardHighest(99999);
datatype.parmSortField(1);
this.create (datatype);
    }


10-To load "NumberSeqLoadModule" information for module, create “Job”.
Coding for Job =>
Public static void InstallOfficeManagement (Args _args)
{
NumberSeqModuleOfficeManagement n = new NumberSeqModuleOfficeManagement ();
   // NumberSeqModuleFacilityManagement n = new NumberSeqModuleFacilityManagement ();
n.loadModule ();
    Print ("Job Executed Successfully");
    Pause;
}
11-Now Setup "Number Sequence" just follows these steps;
    a) Go to CEU> Organization Administration
    b) Then Number Sequences > Number Sequences
    c) Click on "Number Sequence" in "New" tab.
    d) Fill the information in "Identification" tab.
    e) In "Scope parameters" tab select (Shred/Company)
    f) In "Segments" tab set the length of number sequence.
    g) Now in "General" setup click "continuous" option.
    h) Save and generate.
i) Click "close"

12-Now add "NumRef" method in "parameter table" name “NumRefEDTname”.Coding for NumRef Method :-
static client server NumberSequenceReferencenumRefCourierID()
{
returnNumberSeqReference::findReference(extendedTypeNum(CourierID));
}

13-In class declaration of a form add =>
 Public class FormRun extends ObjectRun
{
NumberSeqFormHandlerNumberSeqFormHandler;
}
14-Add "NumberSeqFormHandler" method to the form.
Coding for NumberSeqFormHandler Method =>
NumberSeqFormHandlerNumberSeqFormHandler ()
{
    If (!numberSeqFormHandler)
    {
NumberSeqFormHandler = numberseqformhandler::newForm(OfcAdminParameters::numrefCourierTransID().NumberSequenceId,element,Courier_Invoice_Table_1_ds,fieldNum(Courier_Invoice_Table, CourierTransID));
    }
    Return NumberSeqFormHandler;
}

15-Write "close" method in form methods node and "link active, Validate write, Write, Delete" methods on methods     node of data source of form.
Coding  for “Close” Method=>
void close()
{
if (NumberSeqFormHandler)
    {
numberSeqFormHandler.formMethodClose();
    }
super();
}

Coding  fordatasource method’s:-
LinkActive =>
public void linkActive()
{
    ;
element.numberSeqFormHandler().formMethodDataSourceLinkActive();
super();
}

ValidateWrite :-
publicbooleanvalidateWrite()
{
boolean         ret;
ret = super();
ret = element.numberseqformhandler().formMethodDataSourceValidateWrite(ret) && ret;
if (ret)
    {
        Courier_Invoice_Table_1.validateWrite();
    }
return ret;
}

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

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

Create =>
public void create(boolean _append = false)
{
    ;
super(_append);
    //In the below line we have to write datasourcename.fieldname (very very important for number sequence)
   Courier_Invoice_Table_1.courierTransID = NumberSeq::newGetNum(OfcAdminParameters::numrefCourierTransID(),true).num();
    Courier_Invoice_Table_1.InvoiceNumber = NumberSeq::newGetNum(OfcAdminParameters::numrefInvoiceNumber(),true).num();
    Courier_Invoice_Table_1.VoucherNumber = NumberSeq::newGetNum(OfcAdminParameters::numrefVoucherNumber(),true).num();

}
........................................................
Other scenario Table Methods:-
static FleetParameters find(boolean _forupdate = false)
{
    FleetParameters  parameter = null;
    ;

    parameter.selectForUpdate(_forupdate);

    select firstonly parameter index Key where parameter.Key == 0;

    if (!parameter && !parameter.isTmp())
    {
        Company::createParameter(parameter);
    }

    return parameter;
}

public static NumberSeqModule numberSeqModule()
{
    return NumberSeqModule::FleetMngmt;
}

static client server NumberSequenceReference numRefFleetNum()
{
    return NumberSeqReference::findReference(extendedTypeNum(fleetnumber));
}

static client server NumberSequenceReference numRefRouteId()
{
    return NumberSeqReference::findReference(extendedTypeNum(RouteId));
}
........................................................................................................................................
FOrm Methods
 public class FormRun extends ObjectRun
{
    #HRMConstants

    NumberSeqReference          numberSeqReference;
    boolean                     runExecuteDirect;
    TmpIdRef                    tmpIdRef;
    NumberSeqScope             scope;
    NumberSeqApplicationModule numberSeqApplicationModule;
    container                  numberSequenceModules;
}

public void close()
{
 
    super();
}
public void init()
{
    this.numberSeqPreInit();
    super();
 
    this.numberSeqPostInit();
}

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

    referenceSameAsLabel.visible(numberSeqApplicationModule.sameAsActive());
}

void numberSeqPreInit()
{
    NumberSeqModule         module;
    NumberSeqGlobal         global;
    Map                     numseqmap;
    NumberSeqModuleFleet    modulefleet = new NumberSeqModuleFleet();
    ;
    runExecuteDirect = false;
    numberSequenceModules = [NumberSeqModule::FleetMngmt];
    numberSeqApplicationModule = new NumberSeqModuleFleet();
    scope = NumberSeqScopeFactory::createDataAreaScope();
    module = numberSeqApplicationModule.numberSeqModule();
    Appl.numberSeqGlobal().numberSeqModulesMap().insert(NumberSeqModule::FleetMngmt,modulefleet);
    NumberSeqApplicationModule::createReferences(NumberSeqModule::FleetMngmt);
    tmpIdRef.setTmpData(NumberSequenceReference::configurationKeyTableMulti(numberSequenceModules));
}

FORM Number sequence referrence datasource methods:
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();
    }
}

Number seq datasource table -> number sequenceid field  methods

public Common resolveReference(FormReferenceControl _formReferenceControl)
{
     NumberSequenceCode code = _formReferenceControl.filterValue(
        AbsoluteFieldBinding::construct(fieldStr(NumberSequenceTable, NumberSequence),
        tableStr(NumberSequenceTable))).value();
    return NumberSequenceTable::findByNaturalKey(code, scope.getId(true));
}

public Common lookupReference(FormReferenceControl _formReferenceControl)
{

    NumberSequenceTable     selectedRecord;
    SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(NumberSequenceTable), _formReferenceControl, true);
    Query lookupQuery;
    ;
    sysTableLookup.addLookupfield(fieldNum(NumberSequenceTable, NumberSequence));
    lookupQuery = new Query();
    lookupQuery.addDataSource(tableNum(NumberSequenceTable)).addRange(fieldNum(NumberSequenceTable, NumberSequenceScope)).value(queryValue(scope.getId(true)));
    sysTableLookup.parmQuery(lookupQuery);
    selectedRecord = sysTableLookup.performFormLookup();
    return selectedRecord;
}

---------------------------------------------------------------------------------------------------------------------------------------------------
CLass  Methods:

public class NumberSeqModuleFleet extends NumberSeqApplicationModule
{

}
protected void loadModule()
{
    NumberSeqDatatype datatype = NumberSeqDatatype::construct();
    ;
    datatype.parmDatatypeId(extendedtypenum(RouteId));
    datatype.parmReferenceHelp("Route ID");
    datatype.parmWizardIsContinuous(true);
    datatype.parmWizardIsManual(NoYes::No);
    datatype.parmWizardIsChangeDownAllowed(NoYes::No);
    datatype.parmWizardIsChangeUpAllowed(NoYes::No);
    datatype.parmWizardHighest(999);
    datatype.parmSortField(20);
    datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);
    this.create(datatype);


    datatype.parmDatatypeId(extendedtypenum(FleetNumber));
    datatype.parmReferenceHelp("Fleet Number");
    datatype.parmWizardIsContinuous(true);
    datatype.parmWizardIsManual(NoYes::No);
    datatype.parmWizardIsChangeDownAllowed(NoYes::No);
    datatype.parmWizardIsChangeUpAllowed(NoYes::No);
    datatype.parmWizardHighest(999);
    datatype.parmSortField(21);
    datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);
    this.create(datatype);
}

Public NumberSeqModule numberSeqModule()
{
   Return NumberSeqModule::FleetMngmt;
}

Comments

Post a Comment

Popular posts from this blog

Write/ Read to Excel Sheet

File exists in a Directory:  static void FileExists(Args _args) { str filePath = @”C:\\vani.pdf”; ; if(WinAPI::fileExists(filePath)) { WinAPI::copyFile(filePath,”C:\\1.pdf”); } } Dynamics AX X++ code to Read/Write data to excel Writing Data to Excel file   How it works 1. Use SysExcelApplication class to create excel file. 2. Use SysExcelWorkbooks and SysExcelWorkbook to create a blank workbook(by default 3 worksheets will be available). 3. Use SysExcelWorkSheets to select worksheet for writing data. 4. SysExcelCells to select the cells in the excel for writing the data. 5. SysExcelCell to write the data in the selected cells. 6. Once you done with write operation use SysExcelApplication.visible to open file. static void Write2ExcelFile(Args _args) { InventTable inventTable; SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet workshee...
Read more

Table Methods in Ax 2012

Table Methods in Ax 2012 Methods are used for adding X++ code to your application. The code in methods is also referred to as business logic. Whenever records are changed, inserted or deleted from a table various default methods are executed. We can change the default methods and by doing so we are overriding the default methods.To override a method go to the  Methods  node of a table, right click and choose  Override Method . Below are few examples of Overriding commonly used Table methods: initValue(): If we create a new record from the table browser or a form the table method initValue() is executed. It is used to set a default value for the fields.  Example (1): Let’s override intiValue for MyFirstTable and set default value for custGroupId public void initValue() { super(); this.custGroupId = "10"; } After adding this method, open table MyFirstTable  through Table browser and press ctrl+n ...
Read more

Financial Dimensions in AX 2012

Image
Today we will be exploring the new changes  related  to Financial dimensions in AX 2012. Earlier versions AX 2009, 4.0 : Ø   In older version System use to limit the creation of dimensions up to 10.  Ø   By default 3 dimensions were available in the system namely Department, CostCenter and Purpose. Ø   Technically these dimensions were controlled by Enum SysDimension and an array EDT Dimension. Ø   So If we have 3 enum elements in SysDimension, then its corresponding array elements are stored in    dimension EDT and can be referred as Dimension[0], Dimension[1]..... Ø   If you would like to store these dimension values against customized table, then simply we were adding the EDT Dimension to that Table. At  Form  level simply drag and drop field on Group then system use to  show all the array elements as string control. New version AX 2012 (6.0) :   Ø   In AX 2012(6.0), there is no ...
Read more