GenerateClassSalesReport()

Generates a class sales 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

Accounting_Method

SQL_VARCHAR(255)

The accounting method used 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.

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.

Item

SQL_VARCHAR(255)

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

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.

Summarize_Column_By

SQL_VARCHAR(255)

The criteria to use for grouping the report results. The default value is Total.

Returns

A table with a single row of data.

ClassSalesReport

SQL_LONGVARCHAR(2147483647)

The class sales report.