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

QBFC: Custom Reporting - Filter by custom field

In reference to a previous question of mine: qbfc CustomerQuery based on email address? Is it possible to create a custom detail report of customers, and using a custom field to "filter" the report. I must admit, I am not really clued in on…
Louis van Tonder
  • 3,664
  • 3
  • 31
  • 62
1
vote
1 answer

QuickBooks error message: A row/shelf bin was expected, but an inventory site was selected

I am using the QuickBooks SDK version 12 to connect to QuickBooks Enterprise 2013. I am trying to add an Item Receipt through the api using the xml request below. I turned on verbose logging and captured this error: Cannot set unassigned RSB in…
Mark
  • 11
  • 2
1
vote
1 answer

QBXML : Add Invoice to quick book online essential account with QBOE App /QBXML

I have referenced new OSR and try to add Invoice to quick book online essential account but not getting succeeded. Please note that I have added correct list id in XML for product and customer.But It will respond me below XML,
1
vote
0 answers

Retrieve a List of All Checks for an Account using qbXML

I'm working on a website for a client that integrates into QuickBook desktop. I need to get a listing of all the checks for a specific account (ideally I would like all transactions for that account [regardless of their type] but if I have to get…
Scott Keck-Warren
  • 1,894
  • 3
  • 18
  • 33
1
vote
3 answers

Access Active window transation information from Quickbook application

is there any API Quickbook provide to grab information of the active window transaction ? e.g if i have open a window of a Invoice in my Quickbook application then my application should be access that information from the Quickbook ? if it is…
Manish Parmar
  • 859
  • 1
  • 11
  • 19
1
vote
1 answer

using QuickBooks SDK in ASP pages on an intra-office server

I am trying to use QBSDK 12.0 (QBXML) to access a QBW file from ASP pages on an intra-office server. This was working on a testbed PC running IIS, and having QuickBooks and the QuickBooks SDK installed. All the pieces were on the same machine, so…
1
vote
1 answer

QBXML, QBFC - Customer Statement

I may be missing something in the OSR, but what query do I use to retrieve a customer statement? I cant seem to identify the right query. Would greatly appreciate some insight. Regards
Louis van Tonder
  • 3,664
  • 3
  • 31
  • 62
1
vote
0 answers

QuickBooks SDK CustomerQueryRq returns excess ShipToAddress elements

Since the version 12.0 of the qbXML the CustomerQueryRq responce retains the ShipToAddress elements - these are the random set of addresses ever used in QuickBooks. On Screen reference says the responce can contain up to 50 shipping addresses, but…
SergeyK86
  • 11
  • 2
1
vote
1 answer

QBXML Query for Created Date Range

I'm writing a QuickBooks 2013 integration service. Synchronization works great, it's filtered by ModifiedDateRangeFilter. But I need to create "Initial synchronization" which get records from QB by CreatedTime. Is it possible to create query for…
1
vote
2 answers

QBXML InvoiceAddRq and Taxes

I'm having an issue trying to get tax applied to an invoice with QBXML. I'm using SalesTaxCodeRef in InvoiceLineAdd but it doesn't seem that it's working for whatever reason. This same code worked for SalesReceiptAddRq. Am I missing a flag or…
Randomguy3
  • 13
  • 3
1
vote
0 answers

Using QBWeb Connector to Sync Customers

I am facing this issue, when i am trying to create new customer in Quick Books. I was having actual name of Customer at my php side was "IbáñezOmar" and when it converts to UTF-8 encoding, it becomes "IbáñezOmar". But when this customer created in…
Saad
  • 11
  • 2
1
vote
1 answer

What is the equivalence of Edit Sequence in QuickBooks POS?

Does anyone know what is the equivalence of EditSequence (in Quickbooks) for QuickBooks Point Of Sale? Apparently I found, there is none.
aisha
  • 87
  • 7
1
vote
3 answers

ItemInventoryQuery is not returning all the available fields.

We are using Web Connector on the end where QBPOS 10.0 is installed. On the server end we issue an ItemInventoryQuery request using QBPOSFC3.0 (QB POS Foundation Classes). The response we receive from Quickbooks contains most of the fields available…
Agustin Garzon
  • 317
  • 2
  • 15
1
vote
1 answer

Error while processing General Detail Report Query Request : 0x80040402, Unexpected error

While troubleshooting one of the issues on our live machine, I came across multiple instances of below error in QB sync log files. I have confirmed that the sync process abruptly stops once this error occurs. Error: string hresult =…
user992867
  • 65
  • 4
1
vote
1 answer

What is "entityRef" element in qbXML with TimeActivity

I am creating some time tracking software to interface with quickbooks, and below is my exported XML file. I receive status code 3140, saying there is an invalid reference to QuickBooks entity in the TimeTracking. Quickbooks returns error : "The…