You’re offline. This is a read only version of the page.
65
Is there a easy way to remove old QUOTES from RMS?
PS. GAS
*This post is locked for comments
Try this, change the Daybefore to 30 days or more old
BACKUP FIRST!!!
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
BACKUP FIRST!!
Not in mass quantities.
You have to recall the quote. Then remove all the items from the quote. Then hit Tender and choose to save the quote. This when then delete the quote because it doesn't contain any items.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (