Finance | Project Operations, Human Resources, ...

how get default dimension recid using its display value

(1) Share

Report

Posted on by Sachin Mittal

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

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Martin Dráb 240,361 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sachin Mittal 6 on at

Like (0)

Report
Copy link

Link copied!

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'.

Was this reply helpful? Yes No
Martin Dráb 240,361 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sachin Mittal 6 on at

Like (0)

Report
Copy link

Link copied!
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."); }

Was this reply helpful? Yes No
Martin Dráb 240,361 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Sachin Mittal 6 on at

Like (0)

Report
Copy link

Link copied!

i am updating one of your replies as suggest answer , but screen keeps loading after clicking on it

Was this reply helpful? Yes No