Delivery not created although schedule line confirmed

[Former Member]

Hi Gurus,

  The deliveries are created through batch jobs in this situation and a sales order of 300 quantity with delivery date in the past shows

that the sales order line item got split into two schedule lines of 50 and 250(Both confirmed).After stock was available , delivery was created for 250(Sch line 2) but schedule  line 1 of 50   was not confirmed on the subsequent batch job for delivery creation in next 6-7 days although stock was available as I can see in MB5B(Eventually delivery got created after 7 days).Other orders from different customers  got deliveries created during those 6-7 days.

Questions are

1)why the deliveries were not created for confirmed schedule line 1 for 6-7 days although stock was available as visible in MB5B now for those days.

2)Also, how do I check the ATP qty/Av stock in the past for those days as in CO09 /MD04 I see only the current status and not the status of past ATP quantities.I have already checked the Credit Management part?

Kindly let me know what else should I check to find out the route cause of no delivery in Q1 above.I need this urgently.

Regards

[Former Member]

Anil,

1)why the deliveries were not created for confirmed schedule line 1 for 6-7 days although stock was available as visible in MB5B now for those days.

MB5B is irrelevant.  It only shows stock on posting date; it ignores the supplies and demands that are relevant for Availability checking.  Only CO09 tells the availability situation.

2)Also, how do I check the ATP qty/Av stock in the past for those days as in CO09

There is no standard transaction that will do this.  You can INFER the ATP situation if you know all elements in the scope of check, and you can use various methods to attempt to manually reconstruct

a. the onhand balance

b.all the supply elements, and

c. all the demand elements

that had existed at that particular point in time.  My recommendation is to abandon this search.  The resources invested in conducting such searches rarely result in any tangible benefits that justify the effort.

If you really need to be able to make such determinations on a regular basis, then you will probably need to create a custom report.  One method I have seen used is to run MRP every night and then create snapshots every night of the MRP lists for all materials that are of interest.  Usually, the MRP lists contain enough info to allow you to reconstruct the ATP situation.

Best Regards,

DB49