How to get a single record of default dimension value from ledger dimension (ledger account) specified on voucher transactions form

(0) Share

Report

Posted on by Ammad majid

On voucher transactions form all transactions are shown according to the ledger dimension (ledger-account) which is group of values i.e. mainaccount--businessunit- costcenter-department which is found in dimension attribute value combination table and the default dimension values are found in dimension attribute value set. I have created relationship to obtain the result but its given me multiple values against each ledger dimension. My query is shown attached below:

2620.dim.PNG

Does anyone know where I am creating a wrong relationship among the tables and help me create right query. And the requirement is that I want to see all the transaction amount against each department.

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 238,789 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Working with these tables directly is quite difficult, as you've already found. You usually can make your life easier by using higher-level objects such as LedgerDimensionFacade class or DimensionAttributeLevelValueAllView view. Give them a try.

Was this reply helpful? Yes No