There are some great products out there that handle multiple warehousing. I would check out two products: FishBowl Inventory, and ESC Chuck Vigeant M.Ed....
I have over 20K invoices and retrieving a specific invoice using Coldfusion takes over 20 minutes to retrieve. Query: SELECT TOP 1 * FROM Invoice ORDER BY...
Trying to connect to POS using QODBC for POS (4.00.00.002) I get the message: QODBCPOS QODBC Requires API version 1.1 or 2.0 to communicate with QuickBook....
I am having a very interesting problem. I'm trying to make a job a subjob of another job in Quickbooks by updating ParentRefFullName to "Job:SubJob". When I...
ORDER BY will increase the time; although the new optimized version 6 will speed that up immensely. As for jumpins, please visit www.qodbc.com/schema in...
The POS driver is in beta. This is an acknowledged issue, and will be resolved in the next few days. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks...
How do I set this up so I don't have to give my clients the primary CD Key? I spoke with someone about this but I didn't ask for more information on how to do...
Matt, Not official, just a user...... If your client needs all 15 of the licenses, you can just send the key. They can go to the register tab of the driver...
Thanks Mike - That sounds about right. I still need to look more into the blind install setup, Mark said it was possible, so this is good. Thats a little tough...
Matt, your pricing for QODBC is wrong, OEM licenses for QODBC are quite a bit cheaper than QuickBooks retail, be sure to ask Mark about this. ... QODBC Driver...
Oh right! Yeah - I was just talking aobut the people who bought the retail products (like one of my clients) before I was able to get the OEM's....he was a bit...
Yes, but with rebates the price goes down, so yes, we need to keep up with each version of QuickBooks you purchase, but it's not full price. thanks! brad ... ...
I am attempting to use the MONTH() function in my SQL select statement. It doesn't appear to like either of these. What functions are available in QODBC for...
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 ...
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.
