Friday, 20 October 2023

DimensionFinancialTag in D365 FO X++

  public RefRecId validateDimensions(Name _dimensionAttributeName, str _displayValue)

    {

        DimensionAttribute                 dimensionAttribute;

        RecId                                       dimFinancialCategoryRecid;

        DimensionFinancialTag           dimensionFinancialTag;

        dimensionAttribute               = DimensionAttribute::findByName(_dimensionAttributeName);

        dimFinancialCategoryRecid = dimensionAttribute.financialTagCategory();

        select firstonly RecId from dimensionFinancialTag

            where dimensionFinancialTag.FinancialTagCategory == dimFinancialCategoryRecid

            && dimensionFinancialTag.Value == _displayValue;

        return dimensionFinancialTag.RecId;

    }

No comments:

Post a Comment

Azure Data Engineer stack

A very common Azure Data Engineer stack is: Azure Data Factory Azure Databricks Azure Data Lake Storage Azure Synapse Analytics ...