Knowledgebase
[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: This is an example of how to add a new ItemService ItemYou 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
     ("Name", "IsActive", "SalesORPurchaseDesc",
     "SalesTaxCodeRefListID", "SalesOrPurchasePrice", "SalesOrPurchaseAccountRefListID")
     VALUES
     ('Priority Support', TRUE, 'QODBC Priority Support Incident',
     '20000-999022286', 33.00, '190000-933270541')


Note: 
 VB DEMO is to be used for testing of QODBC SQL queries only and is not a development tool.

 

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)

     When inserting a new ItemService item the Name can't already be, for example, an ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup FullName already. It must be a unique new ITEM FullName!

Locate Item FullName

     To see the item FullName, 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:

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)

     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 unique new ENTITY FullName in QuickBooks!

(175 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).