GenerateGeneralLedgerReport()

Generates a general ledger report based on the specified details.

Note:

All of the parameters for this stored procedure are optional query parameters. If you do not specify a value for a parameter, the connector uses the default value instead.

For complete information about the default and supported values for these parameters, see the "Query Parameters" section for the report resource that you are using the stored procedure for in the QuickBooks Online Accounting API Reference: https://developer.intuit.com/docs/api/accounting.

Parameters

Account

SQL_VARCHAR(255)

A comma-separated list of accounts used for filtering. The report only includes data that is related to the specified accounts. By default, the report includes data for all accounts.

Accounting_Method

SQL_VARCHAR(255)

The accounting method used in the report.

Account_Type

SQL_VARCHAR(255)

The account type from which to include transactions in the report. By default, transactions from all account types are included.

Source_Account_Type

SQL_VARCHAR(255)

The source account type from which to include transactions in the report.

Class

SQL_VARCHAR(255)

A comma-separated list of classes used for filtering. The report only includes data that is related to the specified classes. By default, the report includes data for all classes.

Columns

SQL_VARCHAR(255)

The column types to show in the report.

Customer

SQL_VARCHAR(255)

A comma-separated list of customer names used for filtering. The report only includes data that is related to the specified customers. By default, the report includes data for all customers.

Date_Macro

SQL_VARCHAR(255)

A predefined date range for the report. Set this parameter if you want the report to only include data from the specified standard date range. Otherwise, use Start_Date and End_Date to specify a custom date range. The default value is This Fiscal Year-to-date.

Department

SQL_VARCHAR(255)

A comma-separated list of department names used for filtering. The report only includes data that is related to the specified departments. By default, the report includes data for all departments.

Sort_By

SQL_VARCHAR(255)

The column type on which to base sorting for the rows in the report. The default value is txn_type.

Sort_Order

SQL_VARCHAR(255)

The sort order for the rows in the report. By default, the rows are sorted in ascending order based on the column type specified in the Sort_By parameter.

Source_Account

SQL_VARCHAR(255)

A comma-separated list of source accounts used for filtering. The report only includes data that is related to the specified source accounts. By default, the report includes data for all source accounts.

Start_Date

SQL_VARCHAR(255)

The start date to use for the report.

End_Date

SQL_VARCHAR(255)

The end date to use for the report.

Vendor

SQL_VARCHAR(255)

A comma-separated list of vendor names used for filtering. The report only includes data that is related to the specified vendors. By default, the report includes data for all vendors.

Returns

A table with a single row of data.

GeneralLedgerReport

SQL_LONGVARCHAR(2147483647)

The general ledger report.