I am currently imporing a packing list table from ACCESS into QB v.7, which makes an invoice in QB.  I have a custom field next to the [ INS / WEIGHT ] field above where the tax line is on the invoice.  That VB string do I use to put in that field.  I was told that QODBC does not support custom fields in the line items section.  Thank-you in advance for your help.

The first thing you need to do is to identify the Custom Field you wish to use. In QuickBooks open a customer and click on the Additional Info tab and look at the custom fields you have set up. I will use "Contract #" in my example:

Using VBDemo you can view the custom fields I can use in an invoice by running:

sp_columns InvoiceLine 'CustomField%'

In my example Contract # is the column called CustomFieldContract in QODBC.

TO CREATE THE INVOICE WITH Contract # I DO:

INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID",
"FQSaveToCache", "CustomFieldContract")
VALUES ('AC0000-1197757899', 'Custom 1', '250000-933272656', 'Bin Permit Renovations',
200.00000, 200.00, '20000-999022286', 0, '1234-5678')