CreateTrialBalancesReport
Creates a schema file for the specified custom report.
Input
| Name | Type | Description |
| Reportingperiodname | String | Required if StartDate AND EndDate is not set. |
| StartDate | String | Required if ReportingPeriodName is not set. |
| EndDate | String | Required if ReportingPeriodName is not set. |
| Showzerobalances | String | Show zero balance accounts. Use true or false. (Default: false) |
| Showdeptdetail | String | Expand department detail. Use true or false. (Default: false) |
| Showlocdetail | String | Expand location detail. Use true or false. (Default: false) |
| ReportingBook | String | Reporting book ID. Use ACCRUAL or CASH depending on the company configuration. If Global Consolidations is enabled, you can provide a consolidation book ID instead. (Default: Configured reporting book ID) |
| AdjBooks | String | Adjustment book IDs for journals that are enabled in the GL configuration. Use GAAP, TAX, and/or the IDs of user defined books. |
| IncludeReportingBook | String | Combine reporting book with other adjustment books. Use true to include the reporting book entries with entries from the specified adjustment books, or false to return only entries for the specified adjustment books. |
| Statistical | String | Statistical accounts. Use either include, exclude, or only. (Default: include) |
| DepartmentId | String | Department ID. |
| DeptSubs | String | Include department subs. (Default: true) |
| LocationId | String | Location ID. This field is required in a multi-base currency company. |
| LocSubs | String | Include location subs. (Default: true) |
| ProjectId | String | Project ID or project group ID. |
| ProjecttypeId | String | Project type. Do not use if Project ID is set. |
| TaskId | String | Task ID. Only available when the parent projectid is also specified. |
| Taskidsubs | String | Include task sub dimensions. (Default: true). |
| CustomerId | String | Customer ID or customer group ID. |
| CustomeridSubs | String | Include customer subs. (Default: true) |
| VendorId | String | Vendor ID or vendor group ID. |
| VendoridSubs | String | Include vendor subs. (Default: true) |
| VendortypeId | String | Vendor type. Do not use if Vendor ID is set. |
| EmployeeId | String | Employee ID or employee group ID. |
| EmployeeIdSubs | String | Include employee subs. (Default: true) |
| EmployeeTypeId | String | Employee type. Do not use if Employee ID is set. |
| ItemId | String | Item ID or item group ID. |
| ProductlineId | String | Product line. Do not use if Item ID is set. |
| Classid | String | Class ID or class group ID. |
| ClassidSubs | String | Include class subs. (Default: true) |
| Contractid | String | Contract ID or contract group ID. |
| ContractidSubs | String | Include contract subs. (Default: true) |
| Warehouseid | String | Warehouse ID or warehouse group ID. |
Result Set Columns
| Name | Type | Description |
| Reportingperiodname | String | |
| Glaccountno | String | |
| Startbalance | Double | |
| Debits | Double | |
| Credits | Double | |
| Adjdebits | Double | |
| Adjcredits | Double | |
| Endbalance | Double | |
| Currency | String | |
| LocationId | String | Location ID. This field is required in a multi-base currency company. |
| ReportingBook | String | Reporting book ID. Use ACCRUAL or CASH depending on the company configuration. If Global Consolidations is enabled, you can provide a consolidation book ID instead. (Default: Configured reporting book ID) |