DavidG: Fixed video player

2021-02-03T18:46:43Z

Fixed video player

Moha: Created page with "If you see the following error in SQLink, there is a duplicate customer in SME. '''Customer : XYZ is skipped due to duplication''' You can follow the following steps to resolve..."

2011-06-07T18:30:57Z

Created page with "If you see the following error in SQLink, there is a duplicate customer in SME. '''Customer : XYZ is skipped due to duplication''' You can follow the following steps to resolve..."

New page

If you see the following error in SQLink, there is a duplicate customer in SME.

'''Customer : XYZ is skipped due to duplication'''

You can follow the following steps to resolve the error or watch the viceo below.

<videoflash>5EC0ZdD3I7I</videoflash>

<br>'''Find which customer record is the duplicate'''

# Go to '''Customers'''.
# Click '''Search''' >'''Search Active Customers'''.
# Click '''Views''' > '''New View'''.
# In the Grid Column Window, check the following fields: '''Name, BillName, Address 1, Address 2, City, St, CustID, ParentID, QBExport. Click OK.'''
# Arrange the columns the way you want in the search view window.
# Click '''Views''' > '''Save View'''.
# Type a name for the view and click '''OK'''.
# In the search view window, sort by '''Name'''.
# Locate the customer name SQLink said is a duplicate.
# Follow the row to the CustID column. If the column is empty, that is your duplicate customer record. Double click to open the duplicate.
# Click your cursor in the '''Company''' field to edit the customer name. Type ('''DUP''') after the customer name. This makes it unique and easy to identify when reassigning orders and invoices for the duplicate customer.
# Click '''Save'''.

'''Now that you found which customer is the duplicate record, check to see if there is any activity for customer you need to reassign
'''

# Click the '''Customer Activity''' tab.
# Click the '''Invoices''' tab.
# If there is an invoice on this tab, double click on it. SME will jump to the invoice.
# Click '''Actions''' > '''Rollback Invoice'''.
# Go back to the duplicate customer.
# Click the '''Customer Activity''' tab > '''Service''' tab to check to see if there is a service order assocaited with the "DUP" customer.
# If there is a serivce order, double click on it. SME will jump to the order.
# Click [[File:Magnify.jpg]] to search for the correct customer. In the search window, select the correct customer record, not the "(DUP)" record.
# Save the service order.
# Click '''Actions''' > '''Generate Invoice''' to re-invoice the order.
# Follow steps 1-9 for install orders and invoices for the install orders.

'''Now the activity associated with the duplicate customer are assigned to the correct customer, delete the duplicate customer'''

# Go to the '''"DUP"''' customer.
# Click '''Delete''' to delete the customer record.

← Older revision		Revision as of 18:46, 3 February 2021
Line 6:		Line 6:


−	~~<videoflash>~~5EC0ZdD3I7I~~</videoflash>~~	+	{{#ev:youtube\| 5EC0ZdD3I7I }}

SQLink Error - Duplicate Customer - Revision history

DavidG: Fixed video player

Moha: Created page with "If you see the following error in SQLink, there is a duplicate customer in SME. '''Customer : XYZ is skipped due to duplication''' You can follow the following steps to resolve..."