Hello...
I am evaluating the qodbc driver to determine if it will suit the business needs of my company. One thing I need to be able to do is insert an invoice line from a table in a MS SQL Server 2005 database, into the table InvoiceLine in QuickBooks.
Right now I am just linking the two tables (my sql invoice table and the quickbooks invoiceline table) into an Access database. Here is a query that will supposedly add an invoice line to the invoiceline table (I got this from this forum):
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID") VALUES ('470001-1071525403', '1', '250000-933272656', 'Building permit 1', 1.00000, 1.00, '20000-999022286')
This query is all hard-coded... which is fine if that's what people need. But I need to be able to pull data from another table. So, my values would come from a select statement. That's still not the problem though. The problem is that I can't find the definitions for the InvoiceLine or Invoice table anywhere. There is a place on the qodbc website that lists many of the quickbooks tables... however the ones I mentioned are not listed. So I have no way of knowing which fields are required, or which fields are not allowed to be inserted.
So, finally... my question. If I'm going to run an insert query like the one above... except I am going to select my data from anther table (or set of tables) where do I get the values for these fields: "CustomerRefListID", "RefNumber", and "InvoiceLineItemRefListID". I've tried... and you can't just make up answers for these fields. So I know that they come from some other related table in QuickBooks... Which Table???
I really hope someone can help me on this... and if so, I really appreciate it!
Thanks,
Rodney |