get Dim. Number and value from ledgerDim
Wed Mar 19 2025 09:57:57 GMT+0000 (Coordinated Universal Time)
Saved by
@MinaTimo
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();
}
content_copyCOPY
Comments