Easysoft ODBC-QuickBooks Desktop Driver

How do I create and invoice an new customer in QuickBooks

Article:
01105
Last Reviewed:
9th January 2017
Revision:
3

Create the Customer

INSERT INTO customer

("Name", "FirstName", "LastName", "CompanyName", "Contact", "AccountNumber", "BillAddress_Addr1", "BillAddress_Addr2",
 "BillAddress_Addr3", "BillAddress_City", "BillAddress_State", "BillAddress_PostalCode", "Phone", "Fax", "Email",
 "TermsRef_ListID", "SalesTaxCodeRef_ListID", "PreferredPaymentMethodRef_FullName", "CreditCardInfo_CreditCardNumber",
 "CreditCardInfo_ExpirationMonth", "CreditCardInfo_ExpirationYear", "CreditCardInfo_NameOnCard",
 "CreditCardInfo_CreditCardAddress", "CreditCardInfo_CreditCardPostalCode",  JobStatus", "JobStartDate", "JobEndDate",
 "JobDesc")

VALUES

('Amy''s Bird Sanctuary', 'Amy', 'Lauterbach', 'Amy''s Bird Sanctuary', 'Amy Lauterbach', '123456', 
 'Amy''s Bird Sanctuary', '4581 Finch St.', 'Suite 456', 'Bayshore', 'CA', '94326', 
 '(650) 555-3311', '(650) 555-3312', 'Birds@Intuit.com', '10000-933272658', '10000-999022286', 'Visa', 
 '4111111111111111', 06, 2018, 'Amy Lauterbach', '4581 Finch St. Suite 456', 
 '94326', 'None', {d'2017-01-09'}, null, '£30 Weekly Gardening Service'
)

Find Out the ListID of the New Customer


Create the Customer


 
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.