Quotes - Deleting

Kenny -

We delete quotes all the time as the Ex date set in SO config really does not remove 'old' quotes.

To delete a quote: Recall the quote>

Delete all line items from the quote>

F12: Tender>

Save Changes>

OK

Quote is now gone as there is nothing left to save (i.e. all line items have been removed).

YOu can use this query ifyou want and changethe date 30 to whatever yo want. Test this in a demo system and make sure you have backups of your actual database before you run any sql scripts.

- - - - - - - SET NOCOUNT ON

Declare @DayBefore Int Set @DayBefore = 30

Begin Transaction

Update [OrderEntry] Set QuantityOnOrder = 0 Where OrderID In (Select ID From [Order] Where Type = 3 And Closed = 0 And Datediff(Day,[Time],Getdate()) > @DayBefore)

Update [Order] Set Closed = 1 Where ID In (Select ID From [Order] Where Type = 3 And Closed = 0 And Datediff(Day,[Time],Getdate()) > @DayBefore)

Commit Transaction

SET NOCOUNT OFF

- - - - - - - - I hope this is useful.