CustomerSalesReport
The QuickBooks report CustomerSales.
Columns
| Name | Type | References | Description |
| CustomerName | String | A column for CustomerName containing Customer data. | |
| RowType | String | A column for RowType containing RowType data. | |
| RowGroup | String | A column for RowGroup containing RowGroup data. | |
| RowId | Integer | A column for RowId containing RowId data. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| DateMacro | String | A predefined date range. Use this if you want the report to cover a standard report date range. Otherwise, use the StartDate and EndDate to cover an explicit range.
The allowed values are Today, Yesterday, This Week, This Week-to-date, Last Week, Last Week-to-date, Next Week, Next 4 Weeks, This Month, This Month-to-date, Last Month, Last Month-to-date, Next Month, This Fiscal Quarter, This Fiscal Year, This Fiscal Year-to-date, Last Fiscal Year, Last Fiscal Year-to-date, Next Fiscal Year. | |
| StartDate | String | The startdate of the report. StartDate must be less than EndDate.
The default value is 2018-02-27. | |
| EndDate | String | The enddate of the report. EndDate must be greater than StartDate.
The default value is 2018-04-27. | |
| AccountingMethod | String | The accounting method used in the report.
The allowed values are Cash, Accrual. | |
| SummarizeColumnsBy | String | The criteria by which to group the report results.
The allowed values are Total, Month, Week, Days, Quarter, Year, Customers, Vendors, Classes, Departments, Employees, ProductsAndServices. | |
| Indentation | String | Add spaces at the start of values to visually identify totals and group values. | |
| Customer | String | Filters report contents to include information for specified customers. This is a comma separated list (spaces omitted after/before separating comma) of one or more Customer IDs. |