Actually you need to check the ITEM table first. The ITEM table is a combined list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields.
When inserting a new ItemInventory item the FullName can't be, for example, a ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup already. It must be a unquie new ITEM FullName!
To see the item fullnames, 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:
And like ITEM there's a ENTITY table that's the combined list of all entity tables in QuickBooks: Customers, Employees, Othernames, and Vendors; with minimum common fields.
So when inserting a new Customer name the FullName can't be, for example, a Customer, Employee, Othername, or Vendor already. It must be a unquie new ENTITY FullName in QuickBooks!
|