QuickBooks
QUICKBOOKS_VENDOR_BALANCE_DETAIL
Generate a balance detail report for a vendor in QuickBooks with the given vendor ID.
Remote quickbooks
Remote (network-hosted)
Other tools also called QUICKBOOKS_VENDOR_BALANCE_DETAIL?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"appaid": {
"enum": [
"All",
"Paid",
"Unpaid"
],
"type": "string",
"title": "Arpaid",
"default": null,
"nullable": true,
"description": "Status of the balance."
},
"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. "
},
"date_macro": {
"enum": [
"Today",
"Yesterday",
"This Week",
"Last Week",
"This Week-to-date",
"Last Week-to-date",
"Next Week",
"Next 4 Weeks",
"This Month",
"Last Month",
"This Month-to-date",
"Last Month-to-date",
"Next Month",
"This Fiscal Quarter",
"Last Fiscal Quarter",
"This Fiscal Quarter-to-date",
"Last Fiscal Quarter-to-date",
"Next Fiscal Quarter",
"This Fiscal Year",
"Last Fiscal Year",
"This Fiscal Year-to-date",
"Last Fiscal Year-to-date",
"Next Fiscal Year"
],
"type": "string",
"title": "DateMacro",
"default": null,
"nullable": true,
"description": "Predefined date range. Use if you want the report to cover a standard report date range; otherwise, use the start_date and end_date to cover an explicit report date range."
},
"sort_order": {
"enum": [
"ascend",
"descend"
],
"type": "string",
"title": "SortOrder",
"default": null,
"nullable": true,
"description": "The sort order."
},
"vendor_ids": {
"type": "array",
"items": {
"type": "string",
"properties": {}
},
"title": "Vendor Ids",
"default": null,
"nullable": true,
"description": "One or more comma separated vendor IDs. Filters report contents to include information for specified vendors. "
},
"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."
},
"duedate_macro": {
"enum": [
"Today",
"Yesterday",
"This Week",
"Last Week",
"This Week-to-date",
"Last Week-to-date",
"Next Week",
"Next 4 Weeks",
"This Month",
"Last Month",
"This Month-to-date",
"Last Month-to-date",
"Next Month",
"This Fiscal Quarter",
"Last Fiscal Quarter",
"This Fiscal Quarter-to-date",
"Last Fiscal Quarter-to-date",
"Next Fiscal Quarter",
"This Fiscal Year",
"Last Fiscal Year",
"This Fiscal Year-to-date",
"Last Fiscal Year-to-date",
"Next Fiscal Year"
],
"type": "string",
"title": "DateMacro",
"default": null,
"nullable": true,
"description": "Predefined date range of due dates for balances to include in the report; otherwise, use the start_duedate and end_duedate to cover an explicit report date range. "
},
"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. "
},
"accounting_method": {
"enum": [
"Cash",
"Accrual"
],
"type": "string",
"title": "AccountingMethod",
"default": null,
"nullable": true,
"description": "The accounting method used in the report."
}
}
}