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

CreateVendorBalanceDetailReport

CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

Generates a Vendor Balance Detail report schema file.

Input

Name Type Description
ReportName String The name of the report.

The default value is VendorBalanceDetailReport.

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.

APPaid String The status of the balance.

The allowed values are Paid, Unpaid, All.

The default value is Unpaid.

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, 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, rbal_neg_open_bal, subt_neg_amount. Multicurrency enabled: currency, exch_rate, neg_foreign_open_bal, subt_neg_home_open_bal, rbal_neg_home_open_bal. Default=tx_date,txn_type,doc_num,dept_name,subt_neg_amount,subt_net_open_bal, rbal_neg_open_bal
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.

Department String Filters report contents based on term or terms supplied. This is a comma separated list (spaces omitted after/before separating comma) of one or more Department IDs.
DueDateMacro 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.

ReportDate String Start date to use for the report.
StartDueDate String The startduedate of which receivables are due. StartDueDate must be less than EndDueDate.
EndDueDate String The endduedate of the report. EndDueDate must be greater than StartDueDate.
SortBy String The column type used in sorting report rows. Specify one of the Columns from the Columns input.
SortOrder String The sort ordering.

The allowed values are ascend, descend.

The default value is ascend.

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