Showing posts with label Number sequence. Show all posts
Showing posts with label Number sequence. Show all posts

Tuesday, February 22, 2022

Create custom number sequence using x++.

Hi guys, I got a requirement like I need to add new field in standard table and I need to set that field as Index field. I have already some custom data in my machine. I get few errors while I set sync. So I need to fill some dummy data in that field, so I have done that by using below code.

static void getNumberSeq(Args _args) { Mytable mytable; Name id, myId = 'Test00'; //CustGroup custGroup; int myIdNum; void getId(int _id) { str addZero = '00000'; for (int i = 1; i<=5 ; i++) { if (strLen(int2Str(_id)) == i) { addZero = subStr(addZero, 0, (strLen(addZero) - i)); break; } } id = addZero + int2Str(_id); } ttsbegin; while select forupdate crosscompany mytable where !mytable.field1 { myIdNum++; getid(myIdNum); changecompany(mytable.dataareaid) { mytable.field1 = myId + id; mytable.doupdate(); } } ttscommit; /*while select forupdate crossCompany custGroup { org++; getId(org); changeCompany(custGroup.dataAreaId) { info(strFmt('cutGroup- %1, Id -%2',custGroup.CustGroup,myId + id)); } }*/ }


 Please check. For your reference I have used custGroup table and that output I have shown in info. This example I have done in 2012 and D365FO. Only 2012 Output I am giving.



Keep daxing!!


How to Setup number sequence in standard or custom form In D365FO using x++

 How to Setup number sequence in form In D365FO X++.

Create number sequence for new field : Link 

  • After creation of new number sequence we need to setup in one form. I got a requirement to setup new number sequence in standard from.
  • For this I have used the extensions(COC). Please check.
  • If you need for custom form just copy the below methods and pasted in you'r form.
  • The below code is for both custom and standard forms.  

On Form data source.

   [ExtensionOf(formDataSourceStr(MyForm, MyTable))]

final class MyFormDataSource_Extension { void write() { next write();//COC //super(_append); element.numberSeqFormHandler().formMethodDataSourceWrite(); } void delete() { element.numberSeqFormHandler().formMethodDataSourceDelete(); next delete();//COC //super(_append); } void create(boolean _append) // If created externally { element.numberSeqFormHandler().formMethodDataSourceCreatePre(); next create(_append);//COC //super(_append); element.numberSeqFormHandler().formMethodDataSourceCreate(); // this.object(fieldNum(MyTable, Field1)).modified(); // If any modified method is written in data source field level // By the above line we can call, } // In standard they are added below 2 methods. public void linkActive() { element.numberSeqFormHandler().formMethodDataSourceLinkActive(); next linkActive();//COC //super(); } public boolean validateWrite() { boolean ret; MyTable myTable;//COC myTable = this.cursor();//COC if (!myTable.Field1) { element.numberSeqFormHandler().formMethodDataSourceCreate(true); } ret = next validateWrite();//COC //ret = super(); ret = element.numberSeqFormHandler().formMethodDataSourceValidateWrite(true) && ret; return ret; } } On Form.
[ExtensionOf(formStr(MyForm))] final class MyFormDataSource_Extension { public NumberSeqFormHandler numberSeqFormHandler;// global variable public NumberSeqFormHandler numberSeqFormHandler() { if(!numberSeqFormHandler) { numberSeqFormHandler = NumberSeqFormHandler::newForm( myParameters::numRefMyID().NumberSequenceId, this, this.MyTable_ds, fieldNum(MyTable, Field1)); } return numberSeqFormHandler; } void close() { if (numberSeqFormHandler) { numberSeqFormHandler.formMethodClose(); } next Close();//COC //super(); } }

Reference: 

Keep Daxing!!

Friday, November 12, 2021

create number sequence in d365 x++

 Topic : Create number sequence in d365 using x++.

In this post I created a new number sequence for my existing module. Just follow the below steps.

1. Create a new extension class for NumberSeqModuleMyModule. written the below code in loadModule method.  

         [ExtensionOf(classStr(NumberSeqModuleMyModule))]
    final class NumberSeqModuleMyModule_Extension
    {
        protected void loadModule()
        {
            NumberSeqDatatype datatype = NumberSeqDatatype::construct();

            next loadModule();

            datatype.parmDatatypeId(extendedTypeNum(MyId));
            datatype.parmReferenceHelp(literalStr('My Id'));
            datatype.parmWizardIsContinuous(false);
            datatype.parmWizardIsManual(NoYes::No);
            //datatype.parmWizardFetchAheadQty(10);
            datatype.parmWizardIsChangeDownAllowed(NoYes::No);
            datatype.parmWizardIsChangeUpAllowed(NoYes::No);
            datatype.parmWizardHighest(999999999);
            datatype.parmSortField(1);
            datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);
            this.create(datatype);
        }

    }

2. Create a new extension class for parameter table(MyParmeters) and a new method.

    [ExtensionOf(tableStr(MyParameters))] final class MyParameters_Extension { public static NumberSequenceReference myId() { return NumberSeqReference::findReference(extendedTypeNum(MyId)); } }

3. To run the NumberSeq class just create a job(runnable class).

        class RunnableClass

{ public static void main(Args _args) { NumberSeqModuleMyModule loadModule = new NumberSeqModuleMyModule(); ; loadModule.load(); } }

4. run the runnable class and then go to Organization administration –> Number sequences –> Number sequences –> Generate Button (Run the wizard).

5. To test that number seq follow the below code.

    class RunnableClass { public static void main(Args _args) { NumberSeq numberSeq; str num; ; numberSeq = NumberSeq::newGetNum(MyParameter::MyID()); num = numberSeq.num(); info(num); } }

Keep daxing!!

Monday, October 4, 2021

Reset Number sequence using x++

Reset Number sequence using x++


    NumberSequenceTable numseqtable; ttsbegin; //numseqtable = NumberSequenceTable::find(SalesParameters::numRefMyId().NumberSequence); select forupdate numseqtable where numseqtable.Recid == //RecId value\\; if (numseqtable ) { numseqtable.NextRec = numseqtable.Lowest; numseqtable.update(); } ttscommit;


Keep daxing!!


How to recover a number sequence just used in D365Fo using X++

 Customer creating new record in table. Once he deleted the last record of table and he inserting a new record at that time he want to apply last deleted record number to newly created record.

I wrote the code in table level deleted method.

    public void delete() { NumberSequenceTable numSeqTable; MyId myId; ; myId= MyTable.MyId; numSeqTable = NumberSequenceTable::find( SalesParameters::numRefMyId().NumberSequence); super(); if (numSeqTable.Continuous) { NumberSeq::release(SalesParameters::numRefMyId().NumberSequence, myId); } else { if (NumberSeq::numInsertFormat(numSeqTable.NextRec - 1, numSeqTable.Format) == myId) { ttsbegin; numSeqTable = NumberSequenceTable::find( numSeqTable.NumberSequence, true); numSeqTable.NextRec--; numSeqTable.doUpdate(); ttscommit; } } }

Ref : https://stackoverflow.com/questions/35247361/how-to-recover-a-number-sequence-just-used
Keep daxing!!

How to roll back a number sequence in D365FO

 Today we discuss, how to roll back number sequence if any validation failed in D365FO.

If number sequence is creating without using NumberSeq class. we can use 

ttsbegin;

// our logic

ttscommit;

If any validation failed the system roll back everything.


If we creating number sequence using NumberSeq class by abort() method we can recover that number. This only works if in the same transaction scope as NumberSeq and if the number sequence is continuous. if not, both calls are no-operations.


        NumberSeq numSeq = NumberSeq::newGetNum(Parameters::numRefMyId(), true);

// NumberSeq numSeq = NumberSeq::newGetNumFromId(Table.AutoNumberSequenceTable, true); MyTable myTable; ; try { myTable.clear(); myTable.myId = numSeq.num(); if (myTable.validateWrite()) { myTable.insert(); numSeq .used(); } } catch (Exception::Error) { numSeq .abort(); }


Keep daxing!!

Create Multiple number sequence for one EDT In D365FO using X++

I got a requirement in order to create Multiple number sequence based on type for newly created purchase order in D365FO.

The similar requirement is already exists in fixed assets. Same way I followed here.


1. I created new table with 3 fields.

  •         Purch type.
  •         Description.
  •         Number sequence code.(Organization module --> Number sequences(form) --> Number sequence code(field)).
                                                




Organization module --> Number sequences(form) 
    Create new number sequence as per you requirement.


2.  Added "Purch type" field in purchase order and added relation to purch table and my table.


3. written code in below classes.

Form data source field(PurchaseType) modified method:

    [ExtensionOf(formDataFieldStr(PurchCreateOrder, PurchTable, PurchaseType))] final class PurchCreateOrderFormControl_Extension { public void modified() { FormDataObject formDataObject = any2Object(this) as FormDataObject; PurchTable purchTable = formDataObject.datasource().cursor(); NumberSeq purchaseOrderNumberSeq = element.purchaseOrderNumberSeq as NumberSeq; ; next modified(); if(purchaseOrderNumberSeq) { purchaseOrderNumberSeq.abort(); } purchaseOrderNumberSeq = purchTable.initPONumberSeq(); element.purchaseOrderNumberSeq = purchaseOrderNumberSeq; purchTable.PurchId = purchaseOrderNumberSeq ? purchaseOrderNumberSeq.num() : nullValueFromType(Types::String); purchId = purchTable.PurchId; FormDataUtil::getFormDataSource(purchTable).refresh(); } }


Purch table method:

    [ExtensionOf(tableStr(PurchTable))] final class PurchTable_Extension { public NumberSeq initPONumberSeq(PurchaseType _purchaseType = " ") { NumberSeq purchaseOrderNumberSeq = PurchaseTypeTable::getNumberSeqForType( _purchaseType ? _purchaseType : this.PurchaseType); return purchaseOrderNumberSeq; } }

PurchaseTypeTable(My table) method: 

    public class PurchaseTypeTable extends common { public static NumberSeq getNumberSeqForType(PurchaseType _purchaseType) { PurchaseTypeTable purchaseTypeTable = PurchaseTypeTable::find(_purchaseType); NumberSeq purchaseOrderSeq; PurchTable purchTable; if (purchaseTypeTable.AutoNumberSequenceTable) { purchaseOrderSeq = NumberSeq::newGetNumFromId(purchaseTypeTable.AutoNumberSequenceTable, true); } return purchaseOrderSeq; } }

Form close method:

    [ExtensionOf(formStr(PurchCreateOrder))] final class PurchCreateOrderForm_Extension { public numberseq purchaseordernumberseq; public PurchId purchId; public void close() { if (!purchtable.recid && purchaseordernumberseq) { purchaseordernumberseq.abort(); } } }

Form data source write method:

    public void write() { if (purchaseordernumberseq) { purchaseordernumberseq.onNumberUsed(purchTable.PurchId, purchId); } }

Keep daxing!!

Tuesday, April 20, 2021

Remove Number sequence in Parameter form in D365Fo using X++

 

 Remove Number sequence in Parameter form in D365Fo using X++.


public static void main(Args _args)

    {

       NumberSequenceDatatype numSeqDT; // EDT information

        NumberSequenceReference numSeqRef; // Merging relation between EDT and number sequence

        select forUpdate numSeqDT

        where numSeqDT.DatatypeId == extendedtypenum(BookingID); // EDT Id

        delete_from numSeqRef

        where numSeqRef.NumberSequenceDatatype == numSeqDT.RecId;

        ttsBegin;

        numSeqDT.delete();

        ttsCommit;

        info( strFmt("Relation with EDT: %1 is removed.", numSeqDT.DatatypeId) );

    }

Keep Daxing!!

Thursday, November 26, 2020

How to create Number sequence Based on selected year in ax 2012 using X++


Hi guys, Today we see how to create a number sequence based on the selected year in ax 2012 using X++.


Here I am using 2 EDT's. Dax Year, New Year. I create a number sequence for that 2 EDT's.

In the setup level I mentioned 2020 for one EDT and for the other I mentioned 2021.


 public void numSeq()

{

    NumberSeq                numberSeq1,numberSeq2;

    TestingMain                testingLoc;


    //str                                    parmNum;

    super();

    testingLoc= element.args().record();

    //select firstOnly testingLocwhere testingLoc.Action==NoYes::Yes;


    if(testingLoc.DaxYear=='2021' && testingLoc.Action==NoYes::Yes)

    {

        numberSeq1 = NumberSeq::newGetNum(NumberSeqReference::findReference(extendedTypeNum(DaxYear)));

        DAXTesting.DaxYear=numberSeq1.num();

        DAXTesting.insert();

    }

    else if(testingLoc.DaxYear=='2020'&& testingLoc.Action==NoYes::Yes)

        {

            numberSeq2 = NumberSeq::newGetNum(NumberSeqReference::findReference(extendedTypeNum(NewYear)));

            testingLoc.NewYear=numberSeq2.num();

            testingLoc.insert();

        }

}

keep Daxing!!