Closing / Cancell Date of Row Item in Sales Order

[Former Member]

Dear All

We have to generate one report for one of our customer, which requires to know the 'Cancell / Closing Date' at row level of Sales Order. We could not found it in 'RDR1' table. 'Cancell / Closing Date' only available in header table i.e. in ORDR table. But if any row is closed or cancelled then that is not reflected in header table. So please let us know how to know the 'Cancell / Close Date' in row level in SO.

Thanks & with regards

Aloke Bandyopadhyay

[Former Member]

Dear Aloke,

You may check ADO1 table for historical record to find it.

Something like:

SELECT T1.DocNum, T1.DocDate, T0.Linenum+1 'Line#', T0.Itemcode, T0.LineStatus, T0.DocDate 'Line Close Date'

FROM ADO1 T0

INNER JOIN ADOC T1 ON T1.DocEntry=T0.DocEntry AND T1.ObjType='17'

WHERE T1.DocNum LIKE '[%0\]%' AND T0.LineStatus = 'C'

Thanks,

Gordon

[Former Member]

HI

I don't think that you will have standard field for that date in RDR1 table....So you create a user defined field of type "Date/Time"

After creating that UDF,Here you can mention the date at row level in the UDF and u can use it for report too...

Edited by: kambadasan on May 20, 2011 2:11 PM