HI all,
Is there such fields call 'BaseDocDate'? I was trying to query out the 'Sales Order' date that was created with regards in relation to OINV table. Meaning to say, if an order is made on 1.04.09 & invoice is done on 05.04.09, how can i know that this invoice dated (05.04.09), is created from a Sales Order created on the 01.04.09??
Appreciate SQL experts urgently.
THanks.
Harith