"Origin" of sales order confirmations for MTS materials

[davide_delmonte]

Hi,

After mass rescheduling of sales order, I would like to know for every single schedule line confirmed, which is the "origin" of this confirmation.

I mean, in the scope of check we define precisely which stocks, receipt and issue elements should be taken into account during the availability check. Then I would like to have a report like this:

SO 1 - schedule line 1 - 50pcs - confirmed against stock

SO 2 - schedule line 2 - 30pcs - confirmed against purchase order

SO 3 - scheduline line 1 - 20pcs - confirmed against production order

I know that in the standard MTS (make to stock) scenario it could be really hard, I just want to know if someone approaches this kind of reporting and what're the best practices to share.

[davide_delmonte · Accepted solution]

I want to share the solution we got:

Using function module MD_SALES_ORDER_STATUS_REPORT you can get the "Last receipt element" for each "requirement element" (Sales order / schedule line), so in this way you can approximate what's the origin of the quantity confirmed by ATP rules.

You can build a report that run this function for every material / MRP element and collect this data.

[Lakshmipathi]

Assuming your system is set for ATP from storage location which is intended for Unrestricted stock, it is not possible to achieve this. May be, while stock posting through different movement types, if the user maintain the related text some where, may be, with some enhancement, there is a possibility of tracing this but if you ask me, I would not encourage this practice

[davide_delmonte]

Thank you Lakshmipathi for your answer, just to share with other users, we finally reach the achievement using fucntion module MD_SALES_ORDER_STATUS_REPORT

[Lakshmipathi]

When you post a query and give further updates, please add the content under "Comments" and not under "Answer" as you were not answering to a query but only providing additional informations as asked by the members. Also, when you add the text under Comments, it will be intimated to the person to whom you are responding whereas, if you add the text under Answer, the member will not be intimated. By the way, your above answer has been converted as comment by me.

Meanwhile, if the requirement is solved, please close the discussion.