How to void a check in the Database.
Before doing the void, make sure you have the Check ID and the reason the customer is voiding the check
Here’s how you can update the payment status in the database:
-
Log in to the customer’s server and open the database.
-
Expand Clubspeed v8 > Tables, then locate dbo.Payment.
-
Right-click dbo.Payment and select “Edit Top 200/2000 Rows.”
-
Search for the check number you need to update.
-
Once you find the record, update the PaymentStatus value:
-
0 = Unpaid
-
1 = Paid
-
2 = Voided
-
After making the change, have the customer verify the status on their side.
If the update doesn’t reflect correctly, try hopping on a call so you can adjust the value together and confirm in real time.