Get Financial Dimension values for Financial Dimension X++

static void Job13(Args _args)
{

    DimensionAttribute      _DimensionAttribute;

    DimensionAttributeDirCategory  _DimensionAttributeDirCategory;

    DimensionFinancialTag           _DimensionFinancialTag;

    while select _DimensionFinancialTag
        join _DimensionAttributeDirCategory
        where _DimensionAttributeDirCategory.DirCategory == _DimensionFinancialTag.FinancialTagCategory
        join _DimensionAttribute
        where  _DimensionAttribute.RecId == _DimensionAttributeDirCategory.DimensionAttribute
        && _DimensionAttribute.Name == 'Branch'
    {
        info(strfmt("%1 - %2",_DimensionFinancialTag.Value,_DimensionFinancialTag.Description));
    }

}

Leave Comment

Your email address will not be published. Required fields are marked *