Quote to Sales Order

Yahoo Archive
1
OrderDtl.QuoteNum

OrderDtl.QuoteLine



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tom J. Christie
Sent: Friday, November 30, 2012 9:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Quote to Sales Order





Anyone know how to join Quote to the sales order that was generated from the
quote, or vice versa. I would expect there to be some link between the table
structure. Any guesses or ideas?

This is 9.05.606 SQL

Thanks,

Tom Christie
Manufacturing Engineer

AGM Container Controls
3526 E Ft. Lowell Road
Tucson, AZ 85716

PH: 520-881-2130
EM: Tchristie@... <mailto:Tchristie%40agmcontainer.com>

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2634/5428 - Release Date: 11/30/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2634/5428 - Release Date: 11/30/12

[Non-text portions of this message have been removed]
2
Does anyone know how to write a report to see how many quotes actually
turned into Sales Orders?

What tables would I use?

TIA!



M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@...
P: 630-806-2000
F: 630-806-2001



[Non-text portions of this message have been removed]
3
Nevermind, I found it...it was the orderdtl table I didn't look in....









M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, October 29, 2007 1:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quote to Sales Order



Does anyone know how to write a report to see how many quotes actually
turned into Sales Orders?

What tables would I use?

TIA!

M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Anyone know how to join Quote to the sales order that was generated from the quote, or vice versa. I would expect there to be some link between the table structure. Any guesses or ideas?

This is 9.05.606 SQL

Thanks,

Tom Christie
Manufacturing Engineer

AGM Container Controls
3526 E Ft. Lowell Road
Tucson, AZ 85716

PH: 520-881-2130
EM: Tchristie@...



[Non-text portions of this message have been removed]
5
Haha. Found it. The Sales Order Line stores the quote that generated it.
OrderDtl.QuoteNum and OrderDtl.QuoteLine

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tom J. Christie
Sent: Friday, November 30, 2012 7:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Quote to Sales Order



Anyone know how to join Quote to the sales order that was generated from the quote, or vice versa. I would expect there to be some link between the table structure. Any guesses or ideas?

This is 9.05.606 SQL

Thanks,

Tom Christie
Manufacturing Engineer

AGM Container Controls
3526 E Ft. Lowell Road
Tucson, AZ 85716

PH: 520-881-2130
EM: Tchristie@...<mailto:Tchristie%40agmcontainer.com>

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]