X++ code to get FinancialDimension Name/description from generaljournalAccountrEntry(LedgerDimensionField)

(0) Share

Report

Posted on by Faqruddin

1,909

Hello,

I have below code to get Financial Dimension values from generaljournalAccountrEntry(LedgerDimensionField). I need Financial dimension description or name like below in picture and below is my code its getting only financial dimension segment CostCenter. But I need Full name/description of CostCenter.

2084.DimensionName.png

static void Job32(Args _args)
{
     
      DimensionAttributeLevelValueAllView dimAttrLevelAll;
    DimensionAttribute                  dimAttribute;
    DimensionAttributeValue     dimAttributeValue;
    DimensionFinancialTag               dimensionfinancialtag;
    refrecid  financialTagCategory;
    ;


    select DisplayValue from dimAttrLevelAll
    join dimAttribute
    where dimAttribute.RecId                    == dimAttrLevelAll.DimensionAttribute
           && dimAttrLevelAll.ValueCombinationRecId == 5640344835 //generalJournalAccountEntry.LedgerDimension 
           && dimAttribute.Name                     == "CostCenter";
    
    info(strFmt("CostCenter: %1", dimAttrLevelAll.DisplayValue)); 
    
   // info(strFmt("CostCenter Name/Desc: %1", dimAttribute.dimensionName())); 

}

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Gunjan Bhattachayya 35,429 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Faqru,

You can use getName method from DimensionAttributeValue table. Your code will look like this -

static void Job32(Args _args) { DimensionAttributeLevelValueAllView dimAttrLevelAll; DimensionAttribute dimAttribute; DimensionAttributeValue dimAttributeValue; select DisplayValue from dimAttrLevelAll join dimAttribute join dimAttributeValue where dimAttributeValue.RecId == dimAttrLevelAll.AttributeValueRecId && dimAttribute.RecId == dimAttrLevelAll.DimensionAttribute && dimAttrLevelAll.ValueCombinationRecId == 5640344835 //generalJournalAccountEntry.LedgerDimension && dimAttribute.Name == "CostCenter"; info(strFmt("CostCenter: %1", dimAttrLevelAll.DisplayValue)); info(strFmt("CostCenter Name/Desc: %1", dimAttributeValue.getName())); }

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you. Its perfect. And below code also works for me.

static void glDim2(Args _args) { DimensionDefault d = 5640344835; DimensionAttributeValueCombination dimensionAttributeValueCombination; DimensionAttributeValueGroupCombination dimensionAttributeValueGroupCombination; DimensionAttributeValueGroup dimensionAttributeValueGroup; DimensionAttributeLevelValue dimensionAttributeLevelValue; DimensionAttributeValue dimensionAttributeValue; DimensionAttribute dimensionAttribute; select dimensionAttributeValueCombination where dimensionAttributeValueCombination.RecId == d join dimensionAttributeValueGroupCombination where dimensionAttributeValueGroupCombination.DimensionAttributeValueCombination == dimensionAttributeValueCombination.RecId join dimensionAttributeValueGroup where dimensionAttributeValueGroup.RecId == dimensionAttributeValueGroupCombination.DimensionAttributeValueGroup join dimensionAttributeLevelValue where dimensionAttributeLevelValue.DimensionAttributeValueGroup == dimensionAttributeValueGroup.RecId join dimensionAttributeValue where dimensionAttributeValue.RecId == dimensionAttributeLevelValue.DimensionAttributeValue join dimensionAttribute where dimensionAttribute.RecId == dimensionAttributeValue.DimensionAttribute && DimensionAttribute.Name == "Customer"; //ProjectId //Salesman info(dimensionAttributeValue.getName()); }

Was this reply helpful? Yes No