Below are two insert statements that return an error: "There is a missing element: TxnID" These inserts work fine on a different QB database file ... what gives?
INSERT INTO InvoiceLine (CustomerRefFullName, ClassRefFullName, TemplateRefFullName, BillAddressAddr1, BillAddressAddr2, BillAddressCity, BillAddressState, BillAddressCountry, ShipDate, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache, CustomFieldreferral) VALUES ('Abbas Aida', 'Class Name', 'DMK Medical PLLC', '', '', '', '', '', {d'2006-06-29'}, 'Procedures Facial:Platysmaplasty - Short Flap', 'Platysmaplasty - Short Flap', 1, 'Non', 1, '17')
INSERT INTO InvoiceLine (CustomerRefFullName, ClassRefFullName, TemplateRefFullName, BillAddressAddr1, BillAddressAddr2, BillAddressCity, BillAddressState, BillAddressCountry, ShipDate, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache, CustomFieldreferral) VALUES ('Abbas Aida', 'Class Name', 'DMK Medical PLLC', '', '', '', '', '', {d'2006-06-29'}, 'Procedures Facial:Lifestyle Lift', 'Lifestyle Lift', 1, 'Non', 0, '17')
|