Skip to main content

Notifications

Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / In Trial Balance the v...
Finance | Project Operations, Human Resources, ...
Suggested answer

In Trial Balance the voucher of opening balance is not visible in the trial balance.

(0) ShareShare
ReportReport
Posted on by Ankit Gupta 18
Hello 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.
 
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.
 
//
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    In Trial Balance the voucher of opening balance is not visible in the trial balance.
    Hi Community user,
     
    I was able today to enable an old environment with AX 2012 R3 (CU12). I can reproduce your issue. When you click on the amount in the Opening balance column, no vouchers show up initially. 
    When the voucher form is opened, you can use the key combination CTRL+F3 to open the advanced query form. The filter range for the field Date is in correct. This is a bug. To get details visible, you can remove this filter and replace it with a line for the FiscalCalendarPeriod table, field Type with the value Opening.
     
    You can check on LCS issue search if there is a fix available for this issue.
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    In Trial Balance the voucher of opening balance is not visible in the trial balance.
    Extensible Data Security (XDS) is maintained in the development environment (AOT) and can't be changed via the user interface. In case you don't have access to knowledge how to check it, you can ask a developer looking into the details.
  • Ankit Gupta Profile Picture
    Ankit Gupta 18 on at
    In Trial Balance the voucher of opening balance is not visible in the trial balance.
    Hi Andre,
     
    Can you please brief about the Security role with XDS? Just under System Administrator>Setup>Security under this I have to add or implement the record-based security?
     
    Yes there is only one filter of date but that filter is being used for all the balances and in other the balances are appearing but in this it was not appearing. Can you please suggest some solution.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    In Trial Balance the voucher of opening balance is not visible in the trial balance.
    Hi,
     
    I wouldn't directly exclude security, unless you have the system administrator role assigned. WIth XDS, you can implement record-based security. That can cause some records to be hidden for particular users.
     
    Can you check if there are filters applied on the form with the voucher transactions? You can open the advanced query editor with help of the key-combination CTRL+F3.
  • Ankit Gupta Profile Picture
    Ankit Gupta 18 on at
    In Trial Balance the voucher of opening balance is not visible in the trial balance.
    Hello Andre,
     
    Thank you for your response.
     
    I think the issue is not related to the security role as in same User ID, I am able to see all other vouchers and transaction of the Ledger Accounts.
     
    Yes, the records are there in the DimensionFocusBalance Table and GeneralJournalAccountEntry Table also checked the DimensionAttributeValueCombination Table the vouchers are flowing in the tables.. I have also tried by rebuilding the balances updating the balances and by clearing cache by running the job and again rebuilding balances but still its not working.
     
    Kindly suggest some feasible solution to this issue.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    In Trial Balance the voucher of opening balance is not visible in the trial balance.
    Hi Community User,
     
    What security role do you have in this environment? If you are not a system administrator, check out if security policies (XDS) are in place that will hide records from the user interface. Or maybe another filter is applied on the form? What records can you find in the table DimenionFocusBalance and GeneralJournalAccountEntry for this main account? Have you tried rebuilding the balances as well?

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

News and Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans