Finance | Project Operations, Human Resources, ...

DimensionAttributeValueCombination table

(0) Share

Report

Posted on by Shilpi

145

When are the records insert in DimensionAttributeValueCombinati table ?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

udaY-ch 5,180 on at

Like (0)

Report
Copy link

Link copied!

HI

DimensionStorage/SavePrivate is the base, this will be called when a new combination is used in any transaction.

here is the call stack when a new combination is used in general ledger journal.

Hope this helps.

Uday

Was this reply helpful? Yes No
Shilpi 145 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply..

Problem: how to insert value in ledgerJournalTrans.OffsetLedgerDimension using job where I have only main account id. It is working fine when mainaccount recid is present in dimensionAttributeValueCombination . But when it is not matched then values goes to 0.

I have added this code.

select firstOnly dimensionAttributeValueCombination

where dimensionAttributeValueCombination.MainAccount == MainAccount.RecId;

&& dimensionAttributeValueCombination.LedgerDimensionType == ledgerDimensionType::Account ;

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

You are just searching dimension directly in the table , so obviously if it is not present you are going to get zero. Instead you will have to search for dimension using out of the box classes and values you have (main account and other dimensions)which are already there for you. If the dimension is exist those will return you the values otherwise create it. For reference look at below link

www.linkedin.com/.../

Was this reply helpful? Yes No