Hi All, We are trying to create a report for QuickBooks Canadian edition using QODBC such that it will show us Invoice Line Item wise GST and PST tax amount. ...
I am trying to create a query for a cross tab report. The query is pulling the salesperson, amount, and month of a transaction from the sales table. I need...
Sorry, QODBC does not allow AS names or Functions in the Order by Claus. It is on the wish list to correct this. Matt Froncek QODBC Development Support /...
________________________________ From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of Matt Froncek Sent: Tuesday, February 07, 2006 9:45 AM ...
I'm trying to implement a filter on transaction date. I've tried using between and >= <= but neither seems to work. What are some of the valid options in...
I am using Coldfusion MX and QODBC Driver. I am receiving an error message while trying to update an line item ih the InvoiceLine Table. Message: Incorrectly...
I am having a very weird problem. If I run the following query without an order by, I get all of the results: SELECT salesrep.salesrepentityreffullname, {fn...
We need to link company data on sql server and our quickbooks file using one of two methods. Either bring the quickbooks company ID to a new table field in SQL...
You cannot do an alter table, but in QuickBooks you can add CustomFields and they show up in the QODBC as CustomFieldxxx where xxx is what you call the field...
I am trying to query for open invoices and I get a different result set than what shows as open in Quick Books. I just tried a very simple query to test this...
Rod, We are working to correct this. You can force the query you are doing to be unoptimized and it will return the correct results. You can either disable ...
Rod, Are you running version 6.00.00.147? That had a fix to the Sales table. Matt Froncek QODBC Development Support / FLEXquarters Solutions Consultant QODBC...
Matt, Well, I have egg on my face because I found out that I was actually working on a backup copy of our system and didn't realize it wasn't in sync with our...
Matt, I'm currently running whatever ships with QB Enterprise edition. It looks like that is 6.00.00.121. Is there a way to update that version? Rod ...
Rod, You should be able to download the current Evaluation at www.qodbc.com <http://www.qodbc.com/> and it will run the same as the Intuit version. (Just...
Can the QODBC/Quickbooks combination run as a service, i.e. the applications iwll start prior to login so that the applications are running at boot time? This...
Jason, QODBC calls the Intuit SDK which is basically the entire QuickBooks programs with or without the UI showing. This cannot be removed. You can run ...
I'm new to Access but this is so simple that it may have to do with how I'm using the QODBC driver. I've set up all the tables in an Access database as per the...
Hi all - Just wanted to check in and see wha the deal was with the QODBC optimizer status. One of my clients had some troubles with it not catching new inserts...
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...
1259
Patrick
bocabeachguy@...
Mar 2, 2006 7:37 am
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....
... <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...
