TrialBalances
Compiles trial balance data, including debits, credits, and adjustments for specified accounting periods.
Table Specific Information
To retrieve LocationID and DepartmentId information from the TrialBalances table, 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
| 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) |