Stack Overflow
Stack Overflow

Questions tagged [qodbc]

ODBC driver for connecting to QuickBooks data

Link to QODBC site

47 questions
0
votes
0 answers

QODBC Invoice Table Query taking too long

I am using the QODBC VB Demo to query the invoice Table in Quickbooks Desktop edition, but the query takes too long and it keeps running until the program crashes. I tried using TOP 10 (SELECT TOP 10 * FROM Invoice) but that doesnt help, is there a…
Mario Landa
  • 67
  • 1
  • 7
0
votes
2 answers

QuickBooks - QODBC Driver, Look up Item Serial Numbers

I know this may be a stretch, but does anyone know where to look in the QuickBooks tables for an inventory item's serial numbers? I have looked through all documentation I can find and can not seem to find the table that holds the serial numbers. …
Phil
  • 4,029
  • 9
  • 62
  • 107
0
votes
1 answer

Trying to make a connection to QODBC, Import a table, and then close the connection

Working in Access 2007 in VBA: Basically what I have currently works without errors but I no I'm probably violating something within the code (adodb and DAO possibly?), regardless I can't get the connection to end when the code finishes. If I remove…
Colton Mayers
  • 13
  • 4
0
votes
1 answer

What tables does QODBC's SP_Report pull from?

I have the following query that was used by someone else and we are now using a sync tool to pull data straight out of QB and into SQL. So now I have all of the tables that I can query, but I'm trying to figure out what tables this query pulls…
Fubak
  • 107
  • 1
  • 11
0
votes
1 answer

How to insert new lined order to existing order using QODBC?

Array ( [0] => 120-1496395352 ) UPDATE SalesOrderLine SET SalesOrderLineItemRefListID='80000002-1496311427', SalesOrderLineQuantity =1, SalesOrderLineRate=200, SalesOrderLineItemRefFullName='Ipad', SalesOrderLineAmount=200,…
Muhammad Rizwan
  • 3
  • 1
0
votes
1 answer

How to connect the QuickBooks (QODBC) data through Pentaho (Kettle) for ETL?

I am trying to connect the QuickBooks (QODBC) application data through Pentaho (Kettle) for ETL process. Would like to know how can we connect the QuickBooks (QODBC) application data through Pentaho.
Rajasekaran M
  • 163
  • 2
  • 16
0
votes
1 answer

How to join results of stored procedures (ODBC, VBA, Quickbooks, QODBC)

I'm trying to join the results of a stored procedure available through the QODBC driver and a table also available through the QODBC driver Essentially I would like to do (in general terms): (StoredProcedure [Fields] [parameters]) C LEFT JOIN…
Gwolfe
  • 1
0
votes
1 answer

Quickbooks Custom Summary Report - QODBC default

I am trying to mirror the information coming out of the UI for a custom summary report; and I'm currently using the QODBC connection, and being told that there is no default filter on this report.  When I run the query without specifying an account…
Gwolfe
  • 1
0
votes
1 answer

Custom QODBC query in QuickBooks for Excel extraction

I am using QODBC to extract QB data into Excel. I would like to have a report that summarizes sales by customer. The query below is perfect until I started using jobs which are linked to the customer. Now... the data lists jobs as separate lines…
ShaneR
  • 1
0
votes
1 answer

How to add Job in Customer table with qodbc insert statement

I am trying to add a job to the QuickBooks Customer table using the following sql statement. The customer table has several CustomFields (columns). When I apply the statement without the customField/column the statment works. When I run the sql…
AhabLives
  • 1,308
  • 6
  • 22
  • 34
0
votes
1 answer

Quickbooks - Trouble with QODBC SQL

I'm having problems when I try to insert invoice. I run these queries in the VB Demo app and in both have errors. Any idea? Query 1 insert into…
esteban
  • 102
  • 1
  • 7
0
votes
1 answer

QSqlQuery.exec(query) returns wrong character for unicode chars

i have a database in MS SQL server and my problem is unicode chars! "query.exec(str)" in my "getRecordByCondition" method returns "?" char for nvarchar fields! but it wroks correctly in "loadToGrid" method. here is my code: void…
mahmoud mahmoudi
  • 1
  • 2
0
votes
2 answers

item cannot be found in the collection corresponding to the requested name or ordinal

My code gives the following error. How can I correct this? Item cannot be found in the collection corresponding to the requested name or ordinal ElseIf Me.chkItem.Checked = True Then Dim CheckNumber As String = "" Dim CheckRef As String =…
Maine
  • 1
  • 1
  • 5
0
votes
0 answers

Join Three Table in QODBC

I didn't get any error but there is no data that is displaying in the datagridview . Is there anything that i should add in my codes ? so it will display the data that i need ? If MSG = vbYes Then Timer1.Enabled = True …
Maine
  • 1
  • 1
  • 5
-1
votes
1 answer

Quick Books Data Layout in DB in SQL Server

I am new to QuickBooks. I am working on a staging SQL Server 2017 (v14) for grocery store data. The QuickBook data was uploaded to server.And many tables are empty. The datalayout is as in: https://doc.qodbc.com/qodbc/usa I am looking to understand…
nancy
  • 9
  • 6
1 2
3
4