Skip to Content
Former Member
Aug 02, 2013 at 07:52 AM

Query to get the 'Date' when the Sales order DocStatus become 'Close'


Hi experts,

I am trying to find out when the sales Order is closed. ie., the Date when the Sales Order Docstatus become 'Close'.

I have checked with the ADOC table, but I cant find out.I can see 'UpdateDate' field, its not showing the updated date.


Shall I consider the Document Date of Delivery/Invoice documents as Closing Date for the Sales Order.If it is preferrable, then in case, if user manually close the sales order, how to get that date.

Any help is appreciated.

Thanks in Advance.

Parvatha Solai.N