CreateARAgingDetailReport
Generates an A/R Aging Detail report schema file.
Stored Procedure Specific Information
QuickBooks Online allows only a small subset of columns to be used in the Exec query. All the columns are optional for this Stored Procedure.
This report supports multicurrency. The available columns will differ depending on whether multicurrency is enabled or disabled. Below are the columns supported for each state: multicurrency enabled or disabled.
Multicurrency disabled: supt_open_bal, subt_amount.
Multicurrency enabled: currency, exch_rate, foreign_open_bal, subt_home_open_bal, foreign_amount, subt_home_amount.
To determine if the authenticated account supports multicurrency, check with the following statement:
SELECT CurrencyPrefs_MultiCurrencyEnabled FROM Preferences;
For example:
To create the RSD file, it will be generated based on the value of the Location connection property.
EXECUTE CreateARAgingDetailReport
To return BASE64 encoded data in FileData column.
EXECUTE CreateARAgingDetailReport WriteToFile = 'False'
Input
| Name | Type | Description |
| ReportName | String | The name of the report.
デフォルト値はARAgingDetailReportです。 |
| ReportDescription | String | A description for the report. If one is not specified, a description based on the ReportType will be selected. |
| AgingMethod | String | The date upon which aging is determined.
使用できる値は次のとおりです。Report_Date, Current |
| AgingPeriod | String | The number of days in the aging period. |
| Columns | String | Column types to be shown in the report. A comma separated list of one or more of the following: bill_addr, create_date, create_by, cust_bill_email, cust_comp_name, cust_msg, cust_phone_other, cust_tel, cust_name, deliv_addr, doc_num, due_date, last_mod_by, last_mod_date, memo, past_due, sale_sent_state, ship_addr, term_name, tx_date, txn_type. Additional columns with custom fields enabled: sales_cust1, sales_cust2, sales_cust3. Additional columns with location tracking enabled: dept_name. In addition to the above, the following values are supported based on the multicurrency setting for the company. Multicurrency disabled: supt_open_bal, subt_amount. Multicurrency enabled: currency, exch_rate, foreign_open_bal, subt_home_open_bal, foreign_amount, subt_home_amount. Default=tx_date,txn_type,doc_num,cust_name,dept_name,due_date,subt_open_bal,subt_amount |
| 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. |
| NumPeriods | String | The number of periods to be shown in the report. |
| PastDue | String | Filters report contents based on minimum days past due. |
| ReportDate | String | Start date to use for the report. |
| ShipVia | String | Filter by the shipping method as specified in Invoice's ShipMethodRef. This is the name of the shipping method. |
| StartDueDate | String | The startdate of which receivables are due. StartDueDate must be less than EndDate. |
| EndDueDate | String | The enddate of which receivables are due. EndDueDate must be greater than StartDate. |
| Term | String | Filters report contents to include information for specified term or terms supplied. This is a comma separated list (spaces omitted after/before separating comma) of one or more Term IDs. |
| Indentation | String | Add spaces at the start of values to visually identify totals and group values. |
| WriteToFile | String | Whether to write to an output file or not. Defaults to true, must be set to false to write to FileStream or FileData. |
Result Set Columns
| Name | Type | Description |
| Result | String | Success or Failure. |
| SchemaFile | String | The generated schema file. |
| Columns | String | The number of columns found. |
| FileData | String | The BASE64 downloaded file content. Only returned if WriteToFile set to false and FileStream is not set. |