Contains comprehensive account balance details, including historical data and summaries for financial reporting.

View-Specific Information

SELECT

Note: Filter by either ReportingPeriodName or by both StartDate and EndDate. StartDate and EndDate filters are processed server-side and are recommended for improved performance. If no filters are specified, ReportingPeriodName will include all reporting periods. The following examples illustrate how to query the AccountBalance view:

SELECT * FROM AccountBalance WHERE reportingperiodname = 'Fiscal Year 2024' AND departmentid = 90

SELECT * FROM AccountBalance WHERE reportingperiodname = 'Fiscal Year 2024' AND ShowZeroBalances = 'true' AND GLAccountno = 'S009'

SELECT * FROM AccountBalance WHERE startdate = '2010-01-01' AND enddate = '2011-01-01' AND StartAccountNo = 0 AND EndAccountNo = 1099

Columns

Name	Type	Description
ReportingPeriodName	String	The name of the reporting period for the Account balances.
Glaccountno	Double	The unique general ledger account number associated with the account balance.
StartBalance	Double	The opening balance of the account for the specified period.
Debits	Double	The total debits applied to the account during the specified period.
Credits	Double	The total credits applied to the account during the specified period.
AdjDebits	Double	The total adjusted debits for the account during the specified period.
AdjCredits	Double	The total adjusted credits for the account during the specified period.
EndBalance	Double	The closing balance of the account for the specified period.
ReportingBook	String	The reporting book used for the account balance, such as a specific ledger or consolidation.
Currency	String	The currency in which the account balance is recorded.

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 starting date for the account balance query, required if reporting period name is not specified.
EndDate	String	The ending date for the account balance query, required if reporting period name is not specified.
StartAccountNo	String	The starting account number range for the query, required if reporting period name is not specified.
EndAccountNo	String	The ending account number range for the query, required if reporting period name is not specified.
ShowZeroBalances	String	Indicates whether to include accounts with zero balances in the results.