How To Convert All Existing Customers to Commercial
1. You may go to the SQL Management Studio and select the desired database.
2. Back up the database
3. Execute the script below
UPDATE CustomerShipTo SET AddressType='Commercial'WHERE AddressType='Residential' or AddressType is null
4. Run the application and check the Customer updated Address Type.
NOTE: We have tested this feature. Make sure to understand the information correctly because it will affect all existing customers by changing the Address Type of the customer to "Commercial".
Connected Business 13 and higher