find out total before discount value from goods receipt po

[Former Member]

find out total before discount value from goods receipt po

i need query

argent  friends.

thanks

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this query:

SELECT T0.[DocNum], sum(T1.[LineTotal]) FROM OPDN T0  INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocNum]  = [%0] GROUP BY T0.[DocNum]

Thanks & Regards,

Nagarajan