[QODBC-Desktop] How to insert data into ItemService using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
Example of Create an ItemService Item
Note: VB Demo is deprecated.
Please refer to How to use the QODBC Test Tool for testing
Note: This is an example of how to add a new ItemService Item. You can also use the stored procedure "sp_lastinsertid ItemService" immediately after the insert statement to retrieve a record set that has the ListID of the new service item you just inserted.
Query in QODBC
INSERT INTO ItemService
Result in QuickBooks
Once the statement above is executed, the following new Service appeared in QuickBooks 2006:
Unique Item Name
But before you add any new Service Items, you should check the ITEM table first to see if the new Service Item Name is not already used in QuickBooks.
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)
Locate Item FullName
To see the item FullName, you can run the following query in VB Demo:
SELECT ListID, FullName, Description, Type FROM Item
ENTITY Table Related
And like ITEM, there's an ENTITY table that's the combined list of all entity tables in QuickBooks:
Customers, Employees, Other names, and Vendors (with minimum common fields)