on 07-13-2015 2:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use VA05n and V.15
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.