cancel
Showing results for 
Search instead for 
Did you mean: 

Delivery Analysis Query

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor

Hi,

Please confirm all PO are created from SO through "Procurement Document" under logistics tab.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi

Yes, we will create all po through procure document from SO Logistics and also all GRPO's will be created from PO only.  There wont be any standalone PO or GRPO without any base document.

kothandaraman_nagarajan
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thank you..It is working fine.

Regards

Sundaram

kothandaraman_nagarajan
Active Contributor
0 Kudos

You are welcome.

Answers (1)

Answers (1)

former_member205766
Active Contributor
0 Kudos

Hi

Check the below link

With Regards

Balaji Sampath