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

Was dit antwoord nuttig? 0 gebruikers vonden dit artikel nuttig (0 Stemmen)