How to get "Allow blank" value for an account structure's dimension attributes through code?

(0) Share

Report

Posted on by AlexanderZh

Hello everyone.

How do I get DimensionConstraintNode.isOptional value through code for each dimension attribute, if the only thing I have is MainAccountId?

I found out, that from MainAccountId I can get MainAccount record, then account structure as DimensionHierarchyId and then DimensionConstraintTree record.

Using DimensionHierarchyLevel I can get iterate through structure's attributes. But can't figure out, how do I relate DimensionConstraintNode.Ordinal and MainAccountId?

The image of both DimensionConfigureAccountStructure form and DimensionConstraintNode is provided bellow. These are the objects that I investigate. Form and table shown data is related.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

AlexanderZh 32 on at

Like (0)

Report

I accidentally found the solution.

There is a method in DimensionHierarchy table DimensionHierarchyId getAccountStructure(RecId _mainAccountRecId, LedgerRecId _ledgerRecId = Ledger::current()).

You can notice, that sql statement, that used in this method, targets Main Account DimensionConstraintNode, that is related to given MainAccountId. So to get DimensionConstraintNode record, I copied this method, removed all caching parts, replaces exists join to simple joins and returned DimensionConstraintNode object.

Was this reply helpful? Yes No