Layaway question

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.

Reply to
Thomas Kwok IUG
Loading thread data ...

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)

  1. 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

Reply to
Jeff

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.