Skip to Content

How to add Monthwise total P.O qty in this below query Report?

Hi Experts,

Here I have Submitted a Query for Month wise  GRPO Qty. I Want To add Month wise P.O Qty Along With This Query? Kindly Help For this ?

SELECT CardName,[ItemCode],[ItemName],  [4] as Apr, [5] as May, [6] as Jun, [7] as Jul,  [8] as Aug, [9] as Sep, [10] as Oct, [11] as Nov, [12] as Dec, [1] as Jan, [2] as Feb, [3] as Mar

( select CardName,T0.[ItemCode],T2.[ItemName],sum(T0.[Quantity]) as Quantity, month(T1.[DocDate]) as Month FROM PDN1 T0  INNER JOIN OPDN T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode  and (T1.[DocDate] between '2014/04/01' and '2015/03/31')  WHERE   (T0.ItemCode LIKE '%%[%0]%%' OR '[%0]' = ' ')
GROUP BY  CardName,T0.[ItemCode],T2.[ItemName],T1.DocDate)S

(sum(Quantity) FOR Month IN ([4],[5],[6],[7],[8],[9],[10],[11],[12],[1],[2],[3])) P



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2015 at 12:54 PM


    Please do not post multiple discussion for same subject.

    Close this thread here.

    Thanks & Regards,


    Add comment
    10|10000 characters needed characters exceeded