Sales Open Order Report : Performance Issue

[vikas_sehra2]

Dear All,

We have a requirement from the customer to create a report with below input parameters -

1. All sales Order should be fetched with delivery date in schedule line before than certain date provided in the Input. (example - if user inputs say 01/02/2017, than all the sales order should be displayed which have delivery date before 01/02/2017.

2. Sales Order for which both delivery order and Goods issue has been posted should be excluded.

This causes a huge performance issue as first we have to fetch all previous years sales order which as per the delivery date from VBEP table and after that we compare from LIPS table for Goods Movement indicator and exclude the Sales Orders.

Please suggest any better way to manage the requirement so that performance can be enhanced for the Report.

like we tried to find any status for goods issue in sales order so that we can exclude the sales order in the first query but could not find any, than we tried to find some standard view for sales order and delivery table so that we can check the status initially. But we could not find any better option.

Looking forward for some better solution

Thanks

VikasSehra

[Lakshmipathi]

Have you not explored the standard report VA05?

[vikas_sehra2]

Hello,

Thanks for the revert.

Checked the Report - VA05, open sales order logic is totally different.

VA05 checks document date at header where as we need to check Schedule line delivery date.

VA05 considers line item as closed when delivery is created where as our requirement is that sals order line item is closed when both delivery and goods issue are posted.

Please consider the points and suggest if there is any alternate and better solution to improve the report performance.

Regards

Vikas