Need SQL Statement to Re-open Closed Workorder w/ deposit

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

Reply to
DDowningMO
Loading thread data ...

DD,

UPDATE [Order] SET Closed = 0 WHERE Id = 236

Backup first!!

Reply to
Jeff

you may want to try this:

Update [Order] Set Closed = 0 Where Type = 2 AND Deposit > 0 AND Closed = 1

Reply to
Afshin Alikhani

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!!

Reply to
Jeff

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

Reply to
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

Reply to
DDowningMO

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.