SQL for deleting specific transaction

I have test transactions I need to delete mixed in with real transactions and would like to delete them based on TransactionNumber however TransactionNumber is not a column is some related tables. Please help!!

Reply to
Nate
Loading thread data ...

If you want to delete a transaction.. you must delete data in [Transaction], [TransactionEntry], [TenderEntry] and you have to update item, customer, dailysales, batch and journals.....

cod

Reply to
cod

Reply to
convoluted

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.