We have a closed work order with a Deposit amount that was not refunded (due to MS RMS "account tender" problem). I would really appreciate an SQL statement that would reopen the work order (unless MS RMS provided a way to do this action) So that we can refund the deposit.
Our (work order number is 236) (customer account number 000456)
DDowningMO
DD,
UPDATE [Order] SET Closed = 0 WHERE Id = 236
Backup first!!
you may want to try this:
Update [Order] Set Closed = 0 Where Type = 2 AND Deposit > 0 AND Closed = 1
DD,
Understand my query will _only_ do the 236 workorder while Afshin's will do _all_ workorders (Type = 2) that are closed (Closed = 1) and have a deposit. If you wish to do all BackOrders, change the type to 3 or 5 for Layaways
Again, backup first!!
Afshin Alikhani
Thank you for the SQL statement I will try that after we close & Backup sunday
I think MS RMS should have a SQL help file (or a book) that would help in these situations.
DDowningMO
I don't know how your reply was posted to unknown but I found it anyway. Will try the SQL statement after Sunday close and backup
Thank You DDowningMO
Have something to add? Share your thoughts — no account required.
Ask the community — no account required