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....
1222
dricario
Jan 9, 2006 1:03 am
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...
1223
greenmakersupply
greenmakersu...
Jan 9, 2006 1:03 am
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....
1224
springqua
Jan 9, 2006 1:04 am
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...
1225
Chuck Vigeant
txbtech
Jan 9, 2006 7:00 am
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...
1226
Chuck Vigeant
txbtech
Jan 9, 2006 7:05 am
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...
1227
greenmakersupply
greenmakersu...
Jan 12, 2006 3:28 pm
How will we be notified when the fix is available?...
1228
Matt Babineau
praefex
Jan 17, 2006 6:00 pm
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...
1229
Mike de la Pena,
actitmike
Jan 18, 2006 6:50 am
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...
1230
Matt Babineau
praefex
Jan 18, 2006 7:25 pm
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...
1231
Brad Waddell
flexq
Jan 25, 2006 9:37 pm
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...
1232
Matt Babineau
praefex
Jan 25, 2006 11:11 pm
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...
1233
Brad Waddell
flexq
Jan 28, 2006 1:18 am
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 ... ...
1234
Rod Lewis
ddprlewis
Jan 31, 2006 9:38 pm
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. ...
1237
Rod Lewis
ddprlewis
Feb 7, 2006 2:45 pm
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...
1238
Matt Froncek
matt_froncek
Feb 7, 2006 3:44 pm
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 /...
1239
Rod Lewis
ddprlewis
Feb 7, 2006 5:21 pm
________________________________ From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of Matt Froncek Sent: Tuesday, February 07, 2006 9:45 AM ...
1240
Rod Lewis
ddprlewis
Feb 7, 2006 5:24 pm
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...
1241
dricario
Feb 8, 2006 6:31 pm
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...
1242
Rod Lewis
ddprlewis
Feb 10, 2006 4:04 pm
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...
1243
gray_raccoon
Feb 15, 2006 12:36 am
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...
1244
Matt Froncek
matt_froncek
Feb 15, 2006 1:29 pm
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...
1245
Rick Boatright
rboatright
Feb 15, 2006 11:11 pm
you are correct. It is not possible...
1246
Rod Lewis
ddprlewis
Feb 16, 2006 7:19 pm
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...
1247
Matt Froncek
matt_froncek
Feb 16, 2006 9:43 pm
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 ...
1248
Matt Froncek
matt_froncek
Feb 16, 2006 10:15 pm
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...
1249
Rod Lewis
ddprlewis
Feb 16, 2006 10:19 pm
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...
1250
Rod Lewis
ddprlewis
Feb 16, 2006 10:21 pm
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 ...
