I am working on a SQL insert statement for a Purchase order using your samples. When I run the query I get an error 3240, cannot find specified object (PurchaseOrderLineItemRefListID) which is the ListID  I got when I ran a VB demo query on the item table. I am pulling info from the wrong table?? Here are my insert statements

insert openquery(QODBC, 'select "VendorRefListID", "RefNumber",
"PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc",
"PurchaseOrderLineQuantity", "PurchaseOrderLineRate",
"PurchaseOrderLineAmount", "PurchaseOrderLineCustomerRefListID",
"FQSaveToCache" from PurchaseOrderLine Where 1=0')
VALUES ('1A00000-1088030604', 'JB998876', '850000-116800',
'See Attached 1', 1.0, 1.0, 1.11, '2030000-1111439758', 1)

insert openquery(QODBC, 'select "VendorRefListID", "RefNumber",
"PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc",
"PurchaseOrderLineQuantity", "PurchaseOrderLineRate",
"PurchaseOrderLineAmount", "PurchaseOrderLineCustomerRefListID",
"FQSaveToCache" from PurchaseOrderLine Where 1=0')
VALUES ('1A00000-1088030604', 'JB998876', '850000-116800',
'James Test', 1.0, 1.0, 2.22, '2030000-1111439758', 1)

insert openquery(QODBC, 'select "VendorRefListID", "RefNumber",
"PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc",
"PurchaseOrderLineQuantity", "PurchaseOrderLineRate",
"PurchaseOrderLineAmount", "PurchaseOrderLineCustomerRefListID",
"FQSaveToCache" from PurchaseOrderLine Where 1=0')
VALUES ('1A00000-1088030604', 'JB998876', '850000-116800',
'James Test', 1.0, 1.0, 2.22, '2030000-1111439758', 1)

INSERT OPENQUERY(QODBC, 'SELECT "VendorRefListID", "RefNumber", "Memo",
"IsToBePrinted" FROM PurchaseOrder WHERE 1=0')
VALUES ('1A00000-1088030604', 'JB998876', 'Memo Test', 0)

Any help would be greatly appreciated.

Thanks in advance.

In How do I create a Purchase Order using QODBC? 

PurchaseOrderLineItemRefListID is a existing Inventory Item ListID

To see the items available, you can run the following query in VB Demo:

SELECT ListID, FullName, Description, Type FROM Item

In my case, my Australian QuickBooks 2004 sample file returned the following items: