I am trying to build a MS Access report to extract the sales tax amounts paid on Bills we paid. We have separated this amount as we post each bill and...
1046
Chuck Vigeant
txbtech
Mar 5, 2005 10:25 pm
Please post your SQL statement to the www.qodbc.com FAQ section. We need to know what version of QB you are using, what filters you are using -although your...
1047
Brad Waddell
flexq
Mar 5, 2005 10:40 pm
... Is this the only table where this happens? You are having a problem importing the data into QuickBooks, do you have a similar problem using linked tables?...
1048
William
wricaurte
Mar 6, 2005 4:46 am
Hi all, I am trying to insert like 1000 jobs in the Customer table. How the "INPUT" statement works? Does some one has an example?? Using the INSERT statement...
1049
Chuck Vigeant
txbtech
Mar 6, 2005 5:48 am
INSERT is the mechanism to import data. And yes it can be slow for that many records. Please visit www.qodbc.com FAQ section for more information. Chuck...
1050
Brad Waddell
flexq
Mar 6, 2005 7:39 am
... Yes, a drawback of QuickBooks' choice of interface, processing takes time thru the QuickBooks SDK, but it's better than IIF generally because of the ...
1051
William
wricaurte
Mar 7, 2005 5:41 am
Well, I am feeding a Quicbooks company file using a small J# .NET program, and it is working good, my only concern is how slow is to update the Customer table....
1052
Brad Waddell
flexq
Mar 9, 2005 7:56 am
... That is a limitation of the Intuit SDK. ... No, but we are considering a batch load function, similar to how we hold multiple lines of a multi-line...
1053
esjr0969
Mar 10, 2005 9:43 am
We are upgrading from QB Enterprise 2004 to QB Enterprise 2005. I have the QODBC driver for QB 2004. Will I need to upgrade to QODBC 2005? If so, is there...
1054
Brad Waddell
flexq
Mar 10, 2005 10:55 am
... Hi Eddie, There is a discount for upgrading QODBC from 2004 to 2005, please see our web page on sales for the upgrade or call our sales line: 800-932-6448...
1055
michelbor
Mar 13, 2005 3:53 pm
Hi all, I'm trying to create my first invoice with QODBC using vb.net and Microsoft.Data.Odbc.OdbcConnection with connectoinstring: "dsn=QuickBooks Data;OLE DB...
1056
Byte Boy
byteboy1234
Mar 13, 2005 3:53 pm
I was told that I could use Transactions processing, with rollback, with this driver. Is it true? Can't seem to make it work... Rick...
1057
Byte Boy
byteboy1234
Mar 13, 2005 3:53 pm
I want to be able to have my user switch to a different Quickbooks company file from within my Access 2k program, which means the quickbooks system DSN needs...
1058
thedigitguy
Mar 16, 2005 2:35 am
We have created an empty group item so we could insert any inventory items into it when filling out an invoice or sales receipt. We currently use QODBC to...
1059
thedigitguy
Mar 16, 2005 2:35 am
Is there a way to query Quickbooks for closed period date using QODBC? Jerry...
1060
Chuck Vigeant
txbtech
Mar 16, 2005 2:55 am
From a programming standpoint, this would be an interesting way of creating "group items" on the fly. From a historical/accounting standpoint, most users have...
1061
Chuck Vigeant
txbtech
Mar 16, 2005 3:02 am
Preferences. AccountingPrefsClosingDate That is from the documentation at www.qodbc.com/schema.html Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks...
1062
thedigitguy
Mar 17, 2005 6:52 pm
We need to be able to adjust the overall price of the group item but when you create a group item it only allows you to insert items and quantities. The group...
1063
mharris63
Mar 17, 2005 6:52 pm
In quickbooks, you can change the refnumber field of a purchase order without it creating a new purchase order. Does anyone know how you can do this through...
1064
thedigitguy
Mar 17, 2005 6:52 pm
The reason we don't use group items in the historical sense is that we don't always have the exact same items and quantities in a group even though it is the...
1065
Chuck Vigeant
txbtech
Mar 17, 2005 7:28 pm
Yes that is correct. Since that is the way you do it in QuickBooks, there would be no other alternative. In general the rules of the interface have to be...
1066
robbie2e
Mar 18, 2005 12:24 am
Any ideas on why I can not update pricing data for Service Items Here is my Code: strSQL_QBitems = "SELECT TOP 1 FullName, SalesOrPurchasePrice, ...
1067
Chuck Vigeant
txbtech
Mar 18, 2005 6:00 am
Do you have the "to be performed by a subcontractor" unchecked? Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
1068
mharris63
Mar 22, 2005 11:38 pm
... This has been solved. You need to Update the PurchaseOrder table when changing the RefNumber field to prevent Quickbooks from creating a new purchase...
1069
Robert Weis
robbie2e
Mar 22, 2005 11:38 pm
Yes I do, This is the error I get. It only occurs when I update the price. Error Type: Microsoft Cursor Engine (0x80040E38) Row cannot be located for...
1070
brdgriffin
Mar 24, 2005 7:40 am
I am using the TXNLSTBYCUSTOMER report to generate customised statements. It appears that by default all customer balances of $0 are ignored by default. What...
1071
citadelpartners
Mar 24, 2005 7:40 am
I have successfully inserted a billexpenseline when the quickbooks application is one of the traditional desktop versions. However when I try and insert into...
1072
citadelpartners
Mar 27, 2005 11:02 am
I think I have it solved. If I remove VendorRefFullName and just insert the VendorRefListID it appears to work. I'll test it some more but if I don't reply...
1073
Michael Wynn
mh_wynn
Mar 27, 2005 11:03 am
Hello, I am a NYC contractor and I am looking for someone to setup QB for my company. I need payroll with lots of reporting. i.e. union, job costing, etc.. ...
1074
mandleshwar
Mar 31, 2005 7:06 am
I have the following issue. I am creating and editing transactions in my external program and then posting them to QB via QODBC using code similar to the...
