Quickbooks Create Invoice fails due to Quantity not implemented.

[haruny]

Describe the problem/error/question

Quickbooks Node does not work due to missing Quantity option

What is the error message (if any)?

400 - {"Fault":{"Error":[{"Message":"Missing Inventory Item Quantity","Detail":"Quantity required for inventory item","code":"6520","element":""}],"type":"ValidationFault"},"time":"2025-01-30T10:22:16.013-08:00"}

Please share your workflow/screenshots/recording

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
⚠️ WARNING ⚠️ If you have sensitive data in your workflow (like API keys), please remove it before sharing.

{
"nodes": [
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"documentId": {
"__rl": true,
"value": "1OIRF9qZjx5Hy8y4WOXBz0jr2RcAp8dwUknWvNXR62m4",
"mode": "list",
"cachedResultName": "eBay Transaction History",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/XXXX/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Ebay TXN",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/XXX/edit#gid=0"
},
"includeInOutput": "both",
"options": {
"columnsToWatch": [
"Processed"
]
}
},
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
-1740,
-880
],
"id": "42c8e473-79e1-4d5a-8b9a-a5e8c3d3f979",
"name": "Google Sheets Trigger",
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "tVSivBwEFMwzPURU",
"name": "Google Sheets Trigger account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "3dafb36e-4340-4b98-9247-7c2164136075",
"leftValue": "={{ $json.Type }}",
"rightValue": "Order",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-1360,
-860
],
"id": "e9e8d435-5311-40f6-9dfe-1b7f8c2b49ec",
"name": "If not Y"
},
{
"parameters": {
"resource": "invoice",
"operation": "create",
"CustomerRef": "101",
"Line": [
{
"Amount": "={{ $json['Item subtotal'] }}",
"itemId": "={{ parseInt($json['QBO Product']) }}",
"Description": "={{ $json['Item title'] }}",
"TaxCodeRef": "NON",
"LineNum": 1,
"DetailType": "SalesItemLineDetail"
},
{
"Amount": "={{ $json['eBay collected tax'] }}",
"itemId": "264",
"LineNum": 2,
"Description": "Sales Tax",
"TaxCodeRef": "NON",
"DetailType": "SalesItemLineDetail"
},
{
"Amount": "={{ $json['Shipping and handling']+0 }}",
"Description": "Shipping Charges",
"itemId": "414",
"TaxCodeRef": "NON",
"LineNum": 3,
"DetailType": "SalesItemLineDetail"
}
],
"additionalFields": {
"CustomerMemo": "={{ $json['Order number'] }}",
"DocNumber": "={{ $json['Order number'] }}",
"DueDate": "={{ new Date(Date.UTC(0, 0, $json['Transaction creation date'] - 1)) }}",
"ShipAddr": "={{ $json['Ship to city'] }}, {{ $json['Ship to province/region/state'] }}, {{ $json['Ship to zip'] }}, {{ $json['Ship to country'] }}",
"TotalAmt": "={{ \nparseFloat($json['Item subtotal'])\n+\nparseFloat($json['eBay collected tax'])\n+\nparseFloat($json['Shipping and handling']+0)\n}}",
"TxnDate": "={{ new Date(Date.UTC(0, 0, $json['Transaction creation date'] - 1)) }}"
}
},
"type": "n8n-nodes-base.quickbooks",
"typeVersion": 1,
"position": [
-1140,
-960
],
"id": "7bbe630d-e9f4-4ac5-a8cf-2d6020db12e9",
"name": "QuickBooks Online",
"notesInFlow": false,
"alwaysOutputData": false,
"executeOnce": true,
"credentials": {
"quickBooksOAuth2Api": {
"id": "kzb18FFaf0gTOGt2",
"name": "QuickBooks Online account"
}
}
}
],
"connections": {
"Google Sheets Trigger": {
"main": [
[
{
"node": "If not Y",
"type": "main",
"index": 0
}
]
]
},
"If not Y": {
"main": [
[
{
"node": "QuickBooks Online",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "XXXX"
}
}

Share the output returned by the last node

From QuickBooks Online
Error code

400

Full message

{ "Fault": { "Error": [ { "Message": "Missing Inventory Item Quantity", "Detail": "Quantity required for inventory item", "code": "6520", "element": "" } ], "type": "ValidationFault" }, "time": "2025-01-30T10:22:16.013-08:00" }
Other info
Node type

n8n-nodes-base.quickbooks

Node version

1 (Latest)

n8n version

1.76.1 (Cloud)

Time

1/30/2025, 10:22:16 AM

Stack trace

NodeApiError: Bad request - please check your parameters at ExecuteContext.quickBooksApiRequest (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/QuickBooks/GenericFunctions.js:65:15) at processTicksAndRejections (node:internal/process/task_queues:95:5) at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/QuickBooks/QuickBooks.node.js:409:40) at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/execution-engine/workflow-execute.js:632:19) at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/execution-engine/workflow-execute.js:890:51 at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/execution-engine/workflow-execute.js:1224:20

Debug info

core

• n8nVersion: 1.76.1
• platform: docker (cloud)
• nodeJsVersion: 20.18.2
• database: sqlite
• executionMode: regular
• concurrency: 5
• license: community

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 168 hours
• maxCount: 2500 executions

client

• userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/132.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2025-01-30T18:19:59.954Z}

[Joffcom]

Hey @haruny,

We have created an internal ticket to look into this which we will be tracking as "GHC-676"