... Yes. ... Yes. The comment about "best performance" refers mainly to the way data is transferred to our optimization routines. The speed of the driver using...
I've just recently made a huge upgrade in my Quickbooks. Went from 2003 Pro 5-user edition to 2006 Enterprise Edition. With the 2003 version I was using QODBC...
You won't have to upgrade QReportGrabber, but we have some issues with it and the new driver. It will probably be a week or two to work out the bugs. Chuck...
The QODBC version with Enterprise is read-only, if that is what you need, you are all set. If you need write ability, it's just $99 after rebate with proof of...
I've imported about 500 PO's into QB06. I'm working on adding the bills to those PO's and having them linked. I've successfully inserted the bill but not...
Mario, The full updated schema connected to your version of QuickBooks can be seen by using the sp_columns command in QODBC - the only part we have not ...
Thanks for the heads up on the sp_columns. It will definately help. I've searched the KB and haven't found what I need. Here's the issue in more details....
I've been using a form in MS Access that inserts invoices into QB for about a year now without a glitch and now it won't work. Below is a sample sql statement...
Have you upgraded the QODBC driver and/or your version of QuickBooks? Can you post the error message being generated by the QuickBooks tool? ... for ... ...
Try testing by inserting first with the minimum fields, then add one field back at a time until you see which is the offending field. Off the top of my head,...
Hello, I am using QODBC OEM Version 5.0.0.079. I know that Version 5.0.0.079. Supports only for QuickBooks® Pro 2005/2004/2003/2002. But I have some questions...
Yes Jason, I am facing same problem. Only thing I will like to mention that I am using QODBC OEM version. This seems to be big question. My clients inform me...
We need to integrate our custom PHP shopping cart with Quickbooks Enterprise 2006. Which QODBC product do we need to purchase? We have full server access to...
I am in the process of trying to merge two older QB databases into a single file. I'll explain my process thus far, and then I'd like to know if there's a...
I recently condensed my QB file due to its large size. One big problem is that my SQL statements running agaist the DepositLine table no longer oull back any...
Hi All, I am using QODBC "ProfitAndLossBudgetVsActual" and "BalanceSheetBudgetVsActual" stored procedure to get budget information from QuickBooks. These...
If you have programming knowledge than you can use the R/W QODBC Driver. If not, please call me at the number below. Chuck Vigeant M.Ed. MCSE, CCNA, Certified...
Canadian 2004 edition was Version 3 of the SDK which did not include Budget queries. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director,...
When you condense a QB file, you are taking the transactions and creating summary journal entries in QuickBooks; so the history is just not there. If you want...
There is actually a much, much easier solution: use Karl Irvin's tool at www.q2q.us <http://www.q2q.us/> He has the best tool for transferring data from one...
I decided to import my depositline table into Access from the archive. I can then Union the old archive information with the active QB file in Access....
I recently upgraded my payroll service to include WC tracking. I use timesheets that are imported from my timeclock program (CountMeIn). One problem I see is...
Try: Select FirstMonthFiscalYear, FirstMonthIncomeTaxYear from Company Matt Froncek QODBC Development Support / FLEXquarters Solutions Consultant QODBC Driver...
Hi Matt, Thanks for your prompt reply. However the solution you had given provides only the first month of the fiscal year. But I am looking for starting day...
Hi All, In QuickBooks I created a Journal Entry Transaction for a Customer ¡¥John¡¦ of amount USD 500. Due to which the balance of the customer increase to...
Two things here: QB is not journal entry friendly, so I would support the use of sales receipts or invoices for registering sales. Second, the journal entry...
QuickBooks does not support a mid-month fiscal year start date. Chuck V _____ From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of ...
Hi Chuck, Thanks for your prompt reply. As you mentioned that QuickBooks does not support a mid-month fiscal year start date but in QuickBooks help manual,...