[QODBC-Desktop] How to add an Inventory Item using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
|
|
Example of Add an Inventory ItemNote: This is an example of how to add an ItemInventory Item. You can also use the stored procedure "sp_lastinsertid ItemInventory" immediately after the insert statement to retrieve a recordset that has the ListID of the new item you just inserted. Query in QODBCINSERT INTO ItemInventory ("Name", "IsActive", "SalesDesc", "SalesPrice", "IncomeAccountRefListID", "PurchaseDesc", "PurchaseCost", "COGSAccountRefListID", "PrefVendorRefListID", "AssetAccountRefListID", "ReorderPoint", "QuantityOnHand", "TotalValue", "InventoryDate") VALUES ('NewItemInventory', TRUE, 'SalesNew', 0.0013, '1A0000-933270542', 'PurchaseNew', 0.005, '1E0000-933270542', 'A40000-1197774038', '60000-933270541', 25.0, 50.0, 10.0, {d'2005-10-07'})
Updating Inventory Item update ItemInventory set PurchaseDesc='Here is my details on purchase', salesdesc='Sales description goes here' where FullName='Air Conditioning' Result in QuickBooksAbove queries results in this in the USA Sample Rock Castle Construction company file in QuickBooks 2006: NotesUnique Item FullName Before you add any new Inventory Items, you should check the ITEM table first to see if the new Inventory Item Name is not already used in QuickBooks. The ITEM table is a combined list of all Item tables in QuickBooks as below: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup (with minimum common fields) Locate Item FullName To see the item full names, you can run the following query in VB Demo: Entity Table ReferenceAnd like ITEM there's an ENTITY table that's the combined list of all entity tables in QuickBooks: Customers, Employees, OtherNames, and Vendors (with minimum common fields)
| |
|