Delete Old "test" transactions

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,

Reply to
Alex
Loading thread data ...

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,

Reply to
CptSoft

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.