Creating Customer
There are three ways to add new customers: A) Using the Customers window;
B) Using the Invoice worksheet; and C) Copying from an existing customer.
A) Creating a New Customer Using the Customers Window
- Click and select the Invoice worksheet if it has not already been selected.
- Click the Customers button on the Invoice worksheet to display
the Customers window. This window displays all customers in the database.
(Click to enlarge)
- Click the Add Customer button.
- In the New Customer window fill in your customer's information.
The only required field for a customer is the Name field. All other fields
are optional and a customer ID is automatically generated if one is not filled in.
(Click to enlarge)
- Click the Add Customer button.
- Click Save Changes button to save this customer. If succeed, the New Customer window
becomes the Customer Edit window.
(Click to enlarge)
B) Creating a New Customer Using the Invoice Worksheet
- Click and select the Invoice worksheet if it isn't already selected.
- Fill in your customer's information in the appropriate field near the Bill To label.
Again, the only required field for a customer is the Name field.
All other fields are optional and a customer ID is automatically generated if one is not filled in.
- Click the Save As New Customer button on the Invoice worksheet
to create the customer.
C) Creating a New Customer by Copying an Existing One
- Click and select the Invoice worksheet if it isn't already selected.
- Click the Select Customer icon button (the magnifier icon) to display the Customers
selection dialog box, and then double click to select the customer.
All customer information will be written to the Invoice worksheet, including the customer ID.
- On the Invoice worksheet, clear the customer ID field, and modify other fields
as needed.
- Click the Save As New Customer button to create a new customer.
Please move to the Customer Detail section of this chapter for a detailed
explanation of the Customer Edit window.
|
EXCEL INVOICE MANAGER