GenerateInventoryValuationSummaryReport()

Generates an inventory valuation summary 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

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.

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.

Qzurl

SQL_VARCHAR(255)

A Boolean value specifying whether Quick Zoom URL information is generated for the rows in the report. The default value is false.

Report_Date

SQL_VARCHAR(255)

The start date to use for the report. The default value is the current date.

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.

InventoryValuationSummaryReport

SQL_LONGVARCHAR(2147483647)

The inventory valuation summary report.