An Example of PurchaseOrder Item Groups

Create an ItemGroup with Three Lines

Note: Let's create a new item group example with three lines using QODBC. 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 Dec, 1, '8000009D-1481800631', 1.0, 1)

Note:  QODBC Support Wizard is used only to test QODBC SQL queries and is not a development tool.

Second Line

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

Third (Last) Line

INSERT INTO "ItemGroupLine" ("Name," "IsActive," "ItemDesc," "IsPrintItemsInGroup," "ItemGroupLineItemRefListID," "ItemGroupLineQuantity," "FQSaveToCache") VALUES ('Test1 W3 Lines 3', 1, 'Test Item Dec, 1, '6D0003-1044572301', 3.0, 0)

Result in QuickBooks

The result looks like this in QuickBooks 2022:

SELECT ListID, Name, ItemDesc, IsActive FROM ItemGroup

Invoice the ItemGroup

Note: We can now create PurchaseOrder using the item group by utilizing the ListID:'8000009F-1481791619' and making one simple QODBC insert statement below.

INSERT INTO "PurchaseOrderLine" ("VendorRefListID," "RefNumber," "PurchaseOrderLineGroupItemGroupRefListID," "FQSaveToCache") VALUES ('390000-1039739488', 'Group2', '8000009F-1481791619', 0)

Result in QuickBooks

When we look at the new invoice in QuickBooks 2013, we will see the following:

Note: Qty, Rate, and the Amount are shown as per Qty, Rate, and the Amount for the service or stock item