Services Plugins FAQs

QuickBooks Plugin - Invoice Queries

I am thoroughly enjoying using the QuickBooks plugin! There are a couple data fields missing in the Invoice Query action such as:

  • CustomField’s String Value
    “CustomField”: [
    {
    “DefinitionId”: “1”,
    “Name”: “Name”,
    “Type”: “StringType”,
    “StringValue”: “Invoice”
    }

  • DocNumber

  • TxnTaxDetail
    “TxnTaxDetail”: {
    “TxnTaxCodeRef”: {
    “value”: “95”
    },
    “TotalTax”: 962.75,
    “TaxLine”: [
    {
    “Amount”: 962.75,
    “DetailType”: “TaxLineDetail”,
    “TaxLineDetail”: {
    “TaxRateRef”: {
    “value”: “102”
    },
    “PercentBased”: true,
    “TaxPercent”: 8.6,
    “NetAmountTaxable”: 11194.81
    }
    }
    ]

I maybe just missing it but I cannot seem to access these fields from the Invoice Query. I would really appreciate if these data fields could be added to the app.

Thank you!

Hi @joseph,

Thanks for using our products. Could you please specify whether it is Quickbooks Authenticate or Quickbooks Accounting plugin, because both include the Query Invoice data call, but the Accounting plugin is not working on our side, unfortunately. Also, it would be best to share a couple of screenshots of each field that you’re trying to get, and which is not available. We’ll check on them and I’ll get back to you with a reply on this matter asap.

Best,
Alex

Hi @alexandru,

This is for the Quickbooks Accounting plugin. I haven’t checked out the Quickbooks Authenticate plugin as I thought it was only for authenticating purposes. Would you recommend I use QB Authenticate as that one is working for you guys?

Below is a example invoice object and I put in bold what is missing. Everything else seems obtainable.
Thank you for your help.

{
“Invoice”: {
“TxnDate”: “2014-09-19”,
“domain”: “QBO”,
“PrintStatus”: “NeedToPrint”,
“SalesTermRef”: {
“value”: “3”
},
“TotalAmt”: 362.07,
“Line”: [
{
“Description”: “Rock Fountain”,
“DetailType”: “SalesItemLineDetail”,
“SalesItemLineDetail”: {
“TaxCodeRef”: {
“value”: “TAX”
},
“Qty”: 1,
“UnitPrice”: 275,
“ItemRef”: {
“name”: “Rock Fountain”,
“value”: “5”
}
},
“LineNum”: 1,
“Amount”: 275.0,
“Id”: “1”
},
{
“Description”: “Fountain Pump”,
“DetailType”: “SalesItemLineDetail”,
“SalesItemLineDetail”: {
“TaxCodeRef”: {
“value”: “TAX”
},
“Qty”: 1,
“UnitPrice”: 12.75,
“ItemRef”: {
“name”: “Pump”,
“value”: “11”
}
},
“LineNum”: 2,
“Amount”: 12.75,
“Id”: “2”
},
{
“Description”: “Concrete for fountain installation”,
“DetailType”: “SalesItemLineDetail”,
“SalesItemLineDetail”: {
“TaxCodeRef”: {
“value”: “TAX”
},
“Qty”: 5,
“UnitPrice”: 9.5,
“ItemRef”: {
“name”: “Concrete”,
“value”: “3”
}
},
“LineNum”: 3,
“Amount”: 47.5,
“Id”: “3”
},
{
“DetailType”: “SubTotalLineDetail”,
“Amount”: 335.25,
“SubTotalLineDetail”: {}
}
],
“DueDate”: “2014-10-19”,
“ApplyTaxAfterDiscount”: false,
"DocNumber": “1037”,
“sparse”: false,
“CustomerMemo”: {
“value”: “Thank you for your business and have a great day!”
},
“Deposit”: 0,
“Balance”: 362.07,
“CustomerRef”: {
“name”: “Sonnenschein Family Store”,
“value”: “24”
},
"TxnTaxDetail": {
** “TxnTaxCodeRef”: {**
** “value”: “2”**
** }, **
** “TotalTax”: 26.82, **
** “TaxLine”: [**
** {**
** “DetailType”: “TaxLineDetail”, **
** “Amount”: 26.82, **
** “TaxLineDetail”: {**
** “NetAmountTaxable”: 335.25, **
** “TaxPercent”: 8, **
** “TaxRateRef”: {**
** “value”: “3”**
** }, **
** “PercentBased”: true**
** }**
** }**
** ]**
** },**
“SyncToken”: “0”,
“LinkedTxn”: [
{
“TxnId”: “100”,
“TxnType”: “Estimate”
}
],
“BillEmail”: {
“Address”: “Familiystore@intuit.com
},
“ShipAddr”: {
“City”: “Middlefield”,
“Line1”: “5647 Cypress Hill Ave.”,
“PostalCode”: “94303”,
“Lat”: “37.4238562”,
“Long”: “-122.1141681”,
“CountrySubDivisionCode”: “CA”,
“Id”: “25”
},
“EmailStatus”: “NotSet”,
“BillAddr”: {
“Line4”: “Middlefield, CA 94303”,
“Line3”: “5647 Cypress Hill Ave.”,
“Line2”: “Sonnenschein Family Store”,
“Line1”: “Russ Sonnenschein”,
“Long”: “-122.1141681”,
“Lat”: “37.4238562”,
“Id”: “95”
},
“MetaData”: {
“CreateTime”: “2014-09-19T13:16:17-07:00”,
“LastUpdatedTime”: “2014-09-19T13:16:17-07:00”
},
“CustomField”: [
{
“DefinitionId”: “1”,
"StringValue": “102”,
“Type”: “StringType”,
“Name”: “Crew #”
}
],
“Id”: “130”
},
“time”: “2015-07-24T10:48:27.082-07:00”
}

Hi @joseph,

Thanks for your feedback. Unfortunately, we cannot provide exact solutions yet. Could you please go to Settings - Collaboration tab within your editor. Add our plugins@zeroqode.com account to your collaborator’s list. Also, please tell us your app name and page name where this problem occurs on test.

Note: avoid the warning message regarding plan, as we are an agency and you can easily add us to your collaborators.

We’ll investigate it inside your app and get back to you with a feedback asap. :pray:

I was wondering if you ever got to the bottom of this @joseph — I’d also like to access the DocNumber?