View as Markdown
QuickBooks icon

QuickBooks ACTION

Create AP Aging Detail Report

Creates an AP aging report in Quickbooks Online. See the documentation
  • Action
  • Writes data
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's QuickBooks account once, then configure and run Create AP Aging Detail Report from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "quickbooks-create-ap-aging-report",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    quickbooks: { authProvisionId: "apn_xxxxxxx" },
    shipvia: "Ship Via",
    termIds: ["Term IDs"],
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Create AP Aging Detail Report inputs
Property Type Description
shipvia Ship Via string
Filter by the shipping method
Optional
termIds Term IDs string[]
Filters report contents based on term or terms supplied
Optional Dynamic
startDueDate Start Due Date string
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.
Optional
endDueDate End Due Date string
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.
Optional
accountingMethod Accounting Method string
The accounting method used in the report
Optional
reportDate Report Date string
Start date to use for the report, in the format YYYY-MM-DD
Optional
numPeriods Num Periods integer
The number of periods to be shown in the report
Optional
vendorIds Vendor IDs string[]
Filters report contents to include information for specified vendors
Optional Dynamic
pastDue Past Due integer
Filters report contents based on minimum days past due
Optional
agingPeriod Aging Period integer
The number of days in the aging period
Optional
columns Columns string[]
Column types to be shown in the report
Optional

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
quickbooks-create-ap-aging-report
Version
0.0.8
App
QuickBooks
Authentication
OAuth
Read-only
No
Destructive
No
Open world
Yes