Questions tagged [qbxml]

Quickbooks XML is used communicate with most versions of Quickbooks, including Online Edition

Quickbooks XML is a data format that is used to make SDK calls to most versions of Quickbooks. It is preferred over the legacy IIF format because it runs through the API, and is thus constrained to behave more like the QB frontend. QBXML is also bi-directional, while IIF can only insert data.

If you do not have a local Microsoft COM program running on your machine to connect to your instance of QB directly, you can use to make your QBXML calls via a remote web server.

The complete QBXML reference can be found in the Intuit OSR

307 questions
1
vote
1 answer

quickbook desktop Webconnector : Insufficient permission level to perform this action

I'm trying to open a file from a old Company in quickBooks desktop webconnector. This time it Returns status code = 3260 and also show message like Insufficient permission level to perform this action
1
vote
1 answer

How to query for multiple invoices with quickbooks QBXML InvoiceQueryRq?

I'm using PHP to generate QBXML to query quickbooks to find an invoice record. This is working. However, now I want to query for two different invoice RefNumbers. This is my current code to query one invoice: $qbxml = '
user1855093
  • 373
  • 1
  • 2
  • 14
1
vote
1 answer

QBXML - modifying Sales Order line item custom field

I have a custom field set up in my QB sales order line items called Ready QTY, and I want to use QBXML to update the value. Here is a test QBXML request:
hawkeye217
  • 41
  • 6
1
vote
1 answer

Consolibyte QB for Windows API error trying to create an estimate... why?

XML that gets sent to quickbooks via Add Estimate request found within the quickbooks_log table is as follows:
Solomon Closson
  • 6,111
  • 14
  • 73
  • 115
1
vote
1 answer

Query Job Information

I was looking at the Onscreen Reference to see if there's an XML request for querying jobs. I found that there's just customer query request CustomerQueryRq and that too doesn't return the child jobs that it has. Supposing this is how the customers…
1
vote
1 answer

How to set .QBW file path for response in Authenticate for Quickbooks Web Connector?

Ok, I am using Keith Palmers excellent classes for this, located here: https://github.com/consolibyte/quickbooks-php, and the Web Connector is working fine, but only when I have Quickbooks open and click on File->Update Web Service within the…
Solomon Closson
  • 6,111
  • 14
  • 73
  • 115
1
vote
1 answer

QBWebConnector Error (QBWC1039) Getting an error after updating Quickbooks

I setup WebConnect and connected to it using the quickbooks php-devkit without any issues. https://github.com/consolibyte/quickbooks-php The very next day, there was a quickbooks update pending, which I ran, and now I can no longer add my…
DT2K
  • 11
  • 4
1
vote
2 answers

Cannot add Invoice in QBXML request due to the Customer FullName

When sending a CustomerQueryRq in qbxml, it returns: 500: The query request has not been fully completed. There was a required element ("Client Name") that could not be found in QuickBooks. So then I send a CustomerAddRq that returns: 3100:…
Douglas.Sesar
  • 4,214
  • 3
  • 29
  • 36
1
vote
1 answer

How do I filter Purchase Order query in QBXML to only return records that are not fully received?

When doing a PurchaseOrderQuery in QBXML I am trying to get Quickbooks to only return purchase orders that are not yet processed (i.e. "IsFullyReceived" == false). The response object contains the IsFullyReceived flag, but the query object doesn't…
romemmy
  • 193
  • 1
  • 4
1
vote
2 answers

Converting json to qbxml

Is there an easy way to convert JSON to QBXML for import into QB Desktop? I have tried using the online converters and the results are sketchy at best, and I need something I can wrap into a web based application.
1
vote
1 answer

Converting sales order to invoice and linking the transaction

Reposting this to hopefully help someone in the future. Previously it was closed for being "too broad" but the answer turned out to be quite simple. Original question: I am developing an application that pulls all sales orders entered in the past…
dragoncmd
  • 234
  • 4
  • 19
1
vote
1 answer

QUICKBOOKS_ADD_CUSTOMER function doesn't trigger (“no data exchange”)

I'm trying to synchronize my OpenCart with QB Desktop. But it doesn't work. QB Web Connector says "no data exchange". Here is my code: // Map QuickBooks actions to handler functions $map = array( QUICKBOOKS_ADD_CUSTOMER => array(…
Serhii Matrunchyk
  • 9,083
  • 6
  • 34
  • 47
1
vote
1 answer

Get All Customers from QuickBook using Web Connector and qbxml

I am trying to get all customers from QuickBooks 2013 Premier Edition using QBWebConnector. My request QBXML is as follows string strRequestXML = ""; XmlDocument inputXMLDoc = null; inputXMLDoc = new XmlDocument(); …
Ghazanfar Khan
  • 3,648
  • 8
  • 44
  • 89
1
vote
1 answer

In the qbXML ItemQuery request , how do I get the description for a service item?

I am creating a tool that will synchronize our production database with QuickBooks (QB). I am trying to get a list of all the items in QB using ItemQuery and I want to get the description of each item as well. However, it seems that different types…
Brian
  • 37,399
  • 24
  • 94
  • 109
1
vote
1 answer

qbxml isToBeEmailed Not working

I am using quickbooks web connector and have it working to import invoices in. The issue is that the "IsToBeEmailed" is not working. IsToBePrinted does work, but when i try and set the IsToBeEmailed the connector fails with: QuickBooks found an…
Phil
  • 51
  • 4