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

Setting VendInvoiceInfoTable default values for custom fields - D365 FO

  When creating a vendor invoice and you are trying to populate custom fields on table VendInvoiceInfoTable you may find that the following ...