Tuesday, July 26, 2022

To Get configured Account Structure Data from Dynamics AX


//Getting configured Account Structure Data from dynamics AX

static void DimensionHierarchy(Args _args)
{
    DimensionHierarchyLevel             dimHierarchyLevel;
    DimensionAttribute                  dimAttribute;
    DimensionConstraintNode             dimConstraintNode;
    DimensionConstraintNodeCriteria     dimConstraintNodeCriteria;
    DimensionHierarchy                  dimHierarchy;
    str      60                         _dimHierarchy = "<Account structure name>";
    ;
    setPrefix("");
    while select RecId from dimHierarchy
            where dimHierarchy.Name == _dimHierarchy
            join RecId from dimHierarchyLevel
                where dimHierarchyLevel.DimensionHierarchy == dimHierarchy.RecId
                    join Name from dimAttribute
                        where dimAttribute.RecId == dimHierarchyLevel.DimensionAttribute
                            join RecId from dimConstraintNode
                                order by dimConstraintNode.Ordinal
                                    where dimConstraintNode.DimensionHierarchyLevel == dimHierarchyLevel.RecId
                                        join dimConstraintNodeCriteria
                                            where dimConstraintNodeCriteria.DimensionConstraintNode == dimConstraintNode.RecId
    {
        info(strFmt("%1 | From- %2 | To- %3",
                dimAttribute.Name,
                dimConstraintNodeCriteria.RangeFrom,
                dimConstraintNodeCriteria.RangeTo
                ));
    }
}

No comments:

Post a Comment

if you have any doubts, please tell me

More Than One Form Was Opened at Once for the Lookup Control

In Dynamics 365 for Finance and Operations, when subscribing to a lookup event to modify an existing lookup on a form control, you must...