Updating Customer Status via direct database update

Solved

Are there any issues with updating the status of customers via SQL update statement?  We have many customers we wish to deactivate.

  • +1
    verified answer

    Hi Steve,

    It's not advisable to make changes from the back-end as the customers you are deactivating may have existing or pending transactions. We suggest performing this task in the front-end as the Sage 500 client will warn you if a customer has open transactions and will advise you not to deactivate it. Using the back-end you won't have any validation and if a customer has transactions and was forcibly deactivated it may cause some issues with your data.

    If you need to further discuss you can open a case via your Sage 500 customer portal and an Analyst will be able to assist you.

    Thank you.