total sales amount
hi SAP Kings
sales analysis report total amount is differ from sum of line total in query.what is the problem and where i did mistake please refer this query please give suggestion....i need the sum of linttotal calculated in not include tax....
SELECT count(T0.[DocNum]),T0.[CardCode], T0.[CardName], T0.[Address], sum( T0.[DocTotal]-T0.[VatSum]) FROM OINV T0 WHERE (T0.[DocDate] >=[%0] or [%0]='') and (T0.[DocDate] <=[%1] or [%1]='') GROUP BY T0.[CardCode], T0.[CardName], T0.[Address]
Thanks & Best Regards
Edited by: lakshmi narayanan on Sep 19, 2008 12:12 PM
Edited by: lakshmi narayanan on Sep 19, 2008 12:13 PM