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

 

Applicable Products:

Connected Business 13 and higher

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

No Bill To and Ship To are Generated During Customer Import

      Synopsis:  Successfully imported the list customers using the Import Manager but when...
Sales Tax Not Calculating for Customer That Uses Zip+4 Address

Synopsis: Creating sales order for a customer who uses a Zip+4 address does not calculate tax....
Supported Credit Card Swiper for POS and CB Client

Supported Credit Card Swipers Connected Business POS (Web-Based Application), the supported card...
How To Create Customer Refund

Synopsis: In an event that you give back the customer his payment for a disputed transaction...
Supported Credit Card Scanner Unencrypted In ERP Client – The MagShell®900 Magnetic Stripe Reader

For the unencrypted ERP credit card swipe feature, we only support the MagShell®900 Magnetic...