Updating Customer Status via direct database update

Question

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

RDTupas · Accepted 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.

Sage 500

Updating Customer Status via direct database update

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING