Dynamics 365 Price and Licensing details

I’m sure SMBs faced lot of challenges when comes to choose which D365 plan either business or Enterprise edition. Well, Say goodbye to the Business\Enterprise edition.

If you want to know the reason why Microsoft doing this? Check here

As we mentioned before, Microsoft scrapped the Business and Enterprise editions and replaced them with 3 newer plans,

•      Dynamics 365
•       Customer Engagement
•       Unified Operations

You can find the full details about the pricing and plan here.

Happy coding!

Financial Dimension Update through Job

Financial Dimension Update through Job

Scenario:

We are going to update financial dimension (specific values)in sales quotation without affecting other dimesnion values.

Code:

static void AbsSalesQuotationDimension_Upd(Args _args)

{

    int                            j, k;

    Struct                         struct = new Struct();

    container                      ledgerDimension;

    DimensionDefault               DimensionDefault;

    SalesQuotationTable            salesquotbl;

    DimensionAttributeValueSetStorage    dimStorage;

    DimensionAttribute                   DimensionAttribute;

    Counter                                               i;

    DimensionAttribute          dimAttr;

    DimensionAttributeValue     dimAttrValue;

    Common                      common;

    DictTable                   dictTable;

    DimensionValue              activity, country, department, project, property, unit;

    str                         Name;

    str                         value;

    SalesQuotationLine  sqline;

    //department = '111';

    ttsBegin;

    while select forupdate salesquotbl where salesquotbl.QuotationStatus == SalesQuotationStatus::Created

    {

        activity   = '';

        country    = '';

        department = '';

        project    = '';

        property   = '';

        unit       = '';

        ledgerDimension = conNull();

        k = 1;

        j = 0;

        DimensionDefault = 0;

        struct = new Struct();

        

            dimStorage = DimensionAttributeValueSetStorage::find(salesquotbl.DefaultDimension);

            for (i=1 ; i<= dimStorage.elements() ; i++)

            {

                select firstonly dimAttrValue

                where dimAttrValue.RecId == dimStorage.getValueByIndex(i)

                join dimAttr

                    where dimAttr.RecId == dimAttrValue.DimensionAttribute;

                    if (dimAttr && dimAttrValue)

                    {

                        dictTable = new DictTable(dimAttr.BackingEntityType);

                        common = dictTable.makeRecord();

                        if (common.TableId)

                        {

                            select common where common.(dimAttr.KeyAttribute) == dimAttrValue.EntityInstance;

                            name = common.(dimAttr.NameAttribute);

                            value = common.(dimAttr.ValueAttribute);

                            if (dimAttr.Name == 'Activities')

                            {

                               activity =  value;

                            }

                            if (dimAttr.Name == 'Country')

                            {

                               country  =  value;

                            }

                            else if (dimAttr.Name == 'Departments')

                            {

                               department =  '111'; //value;

                            }

                            else if (dimAttr.Name == 'Project_ID')

                            {

                               project =  value;

                            }

                            else if (dimAttr.Name == 'Property_id')

                            {

                               property =  value;

                            }

                            else if (dimAttr.Name == 'Unit_ID')

                            {

                               unit =  value;

                            }

                        }

                    }

            }  //for

                if (activity)

                {

                struct.add('Activities', activity);

                }

                if (country)

                {

                struct.add('Country', country);

                }

                if (department)

                {

                struct.add('Departments', department);

                }

                if (project)

                {

                struct.add('Project_ID', project);

                }

                if (property)

                {

                struct.add('Property_id', property);

                }

                if (unit)

                {

                struct.add('Unit_ID', unit);

                }

                j = struct.fields();

                ledgerDimension += struct.fields();

                for (k =1; k <= j; k++)

                {

                    ledgerDimension += struct.fieldName(k);

                    ledgerDimension += struct.valueIndex(k);

                }

                DimensionDefault = AxdDimensionUtil::getDimensionAttributeValueSetId(ledgerDimension);

                salesquotbl.DefaultDimension = DimensionDefault;

                salesquotbl.update();

            update_recordSet sqline

            setting DefaultDimension = salesquotbl.DefaultDimension

             where salesquotbl.QuotationId == sqline.QuotationId; 

            

    }

    ttsCommit;

}

Happy coding!

Multiple Customer Transaction Reverse by using X++

Multiple Customer Transaction Reverse by using X++

Scenario:

If user wants to reverse the bulk customer transaction (irrespective of Customer account) based on the customer transaction txt column (or any other column).

Code:

static void Abs_CustTrans_Reverse(Args _args)

{

   

    CustTrans                custtran, custtranOut;

    TransTxt                 txt;

    Counter                  counter;

    boolean                  reversed;

    TransactionReversal_Cust transsactionCust = new TransactionReversal_Cust();

    Args args = new Args();

    ;

    counter = 0;

    //Counts how many records which we are going to reverse   

    select count(RecId) from custtranOut

                        where custtranOut.Txt like 'sho*'

                        &&    custtranOut.OrderAccount == '';

    while select custtran

          where custtran.Txt like 'sho*'

          &&    custtran.OrderAccount == ''

    {

        //Returns the reversed status

        reversed = TransactionReversalTrans::findTransactionReversalTrans(tableNum(CustTrans),         custtran.RecId).Reversed;

      if(!reversed)

      {

         args.record(custtran);

         new MenuFunction(menuitemActionStr(TransactionReversal_Cust), MenuItemType::Action).run(args);

         counter++;

      }

    }

        info(strFmt("Actual records %1 and reversed records %2", custtranOut.recid, counter));

}

Happy coding!

Show Documents Icon in Listpage

Show Documents Icon in Listpage

Show document icon in list page, if documents attached to the specific record

Scenario:  Display document icon if user attached any document to the specific record in Listpage.

Below are the steps to bring it in real..

1    1)      Create a below display method in table

display smmDocIconNum showDocHandIcon()

{

    #macrolib.resource

    if ((select firstonly docuRef where docuRef.RefCompanyId  == this.DataAreaId && docuRef.RefTableId ==                this.TableId && docuRef.RefRecId == this.RecId).RecId)

    {

        return #RES_NODE_DOC;

    }

    return #RES_AM_NEW;

}

2     2)      Create a window control in form listpage  and point the table method in control properties.

3     3)      Create window control mouseUp method and paste the below code

int mouseUp(int _x, int _y, int _button, boolean _ctrl, boolean _shift)

{

    int ret;

    ret = super(_x, _y, _button, _ctrl, _shift);

    smmUtility::openSmmDocHandling(salesQuotationTable, element);

    return ret;

}

(I took SalesQuotationtable as an example)

Happy coding!

Copy data from one company to other companies using X++

Copy data from one company to other companies using X++

Overview:

The requirement is to copy BudgetExceltemplate table data from ‘02’ company to other companies. Before import in other companies must delete the dump data.

Code:

The below job will copy and create records from ‘02’ to other companies,

static void CopyDataacrossCmy(Args _args)

{

    //BudgetExcelTemplate is the customized table.

    // Need to copy BudgetExcelTemplate table data from '02' company to all the company

    // Change the table which you want to copy from based on your needs.

    BudgetExcelTemplate   BudgettableFrom, BudgettableTo, tabledelete;

    DataArea            dataareatbl;  

    // ProgressCounter

    #avifiles

    SysOperationProgress                 progressbar;

    int                                  totalRecords;

    #define.TITLE("Copying data to other companies...")

    ;

    select count(RecId) from BudgettableFrom;

    totalRecords = any2int(BudgettableFrom.RecId);

    progressbar  = SysOperationProgress::newGeneral(#aviUpdate, #TITLE, totalRecords);

    // Delete the dump data in other companies except the from company data.

    while select dataareatbl where dataareatbl.id != '02'

    {

         changecompany(dataareatbl.id)

         { 

             tabledelete.clear();           

            ttsBegin;

            delete_from tabledelete where tabledelete.dataAreaId == dataareatbl.id;

            ttsCommit;           

         }

    }   

    BudgettableFrom.clear();   

    // Copy data from 02 company to rest of the companies

    while select dataareatbl where dataareatbl.id != "02"

    {      

        while select BudgettableFrom

        {

            changecompany(dataareatbl.id)

            {

                BudgettableTo.clear();

                ttsbegin;

                buf2buf(BudgettableFrom, BudgettableTo);

                BudgettableTo.insert();

                ttscommit;

            }

            progressbar.incCount();

        }

       

        BudgettableFrom.clear();

    }

    progressbar.hide();

}

Happy coding!