You’re offline. This is a read only version of the page.
Announcements
Hi. After a recent Microsoft update, I find that the Ledger account statement by Dimension shows the opening balances (which was an earlier issue).
However, when I take the dimension statement by using Primary Dimension Set as Main account + Employee (we have employee dimensions enabled from the beginning), the report brings the opening balance separately and the employee transactions separately. All transactions in the account are posted with employee dimension.
As you see here, the employee (Ahmed) transactions show with opening balance 0 while it is included in a lumpsum amount in the OB of the report. This totally defeats the purpose of having dimensions in the first place.
The report should be showing the opening balance by employee. By this statement, we are unable to know the opening balance of the employee, due to which their final loan balance is wrong.
Is there any way to fix this and get the report to show opening balance respective to each employee when the report is taken by employee dimension?
Hi,
can you try following report , this might help you
exploredynamics365.home.blog/.../
[/quote]Hi. I have tried this and it is not what we are looking for. We are looking to get the report by employee dimension, which means for a given period, the opening balance should be per employee and also transactions should be per employee.
Hi,
Are you able to see the opening balances in trial balance?
[/quote]Hi. Thanks for getting back to me. The trial balance also shows the opening balance (final closing balance of last year) as a total figure and then shows the remaining by each employee dimension. So the total of each employee in the TB or the statement shows only the transactions of the current year. However, in this scenario, we need both opening balance + transactions by employee.
Hi,
Are you able to see the opening balances in trial balance?
#1
André Arnaud de Cal...
293,331
Super User 2025 Season 1
#2
Martin Dráb
232,256
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (