Is there anyway to delete Layaway transactions without having to use the Delete all sales transaction option in SO Administrator?
I need to reimport layaways from an old POS and need the ones in the current RMS removed.
Thanks for any suggestions.
Layaway question
Jun 07, 2006
1 Replies
Thomas,
Backup first !!
The sample database has 10 order type transactions in it, that's where the "10" comes from. Adjust per your needs.
From "How to delete the Sample Data";
TO DELETE SAMPLE ORDERS (Work Orders, Layaways, Quotes, Back Orders)
- Run the following SQL statements in Administrator:
a. Click Query and then click New to bring up the New Query window.
b. Verify the sample orders displayed in this statement are not actual orders from your store. Type or Copy and Paste the statement below and press the F5 key to execute the query:
SELECT ID, Time, LastUpdated FROM [Order] WHERE ID
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required