Compiles trial balance data, including debits, credits, and adjustments for specified accounting periods.

View-Specific Information

Note: You can filter by either ReportingPeriodName or by both the StartDate and EndDate. StartDate and EndDate filters are processed server-side and are recommended for improved performance. If no filters are specified, results are returned across all reporting periods.

To retrieve LocationID and DepartmentId information from the TrialBalances view, ensure that the ShowLocationDetail and ShowDepartmentDetail options are set to TRUE. For example:

SELECT * FROM TrialBalances WHERE ShowLocationDetail=TRUE AND ShowDepartmentDetail=TRUE

Note: For advanced filtering options, use the CreateTrialBalancesReportSchema stored procedure. This procedure supports additional filters that are not directly available in the TrialBalances view.

Columns

Name	Type	Description
Reportingperiodname	String	The name of the reporting period for the trial balances.
Glaccountno	String	The general ledger account number associated with the trial balance.
Startbalance	Double	The starting balance for the trial balance period.
Debits	Double	The total debits recorded for the trial balance period.
Credits	Double	The total credits recorded for the trial balance period.
Adjdebits	Double	The total adjustments to debits for the trial balance period.
Adjcredits	Double	The total adjustments to credits for the trial balance period.
Endbalance	Double	The ending balance for the trial balance period.
Reportingbook	String	The reporting book associated with the trial balance.
Currency	String	The currency used for the trial balance.
Locationid	String	The location identifier for the trial balance.
Departmentid	String	The department identifier for the trial balance.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
StartDate	String	The start date for the trial balance report, required if ReportingPeriodName is not set.
EndDate	String	The end date for the trial balance report, required if ReportingPeriodName is not set.
ShowZeroBalances	String	Show zero balance accounts. Use true or false. (Default: false)
ShowDepartmentDetail	String	Expand department detail. Use true or false. (Default: false)
ShowLocationDetail	String	Expand location detail. Use true or false. (Default: false)