This utility changes an existing customer number at the local site to match a different customer number that exists (for the same customer) in another database site, when the sites share customer data through replication. The new customer number must not already exist in the local site.
NOTE: This utility updates the customer number everywhere it exists in the system.
Suppose Sites A and B share customer data through replication. Site A contains Cust1, and Site B contains Cust2; but Cust1 and Cust2 are actually the same customer, with different numbers in the different sites. Since the number should match in both sites, you can change Cust1 to Cust2 in Site A. Using this utility, select Cust1 in the Current Customer list. Select Cust2 (of Site B) in the New Customer list. This moves the existing local customer record to a new local customer record. After processing, all records related to Cust1, such as customer orders, invoices, accounts receivable, and jobs are updated to specify Cust2 instead.
To move a record, the following conditions must be met:
The current customer's Bill To cannot be changed to the new customer's Ship To.
Example 1. The current customer has only sequence 0 (Bill To) and no Ship Tos. The new customer has sequence 0. In this case, the current customer is replaced by the new customer.
Example 2. The current customer has sequence 0 and sequences greater than 0 (Ship Tos). The new customer has sequence 0. In this case, the new customer is inserted in the database, but the current customer remains, as there are Ship Tos present for the current customer.
Example 3. The current customer has sequence 3. The new customer has sequence 5. The new customer sequence 0 must exist in the current site before the move is performed and all information for the new customer sequence 0 remains unchanged in the current site after the move. Sequence 5 for the new customer gets added to the current customer site. Sequence 3 for the current customer is removed from the current customer site. The Bill To area of the Customers form for the new customer is the same as it was before the move. The Ship To information such as that on the Codes tab on the Ship To form for the new customer sequence is copied from Site B.
NOTE: The posted balance and order balance of the customers involved in the move are not updated by this utility. You must run the Rebalance Customer Balances Utility to rebalance these values for all affected customers.