Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

D365OF

Add Financial dimension to Customer/Vender with X++ Dynamics 365 for finance and operations

by

Small tip, I used following code snippet to add financial dimension in Customer / Vendor, You can extend this code by adding more dimension and values on Containers in following code snippet.
public class  iaxFinancialDimensionHelper
{
    Public static DimensionDefault ProjectDimension(ProjId _ProjId)
    {
        DimensionAttributeValueSetStorage valueSetStorage = new DimensionAttributeValueSetStorage();
        DimensionDefault result;
        int i;
        DimensionAttribute dimensionAttribute;
        DimensionAttributeValue dimensionAttributeValue;
        container conAttr = [“Projects”];
        container conValue = [_ProjId];
        str dimValue;
        for (i = 1; i <= conLen(conAttr); i++)
        {
            dimensionAttribute = dimensionAttribute::findByName(conPeek(conAttr,i));
            if (dimensionAttribute.RecId == 0)
            {
                continue;
            }
            dimValue = conPeek(conValue,i);
            if (dimValue != “”)
            {
                // The last parameter is “true”. A dimensionAttributeValue record will be created if not //found.
                dimensionAttributeValue =
dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue,false,true);
                // Add the dimensionAttibuteValue to the default dimension
                valueSetStorage.addItem(dimensionAttributeValue);
            }
        }
        result = valueSetStorage.save();
        return result;
    }
}
Reference : Internet. possible Dynamics forum. it works for me.

How to copy financial dimension form one object to other. Dynamics 365 For finance and operations

by

Hi all, In some cases we can need to copy  financial dimension from one object to  other for example Customer to Sales order or Vendor to purchase order.

In Ax 2012  it little easy. But in D365 For finance and operations, it is little bit tricky.

 

I did this with following code snippet.  With the help of out of box. LedgerDimensonDefaultFacade class i used the merge default dimension method and passed same table dimension in form and to dimension.

Result is interesting.

 

 

 salestable.DefaultDimension= LedgerDimensionDefaultFacade::serviceMergeDefaultDimensions(CustTable.DefaultDimension,CustTable.DefaultDimension);

Calling menu name in Extensions Dynamics 365 for finance and operations

by

In Ax 2012 we get menu name with element.Args().CallMenu name, using  taking decision on menu name.

 

But same logic we need to apply in Extension. But in D365 For finance and operations we did not overlay. Following code snippet helps me to implement similar logic in Extension.

 

 

[ExtensionOf(formStr(CustTable))]

final class IaLogisticsContactInfoGrid_Extension

{

 

 

/// <summary>

///

/// </summary>

/// <param name=”sender”></param>

/// <param name=”e”></param>

[FormEventHandler(formStr(LogisticsContactInfoGrid), FormEventType::Initialized)]

public static void LogisticsContactInfoGrid_OnInitialized(xFormRun sender, FormEventArgs e)

{

 

FormRun formRun = sender;

 

;

 

info(formRun.args().menuItemName());

}

 

}

Paging in Query X++ Dynamics 365 for finance and operations

by

For paging in X++ Query. There are three steps required. Rest of Query Code is same.

We have to set following things in Query data source

  • Set Sort field in Query data Source.
  • Paging position property of QueryRun is set to true.
  • Add page range with starting position and number of records in QueryRun

Here is code snippet

 

  QueryBuildRange qbr,qbrStartDate,qbrEndDate;
QueryBuildDataSource qbd;
IAPageSize EnumPageSize;

QueryRun        qr;

Query           query = new Query();

Int pageSize = 2;

 

qbd = query.addDataSource(TableNum(ProjPlanVersion));
qbd.addOrderByField(fieldNum(ProjPlanVersion,HierarchyId));

qr = new QueryRun(query);

qr.enablePositionPaging(true);
            CurrentPageNumber =1;
            startingposition = CurrentPageNumber * pagesize;
            qr.addPageRange(startingposition, totalRows);
while(qr.next())

 

{

 

Info (“”);

}

Data source filter using extension Dynamics 365 for finance and operations

by

Hi every one, Today I have very small tip. During customization we need to add filters at run time. Specially in the case of inquiry forms. But Now we have to work with extension. Extensions are much more powerful then over layering.

 

So first one thing to copy Datasource  OnQueryEXecuting event. And paste in Extension class.

The sample code snippet is here.

 

 

 

 [FormDataSourceEventHandler(formDataSourceStr(HcmDiscussion, HcmTopicRef), FormDataSourceEventType::QueryExecuting)]

public static void HcmTopicRef_OnQueryExecuting(FormDataSource sender, FormDataSourceEventArgs e)

{

FormRun          HcmDiscussionForm = sender.formRun();

sender.query().dataSourceName(sender.name()).addRange(fieldnum(HcmTopicRef,     HeadingRefRecId)).value(queryValue(_heading.RecId));

}