QuickBooks
QUICKBOOKS_CUSTOMER_BALANCE_DETAIL
Generate a balance detail report for a customer in QuickBooks with the given customer ID.
Remote quickbooks
Remote (network-hosted)
Other tools also called QUICKBOOKS_CUSTOMER_BALANCE_DETAIL?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"arpaid": {
"enum": [
"All",
"Paid",
"Unpaid"
],
"type": "string",
"title": "Arpaid",
"default": null,
"nullable": true,
"description": "Status of the balance."
},
"columns": {
"type": "string",
"title": "Columns",
"default": null,
"nullable": true,
"description": "Column types to be shown in the report. Supported Values: 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*"
},
"custom1": {
"type": "string",
"title": "Custom1",
"default": null,
"nullable": true,
"description": "Filter by the specified custom field as defined by the CustomField attribute in transaction entities where supported. Supported Values: Name of custom field."
},
"shipvia": {
"type": "string",
"title": "Shipvia",
"default": null,
"nullable": true,
"description": "Filter by the shipping method as stored in Invoice.ShipMethodRef.Name."
},
"sort_by": {
"type": "string",
"title": "Sort By",
"default": null,
"nullable": true,
"description": "The column type used in sorting report rows. Specify a column type as defined with the columns query parameter."
},
"term_ids": {
"type": "array",
"items": {
"type": "string",
"properties": {}
},
"title": "Term Ids",
"default": null,
"nullable": true,
"description": "One or more comma separated term IDs. Filters report contents based on term or terms supplied. "
},
"sort_order": {
"enum": [
"ascend",
"descend"
],
"type": "string",
"title": "SortOrder",
"default": null,
"nullable": true,
"description": "The sort order."
},
"end_duedate": {
"type": "string",
"title": "End Duedate",
"default": null,
"nullable": true,
"description": "The range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned."
},
"report_date": {
"type": "string",
"title": "Report Date",
"default": null,
"nullable": true,
"description": "Start date to use for the report, in the format YYYY-MM-DD."
},
"aging_method": {
"enum": [
"Report_Date",
"Current"
],
"type": "string",
"title": "AgingMethod",
"default": null,
"nullable": true,
"description": "The date upon which aging is determined."
},
"customer_ids": {
"type": "array",
"items": {
"type": "string",
"properties": {}
},
"title": "Customer Ids",
"default": null,
"nullable": true,
"description": "One or more comma separated customer IDs. Filters report contents to include information for specified customers. "
},
"start_duedate": {
"type": "string",
"title": "Start Duedate",
"default": null,
"nullable": true,
"description": "The range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned."
},
"department_ids": {
"type": "array",
"items": {
"type": "string",
"properties": {}
},
"title": "Department Ids",
"default": null,
"nullable": true,
"description": "One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file. "
}
}
}