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.

All responses (1)

Answers (0)

Martin Dráb 233,025 Most Valuable Professional on at

Like (1)

Report

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

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.