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

[former_member187989]

hi Istvan Koros.

Thank you for report,Problem solved.

Jeyakanthan

[Former Member]

Hi Friend,

Most of the requirement can be meet if you use Purchase Reports -> Purchase Analysis - Items tab, selecting GRPO as the only source and a certain posting period range.

However, the report cannot be grouped by Item group. But you can still view the report for each of the Item Groups individually.

To get a more specific report as you've mentioned, I'm afraid you would need to write your own query to get the data you need from the table, and then save the query as a report.

Kind Regards,

Dani Zhao

SAP Business One Forums Team