In our search engine, I typed in "error codes" and the page was the first one listed: http://www.qodbc.com/qbxmlerrorcodes.htm thanks! brad ... QODBC Driver...
Can you be more specific, by forecast do you mean budgets? What does the actual QuickBooks screen say at the top, this will help us find what you are looking...
something like select * from invoice where Invoice.TimeCreated >= {ts'2003-09-01 17:01:09'} and CustomerRefFullName = "Smith, Joe" Fill in the date & time...
Brad, Would something like this work? SELECT TOP 1 * FROM Invoice WHERE CustomerRefFullName = "Smith, Joe" ORDER BY timecreated DESC I don't know if QODBC...
Yes, Top is supported so that should work. The question is do you care about the invoice create date or the TxnDate of the invoice? To me that makes more sense...
Matt, I would agree. I was just expanding on the possibilities of what Brad put out there. This just shows the power of the SQL language. There are many...
As a reminder, the "natural order" of invoice transactions is by txn date - not the invoice number, create date etc.; this is by design in QB. To check this,...
We have upgraded to version 4.20.00.050. When I run the QODBC test vb script I receive error message 80004005, QODBC Requires API version 1.1 or 2.0 to...
This message can be related to two things: login and QBXMLRP2.dll having been replaced by remote client, or not re-registered. (1) If you haven't specified a...
I am trying to get to the memorized invoices in a customers database so that we can extract this information for updating into a another program. My question...
Hi Brad, I guess it's Budgeting in QB terminology. I'm trying to extract the sales forecast #'s as well as the actuals on a monthly basis for each customer. ...
We have the QODBC driver set to "Follow Company File" as far as user mode. However, sometimes it still opens it in multi-user mode within Access after we have...
I'm trying to use the ProfitAndLossBudgetVsActual sp against a QuickBooks 2003 data source, but it keeps erroring with a 'table not found' message. I used the...
I replied earlier to your request... there are no tables for budgeting. You can retrieve budget information via sp_reports. Please review the schema for the...
Please review the schema at www.qodbc.com/schema.htm for examples of sp_report statements. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor ...
Intuit does not make available memorized transactions via the SDK yet. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
Access copies the entire connect string including the Open Style setting into the connection settings for the table. Any changes you make to the DSN (QODBC...
Developing an interface for a small office Does QuickBooks have to be running to use QODBC to write Invoices and receipts? Regards, AFB Inc. Nathan Chute PO...
Hi Chuck, Thank you for your reply. However i'm somewhat confused. If a QB user can set Budgets and forecasts for individual customers , surely that...
I'm USING your example... sp_report ProfitAndLossBudgetVsActual show Amount_Title, Budget_Title, Difference_Title, Percent_Title, Text, Label, Amount, Budget,...
What version of QuickBooks are you using? I believe the Budget reports are only available in QB2004. Matt Froncek QODBC Development Support QODBC Driver for...
i don't know if this is how it is supposed to be, but it is very inefficient. when running a program, which uses qodbc to create invoices in qb, qb grabs a lot...
Intuit only allows us access to budget information via sp_reports. Unfortunately they also did not give us the ability to filter by class or customer:job....
It can be run in silent mode, with a DSN pointing to a specific QB file. It also depends upon the default login permission created under QB Integrated ...
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.
