GRPO report

[former_member187989]

Hi all,

Our client need sql report of Good Receipt PO

between a period for various item groups.

Report should contain

GRPO No.,Posting Date,Item Group,Total(Row),

Tax,Document Total

Thanks,

Jeyakanthan

[former_member204969 · Accepted solution]

You can try this query:

SELECT T0.DocNum, max(T0.CardName),max(T0.DocDate),
 T3.ItmsGrpNam,  sum(T1.LineTotal), sum(T1.VatSum),max(T0.DocTotal)
 FROM OPDN T0
  INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry
  INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode
  INNER JOIN OITB T3 ON T2.ItmsGrpCod = T3.ItmsGrpCod 
WHERE T0.DocDate >='[%0]' and T0.DocDate <='[%1]' 
GROUP BY T0.DocNum,T3.ItmsGrpNam
ORDER BY T0.DocNum,T3.ItmsGrpNam