get_chart_of_accounts_report
Look up GL account IDs by account number or name from the chart of accounts. Returns detailed account information using specific column names.
Instructions
Returns the chart of accounts with GL account information. Use this to lookup gl_account_ids by GL account number ('number' field) or name ('account_name' field). IMPORTANT: Column names are specific - use 'number' for GL account number, 'account_name' for account name, 'gl_account_id' for internal database ID.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | No | Array of specific columns to include in the report. Valid columns: number, account_name, account_type, sub_accountof, offset_account, subject_to_tax_authority, options, fund_account, hidden, gl_account_id, sub_account_of_id, offset_account_id. If not specified, all columns are returned. NOTE: Use 'number' for GL account number, 'account_name' for account name, and 'gl_account_id' for the internal ID. |