It seems to me that the DepositLine table is not being processed correctly. I tried importing this table into MS Access 2000 and found that while the...
Quickbook Clients will not close after running a query against the Check table. I used logging in the ODBC config and logs shows database close was issued and...
We will take a look into this right away, thanks for the detailed information! The way QuickBooks SDK handles child record line items is particularly...
Which client are you using? Some applications don't close properly, and in those cases you must close QuickBooks via the task manager, but there is no risk of...
The Client is Quickbooks 2003 The program that is reading the Check Table is Compiled Perl That's how I've been closing it but it makes me a little nervous. ...
... The Client is Perl - and it is not closing the files properly. Check with the Perl documentation and check for ways you can flush all buffers and sever the...
... GHR Renew U is a 100 % Natural Nutraceutical Capsule product developed in our own laboratories by our chemists and clinically tested by doctors in studies...
Anthony Smith
anthony_smith_524@...
Mar 6, 2003 3:16 pm
42
Hi! I'd like to know how to access the prefered Payment Method info for a customer? It is not listed on the Customer table schema. Thanks Ellis...
Hello - I am hoping to create invoices in QB Pro 2002 using QODBC, and am wondering if anyone on this group knows if this is possible. After looking at the...
Richard, I think there are other fields that you want to copy in on the invoice header (billing and shipping address, etc.). The schema definition says that...
As I understand it from Brad, Invoice (header & lines) are READONLY at this point. Invoice creation is not a feature of the ODBC driver at the moment. I heard...
Version 3.0.0.013 - Readme.rtf < The SDK that we use from Intuit requires that you have an open session of QuickBooks when using QODBC to make a connection to...
John, A quick question on the schema definition from QODBC, is there a further explanation of the column titles? Because on the Invoice file, the column labled...
If you have a Visual Basic background, you could access Intuit's QBFC (QuickBooks foundation class) COM object to handle invoice creation. (You might want to...
John, Brian: Thank you for the responses. I'll keep watching the newsgroup, and also for the QODBC release. Don't want to fool with QBFC if the SDK allows it...
We are currently working on tutorials for inserting invoices, among other items which have child records, when it is available, we will notify our mailing list...
QuickBooks must always be "running" in memory of the machine you wish to use the qbXML system on. this does not mean it has to be loaded as a foreground...
The reason some files are read-only is only because we are designing a method of saving the child records and the parent at the same time. ODBC, being record...
If it is not listed in our schema document, it is not available from the QuickBooks SDK, the method we use for accessing information from QuickBooks files. If...
Brad, I dont' believe ODBC supports transactions, but perhaps you could do a pseudo-transaction environment to handle invoice headers and related child records...
I'm confused how the ODBC driver would work in a multi-user environment. *NOTE: PC1 & PC2 are on a local network. PC1 - Has QuickBooks running on it. PC2 - Has...
At the moment the plan is to use work tables to load all of the parts into, then do a passthru query calling a stored procedure to post all of the work tables...
... It cannot. You will have to purchase a copy of QuickBooks for PC2. However, we are working on a possible work-around to this in a future version. In a...
I currently have a QuickBooks 2001 client who needs a specific report generated that QB will not do. Can we use Crystal Reports? And how do I go about doing...
Crystal Reports will work with QuickBooks data if you use the QODBC Driver on your system. However it is limited to QuickBooks 2002 Pro and 2003 Pro versions....
Brad, I asked this before but I'm not sure if you saw it. 1) Is there an explanation of the column titles for your schema document 2) Is there a listing of the...
... Column titles are: Name - field name Field Type - char numeric date etc Field Length - total length Query - can you use a select statement to view this...
Brad, Thank you for your response! ListID type fields and others that are marked N/A seem to be system generated fields or time stamps, does the driver (on QB...