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...
Steve, I responded to you in one of the other yahoo newsgroups... please forward us along; we do more of this than anybody. Chuck Vigeant M.Ed. MCSE, CCNA,...
It is written in MS Access. The error occurs on the line "rsEstimateLine.Update". Thanks for the help. Const adOpenStatic = 3 Const adLockOptimistic = 3 Const...
Chuck, I have your response in a pending file. My contact is unavailable until 7/18. At that time I will send my responses to him which will include your...
I'm using an evaluation copy of QODBC Pro to experiment with extracting invoice information from Quickbooks and displaying it in a Crystal report. I'm using...
Quickbooks prompts you do you want to have your reports updated when data has changed? yes / no. My question is when we write an invoice to QB through QODBC,...
Hello all, I am writing an application that would work with different versions of Quickbooks. The QBXML documentation mentions that there have been changes to...
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.
