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
0
votes
0 answers

QBXML get invoices of inactive customers

How to retrieve invoices associated with Inactive customers. 50 2017-01-01
flymike
  • 935
  • 2
  • 9
  • 18
0
votes
0 answers

There is an invalid reference to QuickBooks AP Account

Our web-based software communicates with our client's desktop Quickbooks using the Web Connector. For one particular client, my software sent the following QBXML:
user3826040
0
votes
1 answer

Quickbooks web connector give parsing error when trying to add invoice with field InventorySiteRef

Quickbooks web connector give parsing error when trying to add invoice with field InventorySiteRef. 0x80040400: QuickBooks found an error when parsing the provided XML text stream. Below is my XML stream.
0
votes
1 answer

How to add a customer with custom fields to Quickbooks POS using QBPOSXML

So my problem is pretty simple: I am trying to add a customer to Quickbooks using ASP.NET and QBWebConnector, and thankfully I am succeeding. The problem occurs when I try to add custom fields to the customer. Here's the qbposxml I am sending:
thecodrr
  • 265
  • 1
  • 2
  • 13
0
votes
1 answer

What does in Quickbooks XML do?

No matter what I try for EntityFilter, I can't seem to get any results. I believe that I must be mis-understanding what the EntityFilter does. What entities is it filtering if I use it in a ?
user49438
  • 889
  • 7
  • 20
0
votes
1 answer

Retriving all checks, deposits, etc dealing with money using qbxml

I'm able to retrieve some data using QBXML from a QuickBooks 14 database, but there are missing items in the returned XML. For example, although all of the General Journal Entries are returned, but not Checks or Deposits. This gives and incomplete…
user49438
  • 889
  • 7
  • 20
0
votes
1 answer

Any method to retrieve the available serial numbers for an item?

I'm trying to find a way to retrieve the available (i.e. in stock) serial numbers from Items in QuickBooks Enterprise using qbxml. I've looked through OSR and the various Item Query requests as well as read the docs for the C-Data QuickBooks…
scubasteve
  • 2,718
  • 4
  • 38
  • 49
0
votes
1 answer

Is it possible to create a QBXML VendorMod request for Vendors with a matching Custom Field (DataExt) value?

I'm attempting to update QuickBooks Vendor records using QBXML and Web Connector. From the system in which I'm generating the QBXML requests, I don't have ready access to the QuickBooks Vendor ListID, but I do have access to a unique identifier that…
Haywain
  • 88
  • 4
0
votes
1 answer

Accessing UK-specific QuickBooks reports

The UK version of QuickBooks Premier has a report called "UK Standard Balance Sheet" under "Reports > Company & Financial". However, if I send a QBXML GeneralSummaryReportQueryRq request for a BalanceSheetStandard I get a different report simply…
morbiD
  • 214
  • 1
  • 11
0
votes
1 answer

Quickbook web connector 403 error

HI i am php for quickbooks enterprise data exchange from web connetor. I am getting this error when i do customer query. QBWC1042: ReceiveResponseXML failed Error message: The request failed with HTTP status 403: Forbidden.
0
votes
1 answer

Adding values to custom (DataExt) fields when adding line items to existing quickbooks Estimates

I'm trying to find the best way to add a value to a DataExt field when adding a line item to an existing Quickbooks transaction (in this particular case an Estimate). I can add a value for a DataExt field when adding line items to a NEW Estimate…
stuartho
  • 13
  • 3
0
votes
1 answer

Is there any character restrictions for the Desc field for LineItemAdd on QBXML

I am getting a generic looking error for this InvoiceAddRq 0x80040400: QuickBooks found an error when parsing the provided XML text stream. The only out-of-the-ordinary part of the xml seems to be the LineItem Description (contains / and &…
Douglas.Sesar
  • 4,214
  • 3
  • 29
  • 36
0
votes
2 answers

Quickbooks Desktop BillPaymentCheckAdd error object not found

I am trying to add a $20 payment to a bill. This is from the sample Quickbooks file. However i am getting the error Object \"3E42-1071498278\" specified in the request cannot be found. " Any ideas. I have tried multiple things. I have indeed checked…
user1999086
  • 61
  • 1
  • 2
0
votes
1 answer

How to manually enter Amount on Quickbooks line item for QBXML request

As far as I can tell with the documentation and examples for QBXML, I need pass a and a when adding a line item to a request (then Quickbooks calculates the subtotal). Unfortunately, sometimes I have a quantity of 3 and the…
Douglas.Sesar
  • 4,214
  • 3
  • 29
  • 36
0
votes
4 answers

QuickBooks SDK, using Perl, works in command console, not as CGI?

I'm using the QBXML method to communicate with QuickBooks on a local machine (not remotely, not using web connector). I have a very basic script which just connects to QuickBooks and checks to see if a Customer exists or not. The script works…
Jay
  • 11
  • 1
  • 3