When using QODBC we often use the ListID of the tables we are using in our INSERT statements, but we can also use the FullName instead. This INSERT creates a invoice for a stock item using names instead of the double dutch ListIDs:
USA QuickBooks Users:
INSERT INTO "InvoiceLine" ("CustomerRefFullName", "RefNumber", "InvoiceLineItemRefFullName", "InvoiceLineDesc", "InvoiceLineQuantity", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefFullName", "FQSaveToCache") VALUES ('Hadrians Wall Company', '1001', 'Ladder', '4m Steel Ladder', 3.00000, 150, 450.00, 'Non', 0)
Non USA QuickBooks users:
INSERT INTO "InvoiceLine" ("CustomerRefFullName", "RefNumber", "InvoiceLineItemRefFullName", "InvoiceLineDesc", "InvoiceLineQuantity", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineTaxCodeRefFullName", "FQSaveToCache") VALUES ('Hadrians Wall Company', '1001', 'Ladder', '4m Steel Ladder', 3.00000, 150, 450.00, 'GST', 0)
and creates the following invoice in QuickBooks:
See: How do I create Invoices? for more information. |