Start a conversation

How can I cancel an old quote on file?

Option A: Cancel a quote.

1. Recall the quote transaction (F11) in POS.
2. Change the quantity ordered to zero (if you want a record of the cancellation) or remove the line item(s) if no record is needed.
3. Press F12 Tender, Save Changes, then OK in the Tender window. 

Option B: Remove old quotes by cut-off date.  

1. Run Store Operations Administrator.
2. Select File, Connect.
3. Enter your database password and click OK.
4. Select Database, Backup and complete the backup.
WARNING: Always backup before running any scripts.
5. Select Query, New.
6. Cut and paste the following 3 scripts into a query window ONE AT A TIME and run them in following order.

DELETE FROM [Order] WHERE Type = 3 AND Closed = 0 AND ExpirationOrDueDate < '2/12/2008'

DELETE FROM OrderEntry WHERE OrderID NOT IN (SELECT ID FROM [Order])

DELETE FROM OrderHistory WHERE OrderID NOT IN (SELECT ID FROM [Order])

7. Change the date in script 1 to your cut-off date. Example: 90 days ago
8. Press F5 to run it. Wait for a confirmation to appear. Run script 2 and 3.
9. Exit Administrator and select Yes to save.
10. Call your three scripts "Delete Old Quotes 1, Delete Old Quotes2, and Delete Old Quotes3" or similar. You can then retrieve them in the future under File, Open.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Dave J

  2. Posted
  3. Updated

Comments