Suggest to use "Update" instead of "Delete" then "Insert" script on default letter format.

Issue No: AR-4068
Created 1/29/2017 10:44:08 PM
Type Suggestion
Priority Major
Status Closed
Resolution
Fixed Version 17.1
Description In 17.1, CRM is using the SM Letter in sending email to customer. CRM saves those letter in tblCRMCampaignCommunication with a foreign key to tblSMLetter. The "Delete" then "Insert" script on i21Database\Scripts\Post-Deployment\AR\DefaultData\23_AddDefaultCollectionLetters.sql will have an error on deployment if the letter is being used in CRM or in other module.