I have QODBC developer edition installed at a client shop. Quickbooks has to be running BEFORE starting my linked application, or an error message ensues. They...
Even in "silent" mode, the QBW32.exe file runs; no way around this. For silent mode, go into QB>Edit>Preferences>Integrated Applications>Company Preferences....
can you send the exact query. ODBC uses some different syntax than Microsoft SQL server and Oracle. e.g. you can't store date like "txnDate = '2/2/2005'"....
I have a client that has two quickbooks files and I want to import the transactions from one of his checking accounts in file #1 to another checking account...
I have developed an application that will maintain the ItemInventory table. Adding or update the standard Item fields works well, but when I update data in...
We have the following line of code to insert lines into invoices: "INSERT INTO InvoiceLine (CustomerRefListID, ClassRefListID, ARAccountRefListID, " & _ ...
try this function Function ParseQuotes(ByVal ParseText As String) As String Dim intOffset As Integer Dim intX As Integer ' TRIM THE STRING - OPTIONAL BUT GOOD...
Simpler to do: Replace(sYourData, "'", "''") ' That is replace all single quotes with two single quotes. Matt Froncek QODBC Development Support / FLEXquarters...
I'm trying to import UPS tracking numbers and shipping costs from an Excel spreadsheet into Quickbooks. Our customers require this information on their...
We have a number of memorized QuickBooks reports derived from the Customer Balance Detail report. These reports are customized to select only customers of a...
RefNumber does a table scan inside of QuickBooks. If you have QuickBooks 2005 and check the "Use Case Sensitive RefNumber Searches" in the QODBC Setup...
Customer Type is not available to that sp_report. Unfortunately because sp_report is not really a table you cannot join to it. The best you can do is return...
Directly from Intuit at http://developer.intuit.com/ Matt Froncek QODBC Development Support / FLEXquarters Solutions Consultant QODBC Driver for QuickBooks -...
Check off "use case sensitive refnumber searches" in your advanced tab of your QODBC setup - if you are using 2005 QB. You might try and limit your search...
I am using QODBC Web Edition Read/Write 2005 and when I try running the below listed set of insertstatements I get an "invalid operand for operator:...
Jason, FQSaveToCache is a Boolean and needs to be 1 or True (no single quotes on either of them) FYI, you should specify Qty and Rate OR Amount not both all...
What is the SQL statement you are sending; there is a syntax error in it? Matt Froncek QODBC Development Support / FLEXquarters Solutions Consultant QODBC...
I have reworked the automatic generated sql commands. And now my updating to QB is working properly. Thanks. ... in it? ... <http://www.qodbc.com/> ... ...
I would like to be able to associate a SalesOrderLine item with a specific ProceLevelList entry. It appears that the QuickBooks SDK does not allow access to...
Hi is there a way where you can limit the number of expense lines in QuickBooks? in my Application, i'm exporting the check_detail report and i have a limit of...
Nonprofit Organization needs to convert from PeachTree to QuickBooks in Long Beach, California Area. I will forward your information to Nonprofit Association...
I am trying to write code to edit line items on existing estimates and invoices. When I try to update the existing record in the EstimateLine table, I receive...
If you sent a copy of the SQL you are trying would make it easier to figure out what is wrong. Matt Froncek QODBC Development Support / FLEXquarters Solutions...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
