cancel
Showing results for 
Search instead for 
Did you mean: 

How to list Open Orders by date in the past?

Former Member
0 Kudos

Hi,

I need to list open sales orders that were open on a date in the past

Let's say which sales orders were open on April 30 2015?  (These may not be open now in July 2015)

VA05 shows open now and not on a date in the past

Is there a way to do this?

Can this be done in SQVI  VBAK - VBUK join?

Would appreciate it much if someone can offer a solution


Thanks,

SM

Accepted Solutions (0)

Answers (4)

Answers (4)

ravi_kumar100
Active Contributor
0 Kudos

Hi,

If your Sales Orders have multiple deliveries ,you can refer them by executing the VL_COMPLETE transaction.

It will provide you the complete list of open Delivery documents with their Current status .

With that you can track the Open Sales Orders for Multiple Deliveries by cross checking the same.

Regards,

SRK

0 Kudos

Hi SM,

VBAK-VBUK join would not help in this case. I think you will have to write a report based on CDHDR/CDPOS tracking the date on which the completion status changed. Its going to be very slow though.

RahulHanda
Active Contributor
0 Kudos

Hi,

You can use VA05n and V.15    

Regards

Rahul

former_member184771
Contributor
0 Kudos

Dear SM,

Try VA05N, this report come with lot of filter criteria including Document Date and status of open sales order.

Explore it, this will full fill your requirement.

Thanks.

SS