This creates one itemgroup with no lines.
INSERT INTO "ItemGroup" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup") VALUES ('TestWOLines', 1, 'Test Item Desc', 1)
This creates one itemgroup with three lines. Note the FQSaveToCache field, set to True except on the last one.
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)
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)
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)
and the result looks like this in QuickBooks 2006:
This creates one ItemGroup with three lines. Note the FQSaveToCache field, set to True. Saving the ItemGroup saves the lines with it.
INSERT INTO "ItemGroupLine" ("ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('390000-1071512145', 1.0, 1)
INSERT INTO "ItemGroupLine" ("ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('320000-1071525597', 2.0, 1)
INSERT INTO "ItemGroupLine" ("ItemGroupLineItemRefListID", "ItemGroupLineQuantity", "FQSaveToCache") VALUES ('10000-933272655', 3.0, 1)
INSERT INTO "ItemGroup" ("Name", "IsActive", "ItemDesc", "IsPrintItemsInGroup") VALUES ('Test2 W3 Lines', 1, 'Test Item Desc', 1)
See also: How do I invoice item groups? |