Friday, 20 October 2023

Create method in View to display dimension values in D365 FO X++

Add field ->StringComputedColumn  -> add properties ->View method name as below and EDT


public static str displayDimensionValues()

    {

        str     sql         = SysComputedColumn::returnLiteral("");

        str     targetField = "AllocationAccount";

        TableId tableId     = tableNum(DimensionAttributeValueCombination);

        DimensionAttribute dimensionAttribute = DimensionAttribute::findByName(targetField);

        // The dimension attribute column should be valid sql, so it is safe to output.

        if(dimensionAttribute

            && dimensionAttribute.getStatus()                                     != DimensionAttributeStatus::Inactive

            && fieldName2Id(tableId, dimensionAttribute.DimensionValueColumnName) != 0)

        {

            sql = T4.dimensionAttribute.DimensionValueColumnName;

        }

        return sql;

    }

No comments:

Post a Comment

validate offsetLedgerDimension in d365 FO

 /// <summary> /// This class is used to validate offsetLedgerDimension /// </summary> class PNG_InventMovValidateOffsetLedgerDi...