Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

B.Laskhmi Narayanan

Edited by: lakshmi narayanan on Sep 19, 2008 12:12 PM

Edited by: lakshmi narayanan on Sep 19, 2008 12:13 PM

Former Member
Former Member replied

Please check this thread to have a reference:

Query vs Sales Analysis Report

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question