cancel
Showing results for 
Search instead for 
Did you mean: 

Query >> total before discount value from Goods repiect PO

Former Member
0 Kudos

i need query total before discount value from Goods repiect PO

SELECT T0.[DocDate], T0.[DocNum], T0.[DocType], T0.[CardCode],T0.[CardName], T0.[DocTotal],T0.[RoundDifSy] FROM OPDN T0 where T0.DocType = 'I' and (t0.DocDate >='[%0]' AND t0.DocDate <='[%1]') AND T0.DocType ='[%2]'

total before discount value = (total value - rounding - tax)

or

total before discount value =( total value - rounding)

i need query

thanks

venkadeswaran

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

If this discussion is related to your latest post, please close this thread here.

Thanks & Regards,

Nagarajan

Answers (0)