Query

[Former Member]

Hi

SELECT sum(T1.[TaxSum]) FROM OSTT T0 INNER JOIN RDR4 T1 ON T0.AbsId = T1.staType INNER JOIN ORDR T2 ON T1.DocEntry = T2.DocEntry WHERE (T0.[AbsId]=-90 or T0.[AbsId]=-60 or T0.[AbsId]=-55 or T0.[AbsId]=-10 or T0.[AbsId]=5 or T0.[AbsId]=6) AND (T2.[DocNum] =$[ORDR.docnum] AND T2.[DocDate] =$[ORDR.docdate])

This query is giving erro after i have written line T2.[DocDate] =$[ORDR.docdate]

Thanks

[Former Member]

Closed.

[Former Member]

Hi

SELECT sum(T1.TaxSum) FROM

RDR4 T1

INNER JOIN ORDR T2 ON T1.DocEntry = T2.DocEntry

WHERE T1.staType IN (-90,-60,-55,-10,5,6) AND T2.DocNum =$[ORDR.docnum]

Perhaps your Docdate will not work here as it is..

Regards

[Former Member]

Hi

How it can work.

Thanks

[Former Member]

Hi

Do this

SELECT sum(T1.TaxSum) FROM

RDR4 T1

INNER JOIN ORDR T2 ON T1.DocEntry = T2.DocEntry

WHERE T1.staType IN (-90,-60,-55,-10,5,6) AND T2.DocNum =$[ORDR.DocNum] AND convert (varchar(8),T2.DocDate,3) =$[ORDR.DocDate]

Regards

[Former Member]

Hi,

You may try this same logic in the simplified version:

SELECT sum(T1.TaxSum) FROM

RDR4 T1

INNER JOIN ORDR T2 ON T1.DocEntry = T2.DocEntry

WHERE T1.staType IN (-90,-60,-55,-10,5,6) AND T2.DocNum =$[ORDR.docnum\] AND T2.DocDate =$[ORDR.docdate\]

Thanks,

Gordon

[Former Member]

Hi Gordon

Above query is working but it gives error only when i add this line - AND T2.DocDate =$http://ORDR.docdate

Thanks

[Former Member]

Is it because you have the same document numbers for different series?

You may try T2.SeriesStr = $[ORDR.SeriesStr\] instead.