Delayed Orders

[former_member206475]

Dear Experts,

I wanted to know list all the orders which have been delayed. We have a Requested delivery date at order level and Avtual goods invoice date.

What is understand is Requested delivery date is the planned delivery date entered when order is created. And actual goods issue date is the Invoice date?

Now we need to have data which shows orders which are delayed. I am not sure on what basis we can find this info. In BW report i see situations were Requested delivery date is less than Actual goods issue date and situations where Requested delivery date is greater than actual goods issue date.

So i am not able to understand exactly when an order is delayed and how to come to a conclusion to find delayed orders.

I also want to see what was the reason for the order to be delayed.

The reason to ask this is because the report shows Billing doc date( gets populated from requested delivery date or goods issue date ). So for user when executes report the user might see an order with Billing doc date of 30.07.2016 if thats the case. And the user assumes that this order will be invoiced then.

However when the user executes the report next month, the user might see the same order appearing in report with billing doc date of 30.07.2016 but actual goods issue date of 15.08.2016. Or may be the billing doc date and actual goods issue date would be 15.08.2016.

Not able to understand this work flow.

Please assist.

Regards

Zabi

[Lakshmipathi]

System will always consider Actual GI date as billing date and this would differ if the user change manually in billing document.  Of course, with the standard configuration, it is also possible to populate system date as billing date irrespective of Actual GI Date.

Now coming to your requirement

I also want to see what was the reason for the order to be delayed.

it is not possible since you are not maintaining any item text in sale order, if my assumption is correct.  Practically, this is also not feasible to follow.  You need to have such data in excel if at all it is required at any cost.

G. Lakshmipathi

[former_member206475]

Hi Lakshmi,

Thank you for the reply.

I wanted to understand the below situations:( We have three main date fields - Requested delivery date, Goods issue date and Actual goods issue date

1. We have a field called billing doc date which shows in open order report. This field gets populated from Requested deivery date or calday or goods issue date on logic.When user executes the report for example today he might the order in report with billing doc date  of 30.7.2016(expecting this order will complete on 30.6.2016). And when user executes same report next month for period 07.2016 he sees same order with different bill doc date for example 15.07.2016 and still open. This is creating confusion for user in analysis on period basis. So wanted to understand if this is normal situation and when this changes in date happens?

2. Now to understand more i created a report with all types of orders. In this report i included Bill doc date, goods issue date and actual goods issue date. When i execute i see for completely processed orders the bill doc date is different than actual goods issue date. Not abe to understand why this still happens. Sometimes bill doc date < Actual goods issue date and vice versa.

I thought these dates should be same for completely processed orders?

Please advise.

From my understanding actual goods issue date is invoice date! Not sure what the goods issue date means then.

Regads

Zabi