Query for deleting a transaction

I'm not famililar with the table and column names in the RMS db, but here is a basic delete command that you can use if you figure out the field names and table that stores the orders.

delete from tablename where columnname ='ordernumber'

be extremely careful with this, and make sure that you use the where clause or you will delete the entire table.

"RyanB" wrote:

What I like to do for traceability is the following...

After hours (after Z out), set the clock back on the server and register to the date the transaction occured. Do a return for the transaction. Z-out. Reset the clocks to the correct setting.

This will create a transaction and batch on the correct date and will be correctly reflected on sumamry reports.

I haven't run into any problems doing this, but maybe others have info that this could cause issues... not sure.

Comments?

Jason