Hi All,
Can anybody help me to identify the table name where the trial balance data stored?
I could find LedgerTrialBalanceTmp table but from other table data is assigned to this tmp table.
Help would be greatly appreciated.
Regards,
Work
*This post is locked for comments
Hi All,
Thank you so much for your responses.
Regards,
Work
Hi,
I feel its better to debug the code and understand how temporary table LedgerTrialBalanceListPageTmp (datasource: LedgerTrialBalanceTmp) gets its data. Place a breakpoint in the method constructBalances of table LedgerTrialBalanceListPageTmp and debug the code. Below is the call stack and method processReportSummary (for summary list page view) of class LedgerTrailBalanceDP fills up the required data. Please check it and let us know if anything required.
[s] \Classes\LedgerTrialBalanceDP\processReportSummary 1 [s] \Classes\LedgerTrialBalanceDP\processReport 34 [s] \Data Dictionary\Tables\LedgerTrialBalanceListPageTmp\Methods\constructBalances 72 [c] \Forms\LedgerTrialBalanceListPage\Methods\constructBalances 8 [c] \Forms\LedgerTrialBalanceListPage\Methods\init 15 [c] \Classes\SysSetupFormRun\init 3
Hi Work,
The data is stored in the table DimensionFocusBalance. This has the cumulative amounts per account structure per day. When you start the trial balance report or open the form, it will first see if it needs to update the balances for newly created transactions. Then it will build the data in the temporary table.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
