Cannot Get Quotation for Each Sales Order
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
but then
1.when oha.context is Sales Quotation, means it has not yet been created into Sales Order.
2.when Sales Quotation created into Sales Order, it lost it's Quotation Date and Quotation number
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.
Anyone knows where the information stored? Thank you
I want to create a report to know the Sales Quotation for each Sales Order.
I select it from oe_order_headers_all
but then
1.when oha.context is Sales Quotation, means it has not yet been created into Sales Order.
2.when Sales Quotation created into Sales Order, it lost it's Quotation Date and Quotation number
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.
Anyone knows where the information stored? Thank you
0