Finance | Project Operations, Human Resources, ...

how get default dimension recid using its display value

(0) Share

Report

Posted on by Sachin Mittal

490

i have a default dimesnion named /Fund/ and its display value as /567/ , how to get the recid for this deafult dimension value , please help me

All responses (6)

Answers (0)

Suggested answer

Sachin Mittal 490 on at

Like (0)

Report

how get default dimension recid using its display value

i am updating one of your replies as suggest answer , but screen keeps loading after clicking on it
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

how get default dimension recid using its display value

It seems that the question how get default dimension recid using its display value has been answered, so please verify the answer.

The query will tell you whether the such a value was already used as a financial dimension; that is hasn't been doesn't mean that it can't be. If you have more question on this other topic, please create a new thread for them.
Sachin Mittal 490 on at

Like (0)

Report
how get default dimension recid using its display value

can i validate this default fault dimension value using same code , i means if dimensionAttributeValue.recid exists , dimension value is correct otherwise it is wrong ?

container dimCon = str2con("11030-101", "-"); dimensionAttributenew = DimensionAttribute::findByName('Fund'); dimensionAttributeValue = DimensionAttributeValue::findByDimensionAttributeAndValueNoError(dimensionAttributenew, conPeek(dimCon, 2), false, true); if (!dimensionAttributeValue.RecId) { throw error("Financial dimensions fund value is not correct."); }
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

how get default dimension recid using its display value

The value of the first parameter is wrong. You're passing a string, while the actual type is DimensionAttribute table. Use DimensionAttribute::findByName() to find the record.
Sachin Mittal 490 on at

Like (0)

Report

how get default dimension recid using its display value

i used this dimensionAttributeValue = DimensionAttributeValue::findByDimensionAttributeAndValueNoError('Fund', '101', false, true); but giving error

Type mismatch in 'DimensionAttributeValue.findByDimensionAttributeAndValueNoError' argument 1. The expected type is 'DimensionAttribute', but the actual type is 'str'.
Suggested answer

Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

how get default dimension recid using its display value

If you mean in code, use DimensionAttributeValue::findByDimensionAttributeAndValue().RecId.