This content has been marked as final. Show 6 replies
First of all - we appreciate that you have spent the effort to write a query and then are asking for feedback instead of simply1 person found this helpful
* "How do I do this? Please reply asap".*
1) I don't see any outer joins. If a sales order does not have a PO created yet, the sales order won't show up in your query.
2)ASCP has msc_full_pegging that is useful to join SO and PO. MRP has mrp_full_pegging. Can you try to use that? Use it to join mgr and mr.
Hope this helps,
Yes Sandeep,i can modify SQL to use full pegging table.thank you.
But the PO and SO are losely coupled right..lets take one example..support there are 10 SO's and demand for Item A is 100 ..each SO demand is 10..means there would be 10 PR creation after running the MRP..
Buyer after looking at all the 10 requisitions/PR's for same ItemA,he might have converted only 1 PR and modify qty to 100..in that case rest of 9 PR's are cancelled.So how do i map PO to cancelled PR's SO's??
I am just a beginner..new to MRP..just trying to build pegging report.
Yes - the mrp pegging is loose and transient (i.e. it may differ from one mrp run to the next)
The report you have will be only as accurate as the last plan run.
In your case, after 9 PR are cancelled and 1 is changed to 100, you will run another MRP plan next day.
And you will run the report and you will see that the 10 SO are pegged to one PR.
Hope this answers your question
Independent Techno-functional Consultant
Hi Can you please paste the query with the outer join,
Thanks and Regards,
I tried writing the query to find the supply and demand details in ASCP Planning.
In our scenario we created a sales order '5110416.AT PROJECT.ORDER ENTRY(6.1)' and launch the plan. It has created the plan order and after releasing it has created the internal requisition and then Internal sales order. But the supply sales order number is not populated in order_number column of msc_supplies.
Please help me if I am missing some thing. Just for your info I have run the plan again and then also its not updated. Below is the query which I have written. This is very critical for me. Please advice.
AND MD.ORDER_NUMBER='5110416.AT PROJECT.ORDER ENTRY(6.1)'
Thanks in advance.
is the first query correct ............?