Inquiry page · General ledger

Trial balance

A list page that shows the balances of accounts and/or dimensions for a given period.

Used by: Accountant, Accounting manager, Accounting supervisor and 8 more roles
Business process: —
Menu item: LedgerTrialBalanceListPage
Main table: LedgerTrialBalanceTmp
Data entity: —
Setup steps: —

Show what matters for

Everyone

1What it is and why

What it is	A list page that shows the balances of accounts and/or dimensions for a given period.
What you do here	Used to view balances for a selected dimension set and parameters such as dates and posting layer, drill down to the transactions behind a balance, and create trial balance snapshots.
Example	Create a trial balance snapshot for a ledger, dimension set, and posting layer, and open it in Excel through its OData entity for external reporting.

Functional consultant · Solution architect

Business process	—
Menu path	General ledger › Inquiries and reports › Trial balance
Set up first	Financial dimension sets Microsoft Learn ↗Process automations Microsoft Learn ↗
Used next by	—
Related pages	Financial reports Microsoft Learn ↗Accounting source explorer Microsoft Learn ↗Voucher transactions Microsoft Learn ↗Audit trail Microsoft Learn ↗

End user · Functional consultant

On the Trial balance list page, on the Action Pane, select Trial balance snapshots.
Select Add trial balance snapshot.
In the Ledger field, select the legal entity for the snapshot.
Select the Financial dimension set and the Posting layer.
In the Fiscal years to process field, select which fiscal years to include.
Select OK to create the snapshot.
To view the results, select Open in Excel.

Field	What it means	Worked example	Table column
Parameters	Sets the dates, posting layer, how opening balances appear and which closing transaction types are shown.Microsoft Learn ↗	—	—
Fiscal years to process	Chooses which fiscal years a trial balance snapshot covers.Microsoft Learn ↗	—	—
Update balances	Starts a batch task that refreshes the dimension set balances straight away.Microsoft Learn ↗	—	—
Show external tracking ID	Shows the fixed ID that outside reporting systems can use for a snapshot.Microsoft Learn ↗	—	—

Functional consultant

Setup step	Recommended value and why	Decision · common mistake · test
— No setup is made on this page.

Solution architect

Shared or per company	—
Can it be undone	—
Feature or country	—
If you change it later	Changing the parameters refreshes the balances shown; the dates must stay within one fiscal year. Microsoft Learn ↗

Technical architect

Menu item	`LedgerTrialBalanceListPage` Checked in Dynamics 365
Form	`LedgerTrialBalanceListPage` Checked in Dynamics 365
Table	`LedgerTrialBalanceTmp`Shown as “Trial balance” in Record infoChecked in Dynamics 365
Data entities	—
Who can open it	PrivilegesView trial balance list page `LedgerTrialBalanceListPageView`DutiesInquire into chart of account master `LedgerChartOfAccountsInquire`Maintain chart of accounts master `LedgerChartOfAccountsMaintain` 11 security roles Budget clerk `BudgetBudgetClerk`Budget contributor `BudgetBudgetContributor`Budget manager `BudgetBudgetManager`Chief executive officer `CompanyChiefExecutiveOfficer`Chief financial officer `CompanyChiefFinancialOfficer`Accounts receivable manager `CustInvoiceAccountsReceivableManager`Accountant `LedgerAccountant`Accounting manager `LedgerAccountingManager`Accounting supervisor `LedgerAccountingSupervisor`Financial controller `LedgerFinancialController`Accounts payable manager `VendInvoiceAccountsPayableManager` Checked in Dynamics 365
Actions on the page	Buttons: Accounting source explorer, All transactions, Fiscal year transactions, By currency, Period, Cash flow forecasts, Columns to display, Trial balance snapshotsChecked in Dynamics 365

Developer

Open it directly	`https://<your-environment>/?mi=LedgerTrialBalanceListPage`
Integrate with	—
Table definition	—

Everyone