Tuesday, 22 October 2019

D365 F & O + Dynamics Ax Get Dimension Attribute Value using X++ coding

 1. Get Dimension values
public static String255 getDimensionValue(SalesLine     _salesLine,Name _attributeValue)
    {
        ProjTable                            ProjTable;
        DimensionAttributeValueSet         DimensionAttributeValueSet;
        DimensionAttributeValueSetItem     DimensionAttributeValueSetItem;
        DimensionAttributeValue            DimensionAttributeValue;
        DimensionAttribute                 DimensionAttribute;

        //  To display value for ProjectId "10005" only
        select RecId from DimensionAttributeValueSet
                where  DimensionAttributeValueSet.RecId == _salesLine.DefaultDimension
        join RecId, DisplayValue from DimensionAttributeValueSetItem
                where DimensionAttributeValueSetItem.DimensionAttributeValueSet == DimensionAttributeValueSet.RecId
        join RecId from DimensionAttributeValue
                where DimensionAttributeValue.RecId == DimensionAttributeValueSetItem.DimensionAttributeValue
        join RecId, Name from DimensionAttribute
                where DimensionAttribute.RecId == DimensionAttributeValue.DimensionAttribute
                && DimensionAttribute.Name == _attributeValue; //'Cost Center';
       
        return DimensionAttributeValueSetItem.DisplayValue;
    }

#D365 FO #X++ #Dynamics Ax

No comments:

Post a Comment