Contents tagged with Change all emails

  • How to change all emails in Acumatica

    Hello everybody,

    today I want to leave a post on how to change all emails, which are contained in Acumatica. For this purpose you may use script below:

    UPDATE contact SET    email = email + '.ts' UPDATE socontact SET    email = email + '.ts' UPDATE apcontact SET    email = email + '.ts' UPDATE pocontact SET    email = email + '.ts' UPDATE crcontact SET    email = email + '.ts' UPDATE arcontact SET    email = email + '.ts' UPDATE fscontact SET    email = email + '.ts' UPDATE crcasecontacts SET    email = email + '.ts' UPDATE crcontact SET    email = email + '.ts' UPDATE pmcontact SET    email = email + '.ts' 

    If you wonder, what can be the usage of such SQL, consider following … more