I have been having the same problem. Almost thought I was losing my mind when records already inserted in Quickbooks were being omitted from reports. Thanks...
cool! now that there is at least more than 1 occurance we can really track down this problem! I have configured the optimizer to optimize after every query in...
Matt, First off the most current version is .150. Can you tell me exactly what part of the Optimizer does not work for you? Currently there are fields like the...
Access is my specialty. Herer is what I would do. Use a maketable query to grab just the data you need for the report, without a lot of math or expressions....
Patrick
bocabeachguy@...
Mar 2, 2006 7:37 am
1260
... <snip> ... Have you tried making the Access query a snapshot type (query properties, RecordsetType=snapshot). If you are only running a report this...
... I tried the RecordsetType=snapshot but there's no improvement. The query completes in a few seconds (not even the minute I said before) but the report...
... query to grab just the data you need for the report, without a lot of math or expressions. Then use that local temporary table to generate the report. ...
... <snip> ... been ... is so ... I think it should be simple as well but have also struggled to keep the speed up. What I have done where I know I will be...
... Maybe so. It certainly has to do with queries on linked tables or QB tables specifically. I haven't tried Crystal Reports yet but a couple of years ago...
Dear Chuck, I am upgrading from QB Pro 2003 to QB Pro 2006. I had been using the free read only version of the QODBC software I had downloaded in 2004. Will...
... are you using the latest version 150? not sure why matt has not responded to your issue yet but any problem you have should be resolved soon. the best...
... responded ... I've been through it before I purchased the driver but I'll go through it again now that I have to find some practical way to use it. By the...
well, you make a query for every QB table that interests you, store the result as a local table, and then do all your reporting from, just as you said. It can...
Patrick
bocabeachguy@...
Mar 6, 2006 8:15 pm
1269
Access does do this on it's own normally. In my experience the problem of speed is with the ODBC link to the QB tables. I have very limited experience with...
Patrick
bocabeachguy@...
Mar 7, 2006 3:30 am
1270
My company uses Quickbooks Pro 2005, and recently used the QODBC driver to generate invoices. About 970 invoices, and 16,000 invoice lines. Two employees have...
We are still working on some speed issues with the driver's optimization system, but you do not say if you are using the latest version, i need to know if...
That should not be necessary, as we have a database back end now (optimizer) which does just that. If it is not fast, we need to know about the specifics so we...
... optimization ... need to ... The readme says Version 6.0.0.147. There's no version # on the setup dialog windows. I bought it on March 1st. Mark....
... yes, download build 150 from the web. The version is in the About screen. thanks. brad QODBC Driver for Quickbooks - Interactive QuickBooks data solutions...
Hey All - I got this awesome error when I tried to connect to quickbooks the other day. Using the exact same connection code, I made the connection when I ran ...
Hi All, As per QuickBooks table schema "BuildAssembly" and "BuildAssemblyComponentItemLine" tables used for Build Assembly. However I am not able to access...
Clifford, The BuildAssembly assembly table is only available in the US version of QuickBooks 2006 and higher. Matt Froncek QODBC Development Support /...
Hi Matt, Thanks for the information. Sincerely, Clifford ... version of ... <http://www.qodbc.com/> ... Behalf Of ... Assembly. ... QODBC ... related ... ...
whats the proper seguece for inserting journal entries? I have a debit entry and two credit enteries for one transactions. Do I need to enter a record into the...
When using the FQSaveToCache field everything is held in memory until the FQSavetoCache is sent equal to FALSE, so the order really does not matter. Just that...
Hello Group, Having a little problem getting a field to show up in a customer OPEN INVOICE report. The field I need printed or exported in the report is found...
Hi, I Created a Report in Crystal Report 10, I add two commands in our Reorts. When I use records from Command_1 my Report working normaly then I use a record...
You need to let Crystal do the work for you. rather than creating the manual commands. you need to use the tables for your report, and use the filtering and...
Hi, I use two commands (Command_1 and Command_2) both commands are use same table of SQL. Command's Querry is: (1) Command_1 Querry is (SELECT SerialNo FROM...
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.
