Notifications
Announcements
No record found.
when I tried to run detailed trial balance in ax r3, the report retrieves sub-ledger transaction. how can I prevent subledger transaction in the reports.
Thanks in Advance
Is there is any one could help me urgently
Dear Abdelkader Raway,
Thank you for posting this issue to our community.
From the current available documentation, we can find out that the data on this report comes from the following sources:
DimensionAttributeValueCombination table
DimensionFocusBalance table
GeneralJournalAccountEntry table
LedgerTrialBalanceTmp table
https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/trial-balance-report-ledgertrialbalance
Unless you can extend one of the tables to include a limitation and avoid adding the transactions you do not wish to see, I am unable to identify a filter you can use from the parameters at runtime.
Hi,
Can you please try running the summary trial balance report?
Best regards,
Ludwig
unfortunately, the summary trial balance didn't retrive the voutchers it's retrieving the main accounts only.
So, you want to see the account transactions including all vouchers but exclude the subledgers.
Is that right?
Well, in this case, you could create the trial balance in the management reporter. This will give you only the GL information and exclude every subledger information.
Thanks Ludwig, But can I customize this report it self. whereas I tried to us VStudio design but I don't know how to customize it I tried to add column group to group voucher but it doesn't work . appriciate your kind support and help
Can you please try this documentation? Please discuss internally about customizing the report.
docs.microsoft.com/.../how-to-customize-a-report
You might find useful the link below:
docs.microsoft.com/.../walkthrough-customizing-existing-microsoft-dynamics-ax-reports
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 584 Most Valuable Professional
André Arnaud de Cal... 499 Super User 2025 Season 2
Sohaib Cheema 254 User Group Leader
