Editing Customers

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 1: Line 1:
{{#ev:youtube|Ybxk061nD60}}
+
<videoflash>Ybxk061nD60</videoflash>
  
 
<br>There are a couple ways to create a new customer.
 
<br>There are a couple ways to create a new customer.
Line 21: Line 21:
 
# Fill out the '''Site''' tab with the company and address information.
 
# Fill out the '''Site''' tab with the company and address information.
 
# Select the '''Billing''' tab.
 
# Select the '''Billing''' tab.
# Click '''Set From Site''' (arrow in image below)
+
# Click '''Set From Site''' (circled in image below).
 
# The address from the Site tab will populate the Billing tab.
 
# The address from the Site tab will populate the Billing tab.
 
# Select the '''Mailing''' tab.
 
# Select the '''Mailing''' tab.
 
# Click '''Set From Site'''.
 
# Click '''Set From Site'''.
 
# The address from the Site tab will populate the Mailing tab.
 
# The address from the Site tab will populate the Mailing tab.
<br>[[File:BillingSetFromSite.png]]
 
  
 
In some cases you may have one customer you are working with and you have multiple job sites for them. You can create a parent child relationship.  If you do this, you could look up the parent company and find all of the related “child” companies.
 
In some cases you may have one customer you are working with and you have multiple job sites for them. You can create a parent child relationship.  If you do this, you could look up the parent company and find all of the related “child” companies.
Line 52: Line 51:
 
# Click your cursor in the '''Contact''' field.
 
# Click your cursor in the '''Contact''' field.
 
# Type the contact name.
 
# Type the contact name.
# Tab to the next field and the '''Contact Editor''' will display. (image below)
+
# Tab to the next field and the '''Contact Editor''' will display. (image on the right)
 
# Fill out the contact information.
 
# Fill out the contact information.
 
# Click '''OK'''.
 
# Click '''OK'''.
<br>[[File:ContactEditor23.png]]
 
  
 
<h3>Syncing Customer to QB</h3>
 
Review the '''[[SQLink]]''' page to determine the best settings for syncing customer names from SME to QB Company and Customer name fields.
 
<br>http://high5software.com/mediawiki/index.php?title=SQLink#Billing_Name_Options
 
 
<h4>Phone Number syncing to QB Company</h4>
 
When entering a new customer in SME, the first and third phone number fields sync to QuickBooks Phone and FAX phone numbers as shown in the image below. Even if you change the phone label in SME, it still will sync the first and third phone number fields.
 
<br>[[File:CustomerPhoneNumberSync.png]]
 
 
<h4>Leaving Site Address Blank</h4>
 
If you leave the Site Address blank in SME, after your sync with QuickBooks, the billing address will populate the site tab. To keep the billing address out of the site tab, put a "." in the address1 field on the site tab.
 
<br>click here for screenshots: http://high5software.com/mediawiki/index.php?title=SQLink_FAQ#Customer_Site_Address_is_populating_with_Billing_Address_After_Sync
 
 
<h4>Edits to SME Customers syncing to QB</h4>
 
If you edit a customer in SME, the customer will be set to sync to QB on the next sync. You will see the Export to QB flag checked. Once synced, the flag will be cleared.
 
 
<h3>Updating Site and Billing Address in SME</h3>
 
To update existing open orders and open invoices with the new address, all other users must be logged out of SME. Then you can check Propagate and save the customer.
 
<br>[[File:PropagateToOrders.png]]
 
<br>If other users aren't logged out of SME, the you will get this message:
 
<br>[[File:Propagate_SingleUserMode.png]]
 
 
<h3>Mailing Tab</h3>
 
If you fill out an address on the '''Mailing''' tab and check '''Use on Invoices''', then on any invoice created for that customer, the mailing address will populate the Site tab.
 
<br>[[File:MailingTab_UseOnInvoices.png]]
 
 
<br>When a work order is invoiced, the Site tab shows the info from the Mailing tab because '''use on invoice''' is checked.
 
<br>[[File:MailingTab_showOnInvoiceSiteTab.png]]
 
 
<h3>Fields in the Customer Record - Details and Settings tab</h3>
 
 
    
 
    
 
'''Account #''' - Based on the settings your SME Administrator setup, this field is auto populated when you save the company record.
 
'''Account #''' - Based on the settings your SME Administrator setup, this field is auto populated when you save the company record.
  
'''Balance''' - Displays the amount due for all open invoices for the customer. This is a calculation and it is not an editable field. If you have parent/child customer structure, the child/site customer balance is added to the parent balance and the child balance is 0.00
+
'''Balance''' - Displays the amount due for all open invoices for the customer. This is a calculation and it is not an editable field.
  
 
'''Salesperson''' - Select from the salesperson in the Salesperson drop down. The names in this drop down are determined by your SME Administrator.
 
'''Salesperson''' - Select from the salesperson in the Salesperson drop down. The names in this drop down are determined by your SME Administrator.
Line 100: Line 68:
 
'''URL''' - Type the customers website address
 
'''URL''' - Type the customers website address
  
'''Location''' - Warehouse location for customer equipment in your warehouse.
+
'''Location''' - Warehouse location for customer equipment in your warehouse
<br> - Here is information about Customer Warhouses: http://high5software.com/mediawiki/index.php?title=Warehouses#Customer_Warehouses
 
  
 
'''Messages''' - The messages box contains a list of emailed notifications, as well as calculated data based on current information. For example if account is past due, if maintenance/warranty has expired, when the next activity is scheduled for the customer, etc.  Clearing the message clears the notification messages, but the calculated messages are always there.
 
'''Messages''' - The messages box contains a list of emailed notifications, as well as calculated data based on current information. For example if account is past due, if maintenance/warranty has expired, when the next activity is scheduled for the customer, etc.  Clearing the message clears the notification messages, but the calculated messages are always there.
Line 108: Line 75:
  
 
On this tab you will find your customer’s account information. Depending on the permissions set by your SME Administrator, this tab may be hidden from view. At the bottom of the tab, find the customer’s balance due.
 
On this tab you will find your customer’s account information. Depending on the permissions set by your SME Administrator, this tab may be hidden from view. At the bottom of the tab, find the customer’s balance due.
<br>[[File:Customer_AccountsTab.png]]
 
 
 
{| class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-border-insidev: none"
 
{| class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-border-insidev: none"
 
|- style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"
 
|- style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"
Line 130: Line 95:
 
'''Finance Charge'''
 
'''Finance Charge'''
 
| style="width: 531.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="709" valign="top" |
 
| style="width: 531.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="709" valign="top" |
Enter the finance charge. Click''' [[Late Fees / Finance Charges]]''' for more information
+
Enter the finance charge
 
|- style="mso-yfti-irow: 4"
 
|- style="mso-yfti-irow: 4"
 
| style="width: 126.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="169" valign="top" |
 
| style="width: 126.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="169" valign="top" |
Line 173: Line 138:
 
|- style="mso-yfti-irow: 12"
 
|- style="mso-yfti-irow: 12"
 
| style="width: 126.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="169" valign="top" |
 
| style="width: 126.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="169" valign="top" |
'''Add Customer Message on Past Due'''
+
'''Warn on Past Due'''
 
| style="width: 531.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="709" valign="top" |
 
| style="width: 531.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="709" valign="top" |
 
The following message will populate the message field on Details and Settings tab: “Account is past due”
 
The following message will populate the message field on Details and Settings tab: “Account is past due”
Line 180: Line 145:
 
'''Class'''
 
'''Class'''
 
| style="width: 531.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="709" valign="top" |
 
| style="width: 531.9pt; border: none; border-bottom: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-alt: solid black .5pt; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="709" valign="top" |
If you are syncing SME with QuickBooks, this drop down should match your Class list in QuickBooks.
+
If you are syncing SME with QuickBooks, this drop down should match your Class list is QuickBooks.
 
|- style="mso-yfti-irow: 14; mso-yfti-lastrow: yes"
 
|- style="mso-yfti-irow: 14; mso-yfti-lastrow: yes"
 
| style="width: 126.9pt; border: none; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="169" valign="top" |
 
| style="width: 126.9pt; border: none; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt" width="169" valign="top" |
Line 188: Line 153:
 
|}
 
|}
  
<br>At the bottom of the Account tab, you will see balance information. If you don't see this, then it was hidden based on your User Group settings.
 
<br>[[File:AccountCurrent.png]]
 
  
<br>'''Net 30''', '''Net 60''', '''Net 90''' - These field shows balances that are 30, 60 or 90 days past the due date
 
<br>The due date for account calculations can be based on the Invoice Due Date or on the Invoice Date. This is determined by your setting in '''Setup''' > '''Company''' > '''System'''. The setting is '''Base Past Due on Invoice Date, not Due Date'''.
 
<br>'''Deposit on Account''' - This shows the total deposits entered for a customer in SME. SME Deposits stay in SME and do not sync to QuickBooks.
 
  
 
== Rates Tab ==
 
== Rates Tab ==
Line 225: Line 185:
 
Select the appropriate tax group for the customer. Your SME Administrator will set these up based on your needs.
 
Select the appropriate tax group for the customer. Your SME Administrator will set these up based on your needs.
 
|-
 
|-
| style="width: 1.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt" width="139" valign="top" |
 
'''Tax Exempt'''
 
| style="width: 7.7in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt" width="739" valign="top" |
 
Check for your tax exempt customers.
 
|-
 
 
 
| style="width: 1.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt" width="139" valign="top" |
 
| style="width: 1.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt" width="139" valign="top" |
 
'''Excise Tax Rate'''
 
'''Excise Tax Rate'''
Line 310: Line 264:
  
 
The Customer Lists tab provides access to more tabs. Here you can access all contacts related to the customer and a list of the customer equipment.
 
The Customer Lists tab provides access to more tabs. Here you can access all contacts related to the customer and a list of the customer equipment.
<br> If you aren't seeing all these tabs under Customer Lists, check your User group settings on the Tab Settings tab. (http://high5software.com/mediawiki/index.php?title=User_Groups#Tab_Settings_Tab)
 
  
 
[[File:CustomerListsTAb.jpg]]
 
[[File:CustomerListsTAb.jpg]]
Line 340: Line 293:
  
 
'''Web Access Password''' - If you are using WebConnect with SME, this is where you would assign the contact a login to WebConnect.
 
'''Web Access Password''' - If you are using WebConnect with SME, this is where you would assign the contact a login to WebConnect.
 +
  
 
== Customer History Tab ==
 
== Customer History Tab ==
In the Customer Activity tab, you can access all order history, invoice history, payment history and more. Depending on the permissions set by your SME Administrator, you may not see all the tabs shown in the screenshot below. (Hiding and showing tabs in User Groups: http://high5software.com/mediawiki/index.php?title=User_Groups#Tab_Settings_Tab)
+
In the Customer Activity tab, you can access all order history, invoice history, payment history and more. Depending on the permissions set by your SME Administrator, you may not see all the tabs shown in the screenshot below.
 
[[File:CustomerHIstoryTab.png]]<br>
 
[[File:CustomerHIstoryTab.png]]<br>
 
<span style="color: rgb(227, 108, 10);">'''Service'''</span>
 
<span style="color: rgb(227, 108, 10);">'''Service'''</span>
Line 419: Line 373:
 
<br>[[File:DepositApply.jpg]]
 
<br>[[File:DepositApply.jpg]]
  
 +
<span style="color: rgb(227, 108, 10);">'''Prepaid Hours'''</span>
 +
 +
Enter any hours here pre-paid by your customer
 +
 +
#  '''Date''' and '''Taken By''' will be auto-populated. Change as necessary.
 +
# '''Quantity''' – hours of labor pre-paid for
 +
# '''Rate'''- hourly rate
 +
# '''Total''' – this field calculates the total amount paid.
 +
 +
If a customer has prepaid hours available, when adding labor to a work order, the prepaid balance will display (circled in the image below).  Fill out the Labor Editor as you normally would, but make sure you update the hours used in the circled field. This will reduce the prepaid hours balance.
 +
[[File:PrepaidHours.jpg]]
 +
 +
<span style="color: rgb(227, 108, 10);">'''Prepaid Services'''
 +
 +
You can add Prepaid Services and view all purchased or used prepaid services in this tab.
 +
 +
# '''Date''' and '''Taken By''' will be auto-populated. Change as necessary.
 +
# '''Quantity''' – hours of service
 +
# '''Rate'''- hourly rate
 +
# '''Total''' – this field calculates the total amount paid.
 +
 +
Next time you add a service to an order for this company, there will be an additional field (circled below) showing Prepaid Items in the '''Service Item Editor'''.
 +
<br>[[File:PrepaidItems.jpg]]
  
 
<span style="color: rgb(227, 108, 10);">'''Item Repair'''
 
<span style="color: rgb(227, 108, 10);">'''Item Repair'''
Line 424: Line 401:
 
If a work order was created for the customer to repair some of their equipment, this tab will list the equipment to repair. Double click on the item and you can see what which equipment, the repair requested and repair performed.
 
If a work order was created for the customer to repair some of their equipment, this tab will list the equipment to repair. Double click on the item and you can see what which equipment, the repair requested and repair performed.
  
<h3>Adding Columns to the tabs</h3>
 
If you want to add additional columns to the grids on the tabs under Customer History, you can right click in the grid on the tab and select '''Add Columns to Grid'''. In the window that opens, check the fields you want to view and click OK.
 
 
<br>[[File:AddColumnsToCustomerHistoryTabGrids.png]]
 
 
<br>To go back to the original columns, right click in the grid and select '''Reset Grid'''.
 
<br>If you select '''Clear Grid''' from the menu, all the columns will be hidden. You can click in the upper left corner of the grid to choose which individual columns to add back in (image below)
 
<br>[[File:AddColumnsBackIn.png]]
 
  
 
== Associated Companies Tab ==
 
== Associated Companies Tab ==
Line 459: Line 428:
  
 
<p class="MsoListParagraphCxSpLast" style="margin-left: 0.25in; text-indent: -0.25in;"><b style=""><span style="font-size: 11pt; line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(227, 108, 10);">**NOTE**</span></b><span style="font-size: 11pt; line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;;"> if you don’t see the Notifications tab, then it was hidden from your view based on your user group permissions.</span></p>
 
<p class="MsoListParagraphCxSpLast" style="margin-left: 0.25in; text-indent: -0.25in;"><b style=""><span style="font-size: 11pt; line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(227, 108, 10);">**NOTE**</span></b><span style="font-size: 11pt; line-height: 115%; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;;"> if you don’t see the Notifications tab, then it was hidden from your view based on your user group permissions.</span></p>
 
 
== Move existing site to new billing company ==
 
 
If you are syncing SME with QuickBooks, see this video to move customers as job sites under another Billable or Parent customer.  This would be done in the case that job sites are first imported into QuickBooks and then you need to move them as job sites. '''Do not move customers that have a history of invoices and payments.'''
 
<br>
 
 
{{#ev:youtube| ah7Nn6jUFlw }}
 
<br>
 
<br>If you cannot move the site to a new billing customer in QuickBooks because of invoice and payment history, then you will need to create a new customer site and link it to the new billing/parent customer.
 
<br>
 
<br>How to manage current orders/info and move to the new management company.
 
<br>
 
<br>Company Names:
 
<br>Old Billing / Management Company = D
 
<br>New Billing / Management company = E
 
<br>Old Site/Job/Customer =  ABC (Change to ABC – D during the steps below)
 
<br>New Site/Job/Customer = ABC – E
 
<br>
 
<br>Actions:
 
<br>-          In QB
 
<br>o  Locate the ‘Site/Job/Customer’ under the current Management Company – ‘D’ parent
 
<br>o  Add a suffix to the name – ABC Site – D (makes this Site/Job/Customer unique)
 
<br>o  Sync – this will set the name in SME to ABC – D
 
<br>-          Create a new Customer in SME or QB called ‘ABC – E’ for the location – If in SME set the Billing to the ‘E’ parent
 
<br>
 
<br>o  Locate existing Recurring Orders or Invoices
 
<br>o  Click the Magnify glass next to the Site Name and browse for the new Site/Customer record.
 
<br>
 
<br>o  You can also move the customer equipment from ABC – D to ABC – E from the Customer Equipment module. (right click on the equipment and select "Move to another site)
 
 
 
 
== Merge Customers ==
 
You can merge customer history from one customer into another customer in SME. Once the history is moved, the customer record you moved history ''from'' can be set to inactive.
 
[[File:StartingcusotmerMerge.png]]
 
 
<br>- Go to the customer you want to merge into another customer, click '''Actions''' > '''Merge with'''. (This is the customer you want to get rid of and merge history into another customer, in the image above it is Willows School.)
 
<br>[[File:Customer_Actions_MergeWith.png]]
 
 
<br>- In the search window that opens, select the customer you want to move the history to
 
<br>[[File:SelectCustomerToMergeInto.png]]
 
 
<br>- Your window will stay on the original customer. Check out the history tab and the service & install history should be empty. Set the Customer to inactive by clicking '''Actions''' > '''Set to Inactive''' and make sure '''Export to QuickBooks''' is unchecked. You could also delete the customer.
 
<br>[[File:CustomerMerge_HistoryMovedAway.png]]
 
 
<br>- Go to the other customer you merged history into
 
<br>- Look at the history tab and you should see the orders from the other customer.
 
 
<br>[[File:MergedHistory.png]]
 
 
<br>- If you want to update the name and address on the moved service orders that are still '''open''', you can click''' propagate to orders''' from the site and billing tab on the customer you moved history to.
 
<br>[[File:PropagateAddressToMergedHistory.png]]
 
 
 
 
 
 
=== If Merging Quickbooks Customer ===
 
 
''' When merging customers we recommend you do as follows: '''
 
*Merge the customer in QB – This will move all of the info to the merge customer and will set the merged customer in SME to Inactive. All historical records will remain tied to the inactive customer.
 
*Sync – this will record the QB action and will set the merged customer in SME to Inactive.
 
*Merge the customer in SME – This will move all of the historical info to the merge customer and will leave the merged customer as inactive. (You can delete the customer once it has been merged). Note: The only change to historical data in SME is the Billing/Parent UID is replaced on the merged records. All address info, etc. remains as originally entered.
 

Please note that all contributions to High5Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see High5Wiki:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)