Number Sequence in D365

By -

Step 1: Create EDT
Step 2: Use that EDT in the Table where it is required
Step 3: Select the Class module which you going to implement this Number seq.
class NumberSeqModuleVehicleDetails extends NumberSeqApplicationModule
{
    Protected void loadModule()
    {
        NumberSeqDatatype datatype = NumberSeqDatatype::construct();

        /* Setup application numbers */

        datatype.parmDatatypeId(extendedtypenum(VehiclId)); //your EDT
        datatype.parmReferenceLabel(literalstr("Mobile id"));//your Label
        datatype.parmReferenceHelp(literalstr("Mobile id"));
        datatype.parmWizardIsContinuous(true);
        datatype.parmWizardIsManual(NoYes::No);
        datatype.parmWizardIsChangeDownAllowed(NoYes::No);
        datatype.parmWizardIsChangeUpAllowed(NoYes::No);
        datatype.parmWizardHighest(2000);
        datatype.parmWizardfetchAheadQty(10);
        datatype.parmSortField(1);
        datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);
        this.create(datatype);
    }

    public NumberSeqModule numberSeqModule()
    {
       
        return NumberSeqModule::VehicleDetails;
    }

    [SubscribesTo(classstr(NumberSeqGlobal),delegatestr(NumberSeqGlobal,buildModulesMapDelegate))]
    static void buildModulesMapSubsciber(Map numberSeqModuleNamesMap)
    {
        NumberSeqGlobal::addModuleToMap(classnum(NumberSeqModuleVehicleDetails), numberSeqModuleNamesMap);
    }

}


Step 4 :
 Select the concern table. Create new methods as below

    public static client server NumberSequenceReference numRefVehicles()
    {
       
        return NumberSeqReference::findReference(extendedTypeNum(VehiclId)); // Your EDT
    }

Step 5 :
Create a new job with the following code and run it
    public static void main(Args _args)
    {
        NumberSeqApplicationModule::loadAll();
        info("Ok");

    }
Step 6 :
  • Select Organization administration-> Number Sequence-> Number Sequence
  • Select the module //here we select MobileDetails
  • Select the EDT you created //Surly that EDT you created will be appear here.
  • Click GENERATE
Step 7:
public class SMJ_VehiclesDialog extends FormRun
{
    NumberSeqFormHandler numberSeqFormHandler;
}
Step 8:

    NumberSeqFormHandler numberSeqFormHandler()
    {

    NumberSequenceTable  numberSeqTablesmj_Vehicles;
        if (!numberSeqFormHandler)
        {

     numberSeqTablesmj_Vehicles=                                               NumberSeqReference::findReference(extendedTypeNum(SMJ_Vehicles)).numberSequenceTable();
      if (numberSeqTablesmj_Vehicles && numberSeqTablesmj_Vehicles.Manual == NoYes::No)

      {
               numberSeqFormHandler =                       NumberSeqFormHandler::newForm(SMJ_Vehicles::numRefVehicles().NumberSequenceId,element,                                                                SMJ_Vehicles_ds, fieldNum(SMJ_Vehicles, Vehicle_Id)   );
             }
        }
        return numberSeqFormHandler;
    }

Step 9:
  • Select the Form on which that table is required.
  • Drop the table in to that form Data Source.
  • Override the datasource methods of that table with following method in that form.

// Write method

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

//Delete method

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

// Create method

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

I'm a technical developer that has been doing Microsoft Dynamics 365 development since 2018

Comments

Post a Comment

Popular posts from this blog

SSRS Report using Controller , Contract and RDP classes in D365

By -
Image
STEP 1 : Create new TEMP table STEP 2 : Create query. STEP 3 : Create a Contract class [DataContractAttribute] class SMJ_PerdiemContract {     PerdiemStatus    perdiemstatus;     [DataMemberAttribute(identifierStr(PerdiemStatus)),         SysOperationLabelAttribute ("Perdiem status"),         SysOperationHelpTextAttribute("Perdiem status"),         SysOperationDisplayOrderAttribute("1")]         public PerdiemStatus parmPerdiemStatus(PerdiemStatus _PerdiemStatus = perdiemstatus)     {         perdiemstatus = _PerdiemStatus;         return perdiemstatus;     } } STEP 4 : Create a DP class: [SRSReportQueryAttribute(queryStr(SMJ_PerdiemReport)), // query  SRSReportParameterAttribute(classStr(SMJ_PerdiemContract))]// contract class     public class SMJ_PerdiemDP extends SRSReportDataProviderBase {     SMJ_PerdiemTableTempDB  perdiemTableTempDB;     PerdiemStatus           perdiemStatus;        PerdiemRequestID        PerdiemRequ
Read more

Exporting data to Excel through X++ code

By -
             Sometimes we need to export data from Microsoft Dynamics 365 to Excel using x++ code. Through this post can see how to export data from form to excel class SMJ_ExportData {     public static void main( Args args)     {         PurchParmLine   PurchParmLine,PurchParmLineSelect;         PurchParmLine = args.record();         DocuFileSaveResult saveResult = DocuFileSave ::promptForSaveLocation( "@ApplicationPlatform:Testingexcelexport ", "xlsx" , null , "Testing excel export" );         if (saveResult && saveResult.parmAction() != DocuFileSaveAction ::Cancel)         {             saveResult.parmOpenParameters( 'web=1' );             saveResult.parmOpenInNewWindow( false );             System.IO. Stream workbookStream = new System.IO. MemoryStream ();             System.IO. MemoryStream memoryStream = new System.IO. MemoryStream ();                    using ( var package = new Of
Read more

COC for Form level method

By -
We can extend the logic of public and protected methods without having to use event handlers. COC, allows to use the method local and global variables. COC must be end with _Extension. Form level method : System search there are any extend methods , If Extend method is exist,run COC method first , next() method Invoke Standard form methods . Override Method: [ ExtensionOf ( formstr ( CustTable ))]     final class CustTableForm_Extension     {         public void init()         {             // here add the business logics             next init();             // here add the business logics         }     } Get buffers : FormRun formRun = this as   FormRun ;     FormDataSource CustTable_DS =formRun.datasource(ForomDatasourceStr(CustTable,CustTable));     CustTable custTable = CustTable_DS.Cursor();     FormControl custAccount = formRun.design().ControlName( FormControlStr ( FormName ,ControlName));        Example:
Read more

How to pass the parameter from one form to another in Dynamic365

By -
1. Create two forms with Name FormA & FormB   2. Below code is override in clicked method() of button. void  clicked() {      // Args class is usually used in Axapta for passing parameters between forms      Args             args;      FormRun          formRun;     ;     args =  new   args ();      // Our values which we want to pass to FormB      // If we want pass just simple string we can use 'parm' method of 'Args' class like     args.parm(  LeaveRequestID.text() );      // If we want pass whole record we can use 'parm' method of 'Args' class        args.record(TableName);      // Run FormB     args.name(  formstr ( FormB ) );     formRun = classFactory.formRunClass( Args );     formRun.init();     formrun.run();     formrun.wait();      super (); } 3. Now override init() method in FormB. public   void  init() {      str             anyStringValueFromCaller;      TableName       tablename;
Read more

Multi Select Lookup in SSRS Report in D365

By -
Multi Select Lookup in SSRS Report in D365 Description:-  Here we will create multi select lookup in ssrs report so we can select multiple data from lookup. Here I have given sample demonstration for how to generate multi select lookup in ssrs report. First, you must create contract class for that and create method for parameters. Contract Class: - [DataContractAttribute, SysOperationContractProcessingAttribute( classstr (SampleUIBuilder))] class SampleContract implements SysOperationValidatable {     List   ListItemId; [DataMemberAttribute( "Item Id" ),AifCollectionTypeAttribute( "Item Id" , Types ::String),        SysOperationLabelAttribute( literalStr ( "Item Id" ))]        public List parmItemId( List _ListItemId = ListItemId) {               ListItemId = _ListItemId;               return ListItemId; } } //For validation parameters,     public boolean validate()     {         boolean              is
Read more