CData BizTalk Adapter for QuickBooks Online 2019 - Online Help
Questions / Feedback?

CreateAPAgingDetailReport

CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

Generates an A/P Aging Detail report schema file.

Input

Name Type Description
ReportName String The name of the report.

The default value is APAgingDetailReport.

ReportDescription String A description for the report. If one is not specified, a description based on the ReportType will be selected.
AccountingMethod String The accounting method used in the report.

The allowed values are Cash, Accrual.

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: create_by, create_date, doc_num, due_date, last_mod_by, last_mod_date, memo, past_due, term_name, tx_date, txn_type, vend_bill_addr, vend_comp_name, vend_name, vend_pri_cont, vend_pri_email, vend_pri_tel. 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: subt_net_open_bal, subt_neg_amount. Multicurrency enabled: currency, exch_rate, neg_foreign_open_bal, subt_neg_home_open_bal, neg_foreign_amount, subt_neg_home_amount. Default=tx_date,txn_type,doc_num,vend_name,dept_name,due_date,past_due,subt_neg_amount,subt_net_open_bal
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 the recievables are due. StartDueDate must be less than EndDueDate.
EndDueDate String The enddate of which the recievables are due. EndDueDate must be greater than StartDueDate.
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.
Vendor String Filters report contents to include information for specified vendors. This is a comma separated list (spaces omitted after/before separating comma) of one or more Vendor IDs.
Indentation String Add spaces at the start of values to visually identify totals and group values.

Result Set Columns

Name Type Description
Result String Success or Failure.
SchemaFile String The generated schema file.
Columns String The number of columns found.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0