TrialBalancesLocationDetail
Offers a location-based trial balance view, itemizing financial data and enabling site-specific financial oversight.
Columns
| Name | Type | Description |
| reportingperiodname | String | The name of the reporting period for which the trial balance is generated. |
| glaccountno | String | The general ledger account number associated with the trial balance entry. |
| startbalance | Double | The opening balance for the specified account and period. |
| debits | Double | The total debits recorded for the account during the specified period. |
| credits | Double | The total credits recorded for the account during the specified period. |
| adjdebits | Double | The total adjusted debits for the account in the specified period. |
| adjcredits | Double | The total adjusted credits for the account in the specified period. |
| endbalance | Double | The closing balance for the specified account and period. |
| reportingbook | String | The financial reporting book used for generating the trial balance. |
| currency | String | The currency in which the trial balance amounts are reported. |
| locationid | String | The identifier for the location associated with the trial balance data. |
| departmentid | String | The identifier for the department associated with the trial balance data. |
Pseudo-Columns
| Name | Type | Description |
| StartDate | String | Specifies the start date for the trial balance data, required if ReportingPeriodName is not set. |
| EndDate | String | Specifies the end date for the trial balance data, required if ReportingPeriodName is not set. |
| ShowZeroBalances | String | Indicates whether to include accounts with zero balances in the report. Use true or false. (Default: false) |
| ShowDepartmentDetail | String | Indicates whether to expand the trial balance data to show department-specific details. Use true or false. (Default: false) |
| ShowLocationDetail | String | Indicates whether to expand the trial balance data to show location-specific details. Use true or false. (Default: true) |