|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
| 10.3. Merge Accounts | ||
|---|---|---|
 | 10. Utilities |  |
If you are importing customer or vendor or any other account information—either through the xTuple Web Portal or some other feature—it's possible you will encounter duplicate account records. It's also possible to create overlapping or duplicate account records manually by mistake. The Merge Accounts utility is a wizard designed to help you resolve this scenario. Using the Merge Accounts utility, you can easily locate duplicate records and merge them into one single account record.
For practical information about how the Merge Accounts utility can be used during an upgrade process, please see the following article posted on our community website here: http://www.xtuple.org/node/4479.
To begin using the Merge Accounts utility, go to . The following screen will appear:
Upon first opening the Merge Accounts utility, you are presented with the following options:
Select to begin a new merge process.
Select to continue working on a merge that you have already started by not yet completed. Because you may have multiple merges in process at the same time, be sure to select the correct merge from the drop-down list.
After specifying a task to perform, select the button to reach the next step. The following screenshot shows the second step for creating a new merge:
When starting a new merge, you need to identify the accounts you want to merge. You are presented with the following options:
Select a filter from the list of available filters, then select the button to generate search results. Only saved filters will appear in this list.
Select this button to show the parameters underlying the saved filter. To hide the parameters, click the button a second time.
When building a custom query, you have the following options:
Select to add a new parameter to the query.
Select to remove a parameter from the query. This option is disabled for default parameters.
Select to save your filter for future use. Saved filters will appear in the list of available filters.
Select to manage your saved filters. To learn more about managing filters, please see Section 2.1.2, “Search Filters”.
Select to refresh the account data after filters have been changed.
Displays the list of accounts found in your system. By using your mouse, you can click on accounts to specify which ones you want to merge. The accounts you select will appear in the Destination Account drop-down list.
After the accounts have been selected, specify which of the accounts is the target or destination account. Information from the other selected account(s) will be merged into the destination account.
Once you've selected accounts to merge, select the button to reach the next step. The following screenshot shows the next step once you've identified accounts to merge:
The next step is to pick which details you want to add to the target account from the source account(s). When merging specific data elements, you are presented with the following options:
Displays the accounts you want to merge. Any information displayed in blue will be added to the target account. Only the target account will be remaining after the merge. You can right-click on the account rows to view or edit the account information. Since the final result can only contain one piece of information per column, only one item in each column can be selected and blue.
Select to save the details you want to merge. At this stage, the merge is still in process. You may revisit the merge details and make changes later.
Once you click the button, the Perform This Merge? warning will pop up asking if you're sure you want to perform the merge. Clicking will run the merge and all selected accounts will be merged into the target account.
Double-check your accounts before you merge, because this action cannot be undone.
Once you select the button, you will be shown a preview of your merge results, as shown below:
The Result of Merge screen shows a summary of the current target account and what elements were added from the source account(s). The source account(s) are now purged and are no longer in the database.
| |  | |
| 10.2. Create Recurring Items |  | 10.4. Merge Contacts |