To complete this exercise, you must be in the Sample company. From your QBOA account, click on the Gear icon on the top right corner of the screen, then select Sample company.
Zoom Saved
Note that you will be logged out of your current account. If you are sure, click "Continue" to confirm.
Zoom Saved
Now let's get started with the exercise.
First, let's create a duplicate customer account.
2
From the left navigation bar, hover over Sales, then select "Customers".
Zoom Saved
3
Click "New customer".
Zoom Saved
The new customer will be named Jon Melton (no "h" in the first name). We will use the same phone number and address as the existing customer, John Melton:
85 Pine Street, Menlo Park, CA 94304 \
(650) 555-5879
4
In Customer display name field, type "Jon Melton".
Zoom Saved
5
In the Phone number field, type "(650) 555-5879".
Zoom Saved
6
Complete the address fields: 85 Pine Street, Menlo Park, CA 94304.
Zoom Saved
7
Click "Save".
Zoom Saved
Let's see how you would run a report to find any duplicates.
8
From the left navigation bar, click "Reports".
Zoom Saved
9
Click "Customer Contact List".
Zoom Saved
If any pop-ups appear, just click out of them.
As we look at the report, we can see there are two similarly named customers with the same address and contact phone number.
But what if it wasn't so obivous when looking for duplicates? Perhaps we can look at this another way. Let's sort it by ZIP code.
Zoom Saved
10
Click "Group".
Zoom Saved
11
In the Group field, select "Billing ZIP code".
Zoom Saved
The report on the left side will automatically update and group by Zip Code.
12
Click the "X" to exit.
Zoom Saved
When you scroll down to 94304, you can see the two accounts, one for John Melton and the other for Jon Melton.
Again, when looking at the report, it's obvious to see this is the same customer as they have the same address and contact phone number.
Zoom Saved
Was this Scribe helpful? Save this document for future reference.
Save for Later
Have something to say?Create an account to leave messages for the author to see!Create an account
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe