I would have thought this was simple (it probably is), but I am having a problem adding records to the item table.

I have added records to other tables (customer, invoice header, invoice lines) but for some reason cannot get the items added.

I have use sp_columns item in VB Demo 32 and see which fields are required on insert and which are "Nullable", although I am not sure if all required fields need data, or if fieldname="" is acceptable.

Can you tell me which fields are required as a minimum? From what I can tell, the following are required:

Name 
Description 
IncomeAccountRefFullName 
SalesOrPurchasePrice 
SalesOrPurchasePricePercent 
SalesOrPurchaseAccountRefListID 
SalesOrPurchaseAccountRefFullName 
SalesAndPurchaseIncomeAccountRefListID 
SalesAndPurchaseIncomeAccountRefFullName 
SalesAndPurchaseExpenseAccountRefListID 
SalesAndPurchaseExpenseAccountRefFullName 
IncomeAccountRefListID 
IncomeAccountRefFullName 
COGSAccountRefListID 
COGSAccountRefFullName 
AssetAccountRefListID 
AssetAccountRefFullName

Am I missing something?

Thanks in advance.

Jay

The ITEM table is a combined (read only view) list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields.

Inserts and updates are actually done using the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup tables.

See: How do I add a Inventory Item using QODBC? 
        How do I insert data into ItemService? 
        How do I insert data into ItemNonInventory? 
        How do I create a Item Assembly (ItemInventoryAssembly)? for more.

Thanks, Tom. I am sure that will take care of it.

Is there any way that I should have known that "ITEM table is a combined (read only view) list of all Item tables in QuickBooks"? Or is that part of what they tell you when they show you the secret handshake ? <grin>

Jay