public str getDimensionNum(LedgerDimensionAccount _LedgerDimensionAccount, RecId _attributeNameId)
{
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 == _LedgerDimensionAccount //generalJournalAccountEntry.LedgerDimension
&& dimAttribute.Name == DimensionAttribute::find(_attributeNameId).Name;
return dimAttrLevelAll.DisplayValue;
}
public str getDimensionValue(LedgerDimensionAccount _LedgerDimensionAccount, RecId _attributeNameId)
{
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 == _LedgerDimensionAccount //generalJournalAccountEntry.LedgerDimension
&& dimAttribute.Name == DimensionAttribute::find(_attributeNameId).Name;
return dimAttributeValue.getName();
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter