Skip to Content
0
Former Member
Jul 29, 2010 at 04:26 PM

sales order created date for Quotation

99 Views

Hi Experts,

Need your advice,

I need to create report, my requirement is below,

Quatations, Quatation created date, First sales order created date.

so for this, I've created new Infoobject ZSODATE, ZREFDOCNUMBER which will bring date for sales orders

logic used :

Doc Type : ZPRO (sales orders) and ZPRQ (quatations)

so ZREFDOCNUMBER will have all document number of DOC TYPE = ZPRQ & ZPRO

For Eg.

Quatation = 200001 created on 20/07/2010.

sales order created under quatation 20001 is 53 on 22/07/2010.

Now I need a report like this

Quatation = 200001

Created on = 20/07/2010

First Sales order created = 22/07/2010.

but my out put is

Quatation Created date First sales order created

200001 22/07/2010 22/07/2010

  1. 20/07/2010 x

Note I've created formula variables for created date and first sales order created.

Thanks in Advance

Regards,

Raghav