GenerateAgedReceivableDetailReport()

Generates an AR Aging Detail 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

Aging_Method

SQL_VARCHAR(255)

The date upon which aging is determined. The default value is Report_Date.

Aging_Period

SQL_Numeric(15,2)

The number of days in the aging period. The default value is 30.

Columns

SQL_VARCHAR(255)

The column types to show in the report.

Custom1

SQL_VARCHAR(255)

The CustomField attribute in transaction entities, used for filtering.

Custom2

SQL_VARCHAR(255)

The CustomField attribute in transaction entities, used for filtering.

Custom3

SQL_VARCHAR(255)

The CustomField attribute in transaction entities, used for filtering.

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.

Num_Periods

SQL_INTEGER(signed)

The number of periods to show in the report. The default value is 4.

Past_Due

SQL_INTEGER(signed)

The number of days past due, used for filtering the report data. The report only includes data for items that have been overdue for the specified number of days or longer. The default value is null.

Report_Date

SQL_VARCHAR(255)

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

Shipvia

SQL_VARCHAR(255)

The shipping method on which to filter the report data. By default, the report includes data for all shipping methods.

Start_Duedate

SQL_VARCHAR(255)

The start date for filtering receivables due. The report only includes data for receivables that have due dates at or after the specified date. By default, the report includes data for all receivables due.

End_Duedate

SQL_VARCHAR(255)

The end date used for filtering receivables due. The report only includes data for receivables that have due dates at or before the specified date. By default, the report includes data for all receivables due.

Term

SQL_VARCHAR(255)

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

Returns

A table with a single row of data.

AgedReceivableDetailReport

SQL_LONGVARCHAR(2147483647)

The AR Aging Detail Report.