Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Ankit Gupta

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.

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Ankit Gupta 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ankit Gupta 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates