Get Sales Quotation for Each Sales Order [message #401911] |
Wed, 06 May 2009 23:27 |
hans.mulyadi
Messages: 1 Registered: May 2009
|
Junior Member |
|
|
Dear All,
I want to create a report to know the Sales Quotation for each Sales Order.
I select it from oe_order_headers_all like this
select oha.header_id,oha.order_category_code,oha.order_number,
oha.context,oha.ORDERED_DATE,oha.QUOTE_DATE,
oha.QUOTE_NUMBER
from oe_order_headers_all oha
where oha.quote_number is not null
but the for my opinion the result is
1. when Sales Quotation created into Sales Order, it lost it's Quotation Date and Quotation number
2. when oha.context is Sales Quotation, means it has not yet been created into Sales Order.
I search in oe_order_lines history for the lines, but I still can't find the header information that was lost when Sales Quotation updated into Sales Order and oe_order_header_history is all null.
Please help, sorry for my bad english and thank you
Regards,
Hans
[Updated on: Wed, 06 May 2009 23:33] Report message to a moderator
|
|
|