Delete Old "test" transactions

Jan 29, 2007 1 Replies

Can somebody supply me with the SQL statements to delete any and all sales related transaction prior to a certan date, but NOT any P.O. that we currenly have?



I know you can use the "Delete All Transactions" option , but that also deletes all the P.O.s



We have been using RMS for the back-office functionality (mostly P.O.s) but just started using it for front of store POS operations and would like to start "clean".



Thank you,


Can somebody supply me with the SQL statements to delete any and all sales related transaction prior to a certan date, but NOT any P.O. that we currenly have?

I know you can use the "Delete All Transactions" option , but that also deletes all the P.O.s

We have been using RMS for the back-office functionality (mostly P.O.s) but just started using it for front of store POS operations and would like to start "clean".

Thank you,

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required