QuickBooks MCP create-invoice action — customer pagination, CAD currency, and detailed invoice-line configuration issue

I’m using Pipedream’s hosted QuickBooks MCP server through ChatGPT Business:

https://mcp.pipedream.net/v2

The QuickBooks connection is active and exposes 65 tools. Read actions work correctly against Conex Group, Canada, but quickbooks-create-invoice is not configuring invoices correctly.

We reproduced three specific issues:

1. Customer option pagination

The create action treated only the first 10 customer options as valid and rejected QBO Customer ID 165 — Becker’s 3066084.

However:

customer 165 exists and is active,
direct QBO reads retrieve it correctly,
and customer-options page 1 contains ID 165.

The first page appears to have been treated as the complete customer list.

2. CAD missing from currency options

QBO Preferences confirms:

HomeCurrency = CAD

and the selected customer is CAD.

However, the create-invoice action offered only USD/EUR-derived options and rejected CAD.

Please verify that the company home currency is included and that the selected value is normalized to ISO code CAD.

3. Detailed invoice lines are not exposed correctly

The action exposed lineItemsAsObjects as a Boolean, but the writer could not find a field for supplying the actual detailed invoice lines.

Pipedream’s published QuickBooks create-invoice component indicates that setting:

lineItemsAsObjects = true

requires a dynamic-property reload, after which lineItems should become available.

Please verify that this reload/configuration occurs correctly in the hosted MCP action.

We need the action to support native invoice data including:

existing QBO Customer ID
DocNumber
TxnDate
CAD currency
complete item lines
existing QBO Item ID
Qty
UnitPrice
Amount
tax reference where required

The action should return either:

the native QBO Invoice.Id and response,
an explicit QBO/connector error,
or an explicit uncertain outcome.

One earlier create attempt returned empty text with no Invoice ID and no explicit error. A later smoke test exposed the customer, currency, and detailed-line configuration problems above. No invoice was found afterward in QBO.

Please inspect:

the deployed QuickBooks create-invoice component/version,
customer option pagination,
CAD/home-currency handling,
dynamic lineItemsAsObjects → lineItems loading,
whether TxnDate is supported,
and whether the action returns the actual QBO response/Invoice ID or a clear error.

Please do not replay either test invoice or modify our QuickBooks connection or QBO data without asking first.

We would prefer to repair the existing hosted connection and retain its current QuickBooks authentication if possible.

[Conex_QBO_Writer_Configuration_Diagnosis_2026-09-10.md](https://github.com/user-attachments/files/32084626/Conex_QBO_Writer_Configuration_Diagnosis_2026-09-10.md)

Start by inspecting the deployed QuickBooks create-invoice component/version and its hosted MCP action configuration. Trace customer option pagination, home-currency normalization, and the lineItemsAsObjects-to-lineItems reload, then check TxnDate support and response handling. Done means valid CAD invoices can use the existing customer and item IDs, detailed lines are configurable, and the action returns an Invoice ID, explicit connector error, or explicit uncertain outcome.

Written by the indexing model from the issue text.