Skip to Content
0
Former Member
Jun 29, 2010 at 02:16 PM

Query Modification for Invoice Outstanding

13 Views

Hi ,

Can anybody modify this code by DocNum. This query displays the same invoice 2 times when the invoice is having more than 1 item. How to get the report without invoice number repeat.

/*

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T1.[OpenSum] ,T1.[VatSum],

T0.WTSum AS 'TDS Amount',

T0.DocTotal,

(T0.DocTotal-T0.[PaidToDate]) as 'BalanceDue',

(SELECT CASE

WHEN T1.TargetType='14' THEN 'A/R CreditMemo'

Else ' '

End) as 'Target Type'

FROM OINV T0 INNER JOIN INV1 T1 ON

T0.DocEntry = T1.DocEntry

WHERE T0.[DocDate] BETWEEN '[%0]' AND '[%1]'

*/

Regards

Srini