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's 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".


Applicable Products:

Connected Business 13 and higher

這篇文章有幫助嗎? 0 Users Found This Useful (0 Votes)