Quickbook Create Invoice with QTY

Feature Requests Nodes
1

Is the offical Quickbook node can do

Create Invoice with “Qty”: 4?

I cannt find any options to do so and it is pretty basic

[
{
"domain": "QBO",
"sparse": false,
"Id": "28819",
"SyncToken": "0",
"MetaData": {
"CreateTime": "2022-04-07T19:50:35-07:00",
"LastUpdatedTime": "2022-04-07T19:50:39-07:00"
},
"CustomField": [
],
"DocNumber": "1325",
"TxnDate": "2022-04-08",
"CurrencyRef": {
"value": "AUD",
"name": "Australian Dollar"
},
"TxnStatus": "Pending",
"Line": [
{
"Id": "1",
"LineNum": 1,
"Description": "Remove Computer Equipment and Rack from premises and reinstall after completion of flooring",
"Amount": 545.45,
"DetailType": "SalesItemLineDetail",
"SalesItemLineDetail": {
"ItemRef": {
"value": "13",
"name": "IT Support Work:220 IT Procurement"
},
"UnitPrice": 136.3625,
"Qty": 4,
"TaxCodeRef": {
"value": "11"
}
}
},
{
"Amount": 545.45,
"DetailType": "SubTotalLineDetail",
"SubTotalLineDetail": {
}
}
],
"TxnTaxDetail": {
"TotalTax": 54.55,
"TaxLine": [
{
"Amount": 54.55,
"DetailType": "TaxLineDetail",
"TaxLineDetail": {
"TaxRateRef": {
"value": "20"
},
"PercentBased": true,
"TaxPercent": 10,
"NetAmountTaxable": 545.45
}
}
]
},
"CustomerRef": {
"value": "924",
"name": "Test Customer"
},
"CustomerMemo": {
"value": "Please find attached quote as requested, if you have any queries or would like to order please let us know. Thanks for your business. Bit Precision"
},
"GlobalTaxCalculation": "TaxInclusive",
"TotalAmt": 600,
"PrintStatus": "NotSet",
"EmailStatus": "EmailSent",
"BillEmail": {
"Address": "[email protected]"
},
"DeliveryInfo": {
"DeliveryType": "Email",
"DeliveryTime": "2022-04-07T19:50:39-07:00"
}
}
]
2

Hi @Victor_Tong, the quantity field would be called “Amount” on the QuickBooks Online node when creating an invoice:

image
image580×762 28.8 KB

1 Like
3

Thanks mate
I double check with the getinvoice
There is a thing actually call “Amount”

{
        "Id": "1",
        "LineNum": 1,
        "Description": "Siemens 西門子 座地式洗碗碟機 SN23HI60CE",
        "Amount": 10160,
        "DetailType": "SalesItemLineDetail",
        "SalesItemLineDetail": {
          "ItemRef": {
            "value": "7048",
            "name": "Kitchen Appliance:Siemens 西門子 座地式洗碗碟機 SN23HI60CE"
          },
          "UnitPrice": 10160,
          "Qty": 1
        }
      },
4

Double check with both Sandbox and production Account
Both have “Amount” & “QTY”

5

I am so sorry, I clearly mixed these up here :see_no_evil:

Seems like the node doesn’t have support for the Qty field I am afraid. I shall convert this question into a feature request so we can consider adding it in the future.

In the meantime, perhaps you might want to consider using the HTTP Request node to send the required API request to your account?

6

@MutedJam No worry, Just a bit painful to setup with QuickBook

Thanks

7

hey Jam,

I realize I have no idea how to do http request on the 0Auth 2

Can you share some ideas?

8

If you already have your Quickbooks node credentials set up you can reuse them by selecting “Predefined Credential Type”:

Screenshot from 2022-12-17 10-16-50
Screenshot from 2022-12-17 10-16-50520×546 32.3 KB

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.