I am trying to get a report showing all items where no class has been selected. I have tried: sp_report ProfitAndLossbyClass show 'Unclassified' AS Query,...
1424
Christopher Frazier
piperchris1973
Nov 23, 2010 10:20 pm
Shane, I would be very interested in a better answer to this, but... I don't know of anyway to EXCLUDE classes using the ClassFilter parameters. I generally...
1425
carc88
Dec 11, 2010 5:40 pm
I am trying to get the basics down with a new installation using the latest QODBC version. I send a simple INSERT query to create a "Customer"; record and that...
1426
Chris Frazier
piperchris1973
Dec 14, 2010 12:03 pm
Are you in muti user? I have noticed QB doesn't immediately delete certain items when in MU. [Non-text portions of this message have been removed]...
1427
davidrodeback
Jan 12, 2011 9:03 am
I'm importing a couple hundred orders into QuickBooks using the latest available version of QODBC. My code queries the customer table before inserting order...
1428
Matt Froncek
matt_froncek
Jan 13, 2011 3:26 pm
I have never seen that but I can see it being possible. Can you send a small snip of code? Seems like the recordset is not getting closed. From:...
1429
David Rodeback
davidrodeback
Jan 14, 2011 3:43 am
That's what it was, all right. I thought I was closing everything I opened, but I wasn't. I fixed that, and I haven't seen the error since. Thanks....
1430
copett2011
Feb 1, 2011 10:58 pm
Hello everyone, My company is looking at integrating QODBC with our QuickBook system. We are currently using QuickBooks Pro 2010 and will be upgrading to...
1431
Brad
flexq
Feb 1, 2011 11:02 pm
CP: QODBC runs on any machine which can properly run QuickBooks, so you should have no issues. QODBC talks to the QuickBooks SDK to get information from your...
1432
thughesapa
Feb 11, 2011 11:10 pm
I would like to be able to run a txndetailbycaacount report for two or more accounts. I have tried multiple versions of AccountFilterFullNames='54900 · Other...
1433
corujoj
Mar 4, 2011 7:03 pm
Hello, I would like to see if anyone can shed some light on an issue I am having. I created a simple MSAccess application that pulls sales order data and it...
1434
Brad
flexq
Mar 4, 2011 7:08 pm
i think there might be a way to vary the QuickBooks app name in the INI file settings, hoping one of my tech people will enlighten us - have you made a new...
1435
Matt Froncek
matt_froncek
Mar 6, 2011 5:39 pm
This issue is usually caused be having different settings for integrated applications. If you run the QODBC Setup Screen->Advance tab. Make sure all four...
1436
Jim
jkeough78
Mar 9, 2011 7:02 pm
i am trying to run the following query to update my item table, but as you can see, i am getting an error.... IsAService: False SQL Statement: UPDATE ITEM SET...
1437
Brad
flexq
Mar 9, 2011 7:04 pm
i would check those fields with the sp_columns command and see if they are updatable. ... -- Brad Waddell, Managing Director FLEXquarters.com Limited +1...
1438
Matt Froncek
matt_froncek
Mar 11, 2011 3:23 pm
The Item table is read-only. You can only update the base table it came from. So if the Item type is ItemService. You update the record using the ItemService...
1439
Larry
larry_seabrook
Mar 12, 2011 7:10 pm
Does the Item Table exist in the QB database independent of the QODBC driver or is it a PRODUCT of the QODBC "ODBC" driver software?...
1440
Brad
flexq
Mar 12, 2011 7:14 pm
There is no "database"; in QuickBooks via the SDK. QODBC reorganizes the information scattered through the XML documents of the SDK into tables and field names....
1441
askolits2
Apr 8, 2011 12:59 am
I just installed the QODBC driver and want to do something very basic. I want to reproduce the 'Cash On Hand' number that shows up on the Balance sheet. Using...
1442
gordonhlee
Apr 8, 2011 12:59 am
I am doing a product evaluation with both QuickBooks POS and QODBC. Both are trial versions of the products. After installing both POS and QODBC, I tried to...
1443
Brad
flexq
Apr 8, 2011 1:03 am
The data in QODBC is from the QuickBooks SDk which is not the raw database QuickBooks uses but a portion of the total database, therefore sensitive things like...
1444
ASkolits
askolits2
Apr 8, 2011 4:28 am
Really! In some way's I understand that but, if I have to be an admin to install the QODBC driver program, you would think I could see all that data anyway ...
1445
Brad
flexq
Apr 8, 2011 4:33 am
hi ... it's not a question of rights, it has to do with what Intuit wishes you to see. They have various services related to payroll... ... see above ... this...
1446
ASkolits
askolits2
Apr 8, 2011 5:47 pm
Brad, Thanks for helping me with all this. I'll find the support board and post my question there. John ... From: qodbc@yahoogroups.com...
1447
Ingrid
ibojeda
Apr 21, 2011 11:23 pm
I figured out how to get the budget data by class and account in the right format: QBReportAdminGroup_v_budget=QBReportAdminGroup_v_lst_account ...
1448
customh2
Apr 25, 2011 6:21 pm
I'm evaluating QODBC for our enterprise application (I like it so far), however, sometimes it connects quickly, sometimes painfully slow, 4 minutes or so for...
1449
Conrad
waneran
Apr 26, 2011 9:26 pm
Try turning the QODBC optimizer off. Depending on the settings, the driver may be optimizing the entire database during the connection before it allows you to...
1450
askolits2
Apr 26, 2011 10:18 pm
I have a customer who set up a custom report in QB. Is there a way to retrieve that report in MSAccess (via stored procedure passthur query) using the name the...
1451
Brad
flexq
Apr 26, 2011 10:20 pm
no, the QuickBooks SDK does not support connecting with user defined reports. ... -- Brad Waddell, Managing Director FLEXquarters.com Limited +1 702-509-1150...
1452
John Skolits
askolits2
Apr 27, 2011 12:14 am
Bummer. Thanks. ... From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of Brad Sent: Tuesday, April 26, 2011 6:20 PM To:...
