Download ODBC Drivers for Oracle®, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

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.