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. Saving the ItemGroup saves the lines with it. Note the FQSaveToCache field, set to True.

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.