Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Trial balance not show...
Microsoft Dynamics AX (Archived)

Trial balance not showing transactions against the Financial dimension set

(0) ShareShare
ReportReport
Posted on by syed baber 11,633

Hi All,

Under GL -> Common -> Trial balance list page, I am unable to see the transactions for financial dimension set which just have Main account in it. I clicked on the parameter button and applied the following date range

From Date : 07/01/2013

To Date : 06/30/2014

But it is not showing any data. The reason is there is no data with the above date range in DimensionFocusBalance table. Please note that I can see transactions for the above date ranges in GL -> Voucher transactions form. So I go to the financial dimension set form and tried to rebuild balances by selecting the Financial dimension set 'MainAccount'. But it is not doing anything, the data in DimensionFocusBalance stays as it is. I was expecting it to rebuild balances i.e. create records in DimensionFocusBalance table, so that I can see the records under Trial balance for the date range.

Does anyone know what could be the reason that rebuild balances function is not populating DimensionFocusBalance table with appropriate data as per the transactions in General ledger ?

Thanks,

Baber.

*This post is locked for comments

  • Ankit Gupta Profile Picture
    Ankit Gupta 18 on at
    Trial balance not showing transactions against the Financial dimension set
    Hi Andre,
     
    I am creating a new question forum for this. Thank you.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    Trial balance not showing transactions against the Financial dimension set
    Hi Community user, 
     
    Have you checked if the verified reply from Ludwig mentioning a hotfix can be relevant for you as well? Did you also check other replies and the contents of the tables DimensionFocusBalance, and GeneralJournalAccountEntry?
    If it will not give you any hint, your issue is different and then it will be better to create a new question on the forum. Otherwise, the thread will become confusing discussing different topics.
  • Ankit Gupta Profile Picture
    Ankit Gupta 18 on at
    Trial balance not showing transactions against the Financial dimension set
    Hello,
     
    I am facing the exact issue. For all the account the opening balance voucher is visible in the trial balance but only for 2 Ledger Account the opening balance voucher is not visible but the voucher is there in the voucher transactions also while selecting the option 'include opening transactions amount in detail' the amount is appearing as well as the vouchers are appearing with 2 lines one for opening balance and one line for current period transaction in the trial balance, the correct amount is also not reflecting in the next month opening balance.
    How to retrieve the vouchers in the opening balance? Kindly suggest.
     

     
  • Simone Gili Profile Picture
    Simone Gili 55 on at
    RE: Trial balance not showing transactions against the Financial dimension set

    I had a similar issue which I solved following this link:

    blogs.msdn.microsoft.com/.../clear-the-dimension-set-balance-ledger-dimension-cache

    I had no consistency data on TB with two different dimension sets, but not with all (other dimensions sets worked properly).

    I executed the job, rebuilt balances, and at the end the data on TB have became correct again.

    Simone

  • syed baber Profile Picture
    syed baber 11,633 on at
    RE: Trial balance not showing transactions against the Financial dimension set

    Hi Ludwig,

    The hotfix seems very relevant in my case. I will install this and see if this resolves the issue or not.

    Appreciate your help.

    Thanks,

    Baber.

  • syed baber Profile Picture
    syed baber 11,633 on at
    RE: Trial balance not showing transactions against the Financial dimension set

    Thanks very much Ludwig. I will take a look at this hotfix.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trial balance not showing transactions against the Financial dimension set

    Hello Baber,

    The only Thing I could think of might be the following hotfix.

    KB 3135076Trial balance list page doesn't show the closing transaction's amount after running the Fiscal Year Close

    Probably take a look to see whether this might fix your issue.

    Other than that I would suggest / hope that other community members might be able to give you some additional hints on what to do in order to get this fixed.

    Many thanks and best regards,

    Ludwig

  • syed baber Profile Picture
    syed baber 11,633 on at
    RE: Trial balance not showing transactions against the Financial dimension set

    Hi Ludwig,

    Thanks for your response. I already selected that checkbox you mentioned, but it doesn't make any difference. As the data is not present in DimensionFocusBalance table, it will not show in the trial balance as well. Not sure why the data is not getting populated in this table.

    Unfortunately, the SSRS reports are not being setup in the system, so I can't check that.

    Thanks,

    Baber.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Trial balance not showing transactions against the Financial dimension set

    Hello Barber,

    The parameter you mentioned above should not delete / move data in a way that they cannot be identified from the Trial Balance anymore.

    Can you double check if you can identify any data if you select the "closing transactions" and/or "include opening transaction amounts in detail" checkboxes available from the Trial Balance parameter form?

    If the Trial Balance list page still does not show any data can you compare whether the "summary Trial Balance" and "detailed Trial Balance" reports available under GL/Reports/Transactions show the data you are looking for?

    Ludwig

  • syed baber Profile Picture
    syed baber 11,633 on at
    RE: Trial balance not showing transactions against the Financial dimension set

    Hi Andre,

    The batch jobs for rebuild balances was already there under Batch jobs form, but set to Ended after count 1, so it was showing with Ended status. So instead of setting it up as a batch job again, I was rebuilding the balances manually to test if I am getting the correct results under GL-> Trial balance.

    Now I posted two transactions to ledger and after rebuilding balances, I can see those under Trial balance, but other transactions which are in the same period not showing under Trial balance.

    Please note that, before I posted above transactions, recently one of our consultant went  to GL -> Periodic -> Financial year close -> Opening transactions form to create opening transactions and the checkbox 'Delete close of year transactions during transfer' was checked. So I believe that, after this the previous year transactions have been deleted from DimencionFocusBalance table and hence it is not showing under Trial balance. Do you think it could be the case, as I am not much familiar with this area, can you please confirm if this could be the reason ?

    Thanks,

    Baber.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans