An Example of creating a PurchaseOrder

Note: This example creates one PurchaseOrder with three lines. Note the FQSaveToCache field, set to TRUE (1) except on the last line.

First Line

     INSERT INTO "PurchaseOrderLine" ("VendorRefListID", "RefNumber",
     "PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc",
     "PurchaseOrderLineQuantity", "PurchaseOrderLineRate",
     "PurchaseOrderLineAmount", "PurchaseOrderLineCustomerRefListID",
     "FQSaveToCache") VALUES ('390000-1039739488', '1', '670004-1044572237',
     'See Attached 1', 1.0, 1.0, 1.11, '4C0000-1040154668', 1)

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

Second Line

     INSERT INTO "PurchaseOrderLine" ("VendorRefListID", "RefNumber",
     "PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc",
     "PurchaseOrderLineQuantity", "PurchaseOrderLineRate",
     "PurchaseOrderLineAmount", "PurchaseOrderLineCustomerRefListID",
     "FQSaveToCache") VALUES ('390000-1039739488', '1', '670004-1044572237',
     'See Attached 2', 2.0, 2.0, 2.22, '4C0000-1040154668', 1)

Third (Last) Line

     INSERT INTO "PurchaseOrderLine" ("VendorRefListID", "RefNumber",
     "PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc",
     "PurchaseOrderLineQuantity", "PurchaseOrderLineRate",
     "PurchaseOrderLineAmount", "PurchaseOrderLineCustomerRefListID",
     "FQSaveToCache") VALUES ('390000-1039739488', '1', '670004-1044572237',
     'See Attached 3', 3.0, 3.0, 3.33, '4C0000-1040154668', 0)

Results in QuickBooks

     This results in the following Purchase Order being created by QODBC using the QuickBooks 2022 Enterprise USA Edition and the Sample company file as an example:

Related Data Description

VendorRefListID is the ListID for the Vendor found by doing :

     Select * from Vendor

PurchaseOrderLineItemRefListID is the existing Inventory Item ListID found by using:

    Select ListID, FullName, Description, Type FROM Item

PurchaseOrderLineCustomerRefListID is the ListID for the customer found by doing :

     Select * from Customer

Note: If you want to create Purchase Order without using CustomerRefListID, then you can remove it from your query because it is optional. Please refer below sample query:

  INSERT INTO "PurchaseOrderLine" ("VendorRefListID", "RefNumber", "PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc", "PurchaseOrderLineQuantity", "PurchaseOrderLineRate", 
     "PurchaseOrderLineAmount", "FQSaveToCache") VALUES ('10000-933272655', '1', '250000-933272656', 'See Attached 1', 1.0, 1.0, 1.11,0)

Insert into PurchaseOrder with All Shared Header Information

Note: The FQSaveToCache field, set to True on all the PurchaseOrderLines. Saving the Purchase Order header saves the lines with it. Here is an example that creates one Purchase Order with three lines.

First Line

INSERT INTO "PurchaseOrderLine" ("PurchaseOrderLineItemRefListID",
"PurchaseOrderLineDesc", "PurchaseOrderLineQuantity",
"PurchaseOrderLineRate", "PurchaseOrderLineAmount",
"PurchaseOrderLineCustomerRefListID", "FQSaveToCache") VALUES
('250000-933272656', 'See Attached 1', 1.0, 1.0, 1.11, '580000-1071526281', 1)

Second Line

INSERT INTO "PurchaseOrderLine" ("PurchaseOrderLineItemRefListID",
"PurchaseOrderLineDesc", "PurchaseOrderLineQuantity",
"PurchaseOrderLineRate", "PurchaseOrderLineAmount",
"PurchaseOrderLineCustomerRefListID", "FQSaveToCache") VALUES
('250000-933272656', 'See Attached 2', 2.0, 2.0, 2.22, '580000-1071526281', 1)

Third Line

INSERT INTO "PurchaseOrderLine" ("PurchaseOrderLineItemRefListID",
"PurchaseOrderLineDesc", "PurchaseOrderLineQuantity",
"PurchaseOrderLineRate", "PurchaseOrderLineAmount",
"PurchaseOrderLineCustomerRefListID", "FQSaveToCache") VALUES
('250000-9332 72656', 'See Attached 3', 3.0, 3.0, 3.33, '580000-1071526281', 1)

Shared Header Information

INSERT INTO "PurchaseOrder" ("VendorRefListID", "RefNumber", "Memo",
"IsToBePrinted") VALUES ('10000-933272655', '1', 'Memo Test', 0)