This creates one vendorcredit with three lines. Note the FQSaveToCache field, set to True except on the last one.
INSERT INTO "VendorCreditItemLine" ("VendorRefListID", "APAccountRefListID", "TxnDate", "RefNumber", "Memo", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineCost", "ItemLineQuantity", "ItemLineAmount", "ItemLineCustomerRefListID", "FQSaveToCache") VALUES ('90000-933272656', 'C0000-933270541', {d'2003-12-15'}, '1', 'Memo Test', 'E0000-933272656', 'Install tile or counter', 1.11, 1.00, 1.11, '280000-933272658', 1)
INSERT INTO "VendorCreditItemLine" ("VendorRefListID", "APAccountRefListID", "TxnDate", "RefNumber", "Memo", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineCost", "ItemLineQuantity", "ItemLineAmount", "ItemLineCustomerRefListID", "FQSaveToCache") VALUES ('90000-933272656', 'C0000-933270541', {d'2003-12-15'}, '1', 'Memo Test', 'D0000-933272656', 'Roofing', 2.22, 2.00, 4.44, '280000-933272658', 1)
INSERT INTO "VendorCreditItemLine" ("VendorRefListID", "APAccountRefListID", "TxnDate", "RefNumber", "Memo", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineCost", "ItemLineQuantity", "ItemLineAmount", "ItemLineCustomerRefListID", "FQSaveToCache") VALUES ('90000-933272656', 'C0000-933270541', {d'2003-12-15'}, '1', 'Memo Test', '250000-933272656', 'Permit', 3.33, 3.00, 9.99, '280000-933272658', 0)
This creates one VendorCredit with three lines. Note the FQSaveToCache field, set to True. Saving the VendorCredit will save the lines.
INSERT INTO "VendorCreditItemLine" ("ItemLineItemRefListID", "ItemLineDesc", "ItemLineCost", "ItemLineQuantity", "ItemLineAmount", "ItemLineCustomerRefListID", "FQSaveToCache") VALUES ('E0000-933272656', 'Install tile or counter', 1.11, 1.00, 1.11, '280000-933272658', 1)
INSERT INTO "VendorCreditItemLine" ("ItemLineItemRefListID", "ItemLineDesc", "ItemLineCost", "ItemLineQuantity", "ItemLineAmount", "ItemLineCustomerRefListID", "FQSaveToCache") VALUES ('D0000-933272656', 'Roofing', 2.22, 2.00, 4.44, '280000-933272658', 1)
INSERT INTO "VendorCreditItemLine" ("ItemLineItemRefListID", "ItemLineDesc", "ItemLineCost", "ItemLineQuantity", "ItemLineAmount", "ItemLineCustomerRefListID", "FQSaveToCache") VALUES ('250000-933272656', 'Permit', 3.33, 3.00, 9.99, '280000-933272658', 1)
INSERT INTO "VendorCredit" ("VendorRefListID", "APAccountRefListID", "TxnDate", "RefNumber", "Memo") VALUES ('90000-933272656', 'C0000-933270541', {d'2003-12-15'}, '1', 'Memo Test') |