I have a request from a client to delete all “Canceled” Service Contracts
I tried adding a delete button to the Service Contracts GI.
This resulted with: Error: The record cannot be deleted.
Different approach: I tested using a SQL DELETE in my local Acumatica instance database.to bulk delete all existing Service Contracts that have a status of “Canceled”
DELETE FROM [FSServiceContract] WHERE Status = 'X'
This appears to have deleted all the Service Contracts that have a Status of “Canceled”, which is what the customer wants.
Note: This SQL approach does bypass business rules in this module.
Question: Is there a better (preferred) approach to deleting Service Contracts that have a Status of “Canceled”?
My customer requests:
- Bulk delete all of the Service Contracts that have a status of “Canceled”.
- Give them the ability to delete Service Contracts that have a status of “Canceled” on their own.
Thank you in advance.
Ken Severud