Isnull(Sum(case when Action IN ('O','I') and entryDate Between '01/Apr/2014' and '31/MAr/2015' then td.Amount Else 0 End),0) as Rcpt ,
Isnull(Sum(case when Action IN ('C') and entryDate Between '01/Apr/2014' and '31/MAr/2015' then td.Amount Else 0 End),0) as Pymt
FROM RDMASTER A inner Join Customers c
ON a.Customerid=c.Cust_No
LEFT JOIN RDOPENINGBALANCE OP ON OP.RDMasterId=A.RDMasterId AND FYEARID=18
Left Join rdTransactionMaster tm on tm.rdMasterId=a.rdMasterId and tm.CancelFlag='N'
and entryDate Between '01/Apr/2014' And '31/MAr/2015'
Left Join rdTRansactionDetails td on td.rdTransactionid=tm.rdTransactionid
Where A.groupid=3 GROUP BY a.rdMasterId,a.startdate,A.RDNO,OP.OPENING,F_Name
Having Isnull(Sum(case when Action IN ('C') then td.Amount+Interest Else 0 End),0) = 0
ORDER BY a.startdate,a.rdMasterId
AS PER ABOVE MENTIONED QUERY,SHOWING "INTEREST PAYABLE" EVEN ALREADY CLOSED THE TRANSACTION ...GIVE ME ANSWER
Maneesh A NPosted Apr 29, 2014, 5:34 AM
1073 848 A.E.ABDULKHADER 13133.0 0.0 0.0
785 487 P.K.UNNIKRISHNAN 71237.0 200.0 0.0
786 488 ANTONY GEORGE 14774.0 0.0 0.0
787 489 THOMAS P .CHERIYAN 18.0 0.0 0.0
788 490 C.B.KUNJUMOHAMMED 35665.0 100.0 0.0
789 491 E.K.MURALEEDHARAN 35661.0 100.0 0.0
790 492 T.SURENDRAN 813.0 0.0 0.0
791 493 K.P.UMANATHAN 0.0 0.0 0.0
792 494 DILIP K. SHAH 35665.0 100.0 0.0
see this...rdno 488 already closed. but still seems opening 14774 and interest payable 1330(example) when the time of interest posting.this also showing 'RD RECEIPTS' in grid
sudipta sanyalPosted Apr 29, 2014, 5:10 AM