| Let's start by creating a new itemgroup example with three lines using QODBC. 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:
To locate the ListID of the new Item Group (or any group), simply do:
SELECT ListID, Name, ItemDesc, IsActive FROM ItemGroup
We can now raise a Purchase Order using item group by using the ListID: '580000-1197762645' and doing one simple QODBC insert statement:
INSERT INTO "PurchaseOrderLine" ("VendorRefListID", "RefNumber",
"PurchaseOrderLineGroupItemGroupRefListID","FQSaveToCache")
VALUES ('10000-933272655', 'Group1', '580000-1197762645', 0)
When we look at the new Purchase Order in QuickBooks 2006 we will see:
Note: The Qty, Rate and the Amount are shown as 0 for Floor Plans and Concrete Slab, not because QODBC made a mistake. You simply need to correct the rate for the service or stock item:
|
