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

Esta resposta lhe foi útil? 0 Usuários acharam útil (0 Votos)

Os Mais Populares

Set a Default Printer for Shipping Label Printing

1. Go to Shipping > Setup > Carrier Plugin > Select your Carrier e.g. Select the...
Set Up Shipping Methods for Real-Time Shipping

SynopsisReal-Time Shipping is the charging of actual shipping cost from the shipping carrier to...
Void-Do Not Mail Shows in the Print Out after Generating Shipment Label

Synopsis:  When tried to print a successful USPS Shipment Label, "Void-Do Not Mail" shows in the...
FAQ: How to Allow Manually Created Sales Order to Show in the Website

  One of the features included in the Sales Order form is the Webstore Code. It allows you to...
FAQ: How to Allocate a Credit Memo to Posted Sales Invoice

Synopsis: How to allocate a Credit Memo to a posted Sales Invoice Procedure Go to Customer...