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...
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...
... 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?...
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...
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...
... 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 ...
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....
... 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...
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...
... 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...
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...
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...
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...
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...
Preferences. AccountingPrefsClosingDate That is from the documentation at www.qodbc.com/schema.html Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks...
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...
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...
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...
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...
Do you have the "to be performed by a subcontractor" unchecked? Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
... This has been solved. You need to Update the PurchaseOrder table when changing the RefNumber field to prevent Quickbooks from creating a new purchase...
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...
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...
I have successfully inserted a billexpenseline when the quickbooks application is one of the traditional desktop versions. However when I try and insert into...
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...
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.. ...
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...
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.
