on 12-04-2014 11:35 AM
Dear Experts
I need to have a delivery analysis. With respect to my organization, all the purchase orders are created based on a sales order only and all grpo's are based only on the purchase order. so want to check
What is sales order delivery date committed and when we received the material from the vendor (goods receipt PO). Output I need is
Sales Order No. Sales Order Date, Sales Order Delivery Date, ItemName,PO Number, PO Date, Grpo Number, GRPO Date, Days from PO to Grpo (PO Date-GRPO DAte), Days from SO Delivery Date to GRPO Date (SO Delivery DAte- GRPO Date)
Kindly help.
thanks and regards
sundaram
Hi,
Please confirm all PO are created from SO through "Procurement Document" under logistics tab.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this query:
SELECT T0.[DocNum], T0.[DocDate], T0.[DocDueDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T2.[DocNum], T2.[DocDate], T3.[Quantity], T5.[DocNum], T5.[DocDate], T4.[Quantity], datediff(dd,T2.[DocDate],T5.[DocDate]) as 'PO Date to GRPO Date', datediff(dd,T0.[DocDate],T5.[DocDate]) as 'SO date to GRPO date'
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry left join OPOR T2 on T2.[DocNum] = T1.[PoTrgNum] INNER JOIN POR1 T3 ON T2.DocEntry = T3.DocEntry left join PDN1 T4 on T4.[BaseEntry] = T3.docentry and T4.[LineNum] = T3.[LineNum] left JOIN OPDN T5 ON T4.DocEntry = T5.DocEntry WHERE T0.[DocStatus] = 'o' and T0.[DocDate] between [%0] and [%1] and T1.[ItemCode] = T3.[ItemCode]
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.