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

CreateCustomerBalanceDetailReport

CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

Generates a Customer Balance detail report schema file.

Input

Name Type Description
ReportName String The name of the report.

The default value is CustomerBalanceDetailReport.

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.

The allowed values are Report_Date, Current.

ARPaid String The accounts receivable paid status.

The allowed values are All, Paid, Unpaid.

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: bill_addr, create_by, create_date, 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, sale_sent_state, ship_addr, ship_date, ship_via, term_name, tracking_num, 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: subt_open_bal, rbal_open_bal, subt_amount. MultiCurrency Enabled: currency, exch_rate, foreign_open_bal, subt_home_open_bal, rbal_home_open_bal, foreign_amount, subt_home_amount. Default= tx_date,txn_type,doc_num,dept_name,due_date,subt_amount,subt_open_bal,rbal_open_bal
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.
Department String Filters report contents to include information for specified departments if so configured in the company file. This is a comma separated list (spaces omitted after/before separating comma) of one or more Department IDs.
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.
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.

StartDueDate String The startdate of the report. StartDate must be less than EndDate.
EndDueDate String The enddate of the report. EndDate 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.

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