[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 ItemNote: 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 QuickBooksOnce the statement above is executed, the following new Service appeared in QuickBooks 2006:
Unique Item NameBut 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 FullNameTo see the item FullName, you can run the following query in VB Demo: SELECT ListID, FullName, Description, Type FROM Item
ENTITY Table RelatedAnd 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) | |
|