Knowledgebase
[QODBC-Desktop] How to create Item Groups using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

Examples of Creating Item Groups

Create One ItemGroup with No Lines

INSERT INTO "ItemGroup" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup") VALUES ('TestWOLines', 1, 'Test Item Desc', 1)

Create One ItemGroup with Three Lines

Note: This creates one ItemGroup with three lines. Note the FQSaveToCache field, set to True except on the last one.

First Line

INSERT INTO "ItemGroupLine" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup", "ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('Test1 W3 Lines 1', 1, 'Test Item Desc', 1, '390000-1071512145', 1.0, 1)

Second Line

INSERT INTO "ItemGroupLine" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup", "ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('Test1 W3 Lines 2', 1, 'Test Item Desc', 1, '320000-1071525597', 2.0, 1)

Third (Last) Line

INSERT INTO "ItemGroupLine" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup", "ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('Test1 W3 Lines 3', 1, 'Test Item Desc', 1, '10000-933272655', 3.0, 0)

Result in QuickBooks

The result looks like this in QuickBooks 2006:

Create One ItemGroup with Three Lines with Shared Header Information

Note: This creates one ItemGroup with three lines. Note the FQSaveToCache field, set to True. Saving the ItemGroup saves the lines with it.

First Line

INSERT INTO "ItemGroupLine" ("ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('390000-1071512145', 1.0, 1)

Second Line

INSERT INTO "ItemGroupLine" ("ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('320000-1071525597', 2.0, 1)

Third Line

INSERT INTO "ItemGroupLine" ("ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('10000-933272655', 3.0, 1)

Shared Header Information

INSERT INTO "ItemGroup" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup") VALUES ('Test2 W3 Lines', 1, 'Test Item Desc', 1)

See also: How to Invoice ItemGroups.

(131 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).