QuickBooks

QUICKBOOKS_CUSTOMER_BALANCE_REPORT

Generate a balance report for a customer in QuickBooks with the given customer ID.

Remote quickbooks

Remote (network-hosted)

Other tools also called QUICKBOOKS_CUSTOMER_BALANCE_REPORT? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "arpaid": {
      "enum": [
        "All",
        "Paid",
        "Unpaid"
      ],
      "type": "string",
      "title": "Arpaid",
      "default": null,
      "nullable": true,
      "description": "Supported Values: All, Paid, Unpaid"
    },
    "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."
    },
    "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."
    },
    "customer_ids": {
      "type": "array",
      "items": {
        "type": "string",
        "properties": {}
      },
      "title": "Customer Ids",
      "default": null,
      "nullable": true,
      "description": "Filters report contents to include information for specified customers. Supported Values: One or more comma separated customer IDs as returned in the attribute, Customer.Id, of the Customer object response code."
    },
    "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. "
    },
    "summarize_column_by": {
      "enum": [
        "Total",
        "Month",
        "Week",
        "Days",
        "Quarter",
        "Year",
        "Customers",
        "Vendors",
        "Classes",
        "Departments",
        "Employees",
        "ProductsAndServices"
      ],
      "type": "string",
      "title": "SummarizeColumnBy",
      "default": null,
      "nullable": true,
      "description": "The criteria by which to group the report results."
    }
  }
}