Query Help Plz
I have a problem with my query, I have 2 series of billing
If I want to get a report of a single series that I only get the full amount without detail.
I am not throwing well this amount. In fact is bigger
It's just that simple add up the total of all invoices of that series, omitting the invoices canceled (with the targettype <> 14) who comes to me for being alive only bills that are not within any notes credit
This is my query:
SELECT TIPO = 'SELLOS', (SUM(T0.DOCTOTAL)) MONTO FROM OINV T0 INNER JOIN NNM1 T1 ON T0.SERIES = T1.SERIES INNER JOIN INV1 T2 ON T0.DocEntry = T2.DocEntry WHERE T0.DocDate BETWEEN [%0] AND [%1] AND T1.SeriesName = 'SELLOS' AND T0.CANCELED = 'N' and T2.TargetType <>'14'