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!!
SQL for deleting specific transaction
Jun 18, 2008
2 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required