I have a bad credit card transaction in my EDC batch. It is preventing me from settling the Batch. I can not delete ithis since it was a returned item that was done by Recalling a transaction for return. Do you have a Query that I can use to delete this with the 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
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.