web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Delete serial numbers ...

Microsoft Dynamics RMS (Archived)

Delete serial numbers from quotes

(0) Share

Report

Report

Posted on by Community Member

RMS 2.0.1002 I'm looking for a query to delete serial numbers off of all quotes.

Thanks,

Ben

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

*bump* Still looking for a query to delete serial numbers off of quotes. Also is there a way to keep quotes from storing serial numbers when a sale is changed to a quote?

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report
Copy link

Link copied!

You need to delete the quote, http://tinyurl.com/c92vfz8 Must have acccess to CustomerSource

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I'm looking for a way to remove the serial numbers from the quotes without deleting the quotes.

Was this reply helpful? Yes No
ToddB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good morning Benv,

It appears the reference to the serial number in the OrderEntry table is the DetailID.

Select DetailID from OrderEntry where OrderID = x

Please let me know if this answers your question.

Todd

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ok, so what query would delete the DetailID from all Quotes in the OrderEntry table?

Thanks,

Ben

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans