UFN_INSTALLMENT_GETINSTALLMENTBALANCE_BULK

            CREATE function dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE_BULK ()
returns table
as
return (
    select I.ID
      ,I.REVENUEID
      ,I.SEQUENCE
      ,I.[DATE]
      ,I.TRANSACTIONAMOUNT
      ,I.AMOUNT
      ,I.ORGANIZATIONAMOUNT
      ,I.TRANSACTIONCURRENCYID
      ,I.BASECURRENCYID
      ,I.BASEEXCHANGERATEID
      ,I.ORGANIZATIONEXCHANGERATEID
      ,I.DATEADDED
      ,I.DATECHANGED
      ,I.ADDEDBYID
      ,I.CHANGEDBYID
      ,I.TRANSACTIONAMOUNT - (COALESCE(IP.TRANSACTIONAMOUNT, 0) + COALESCE(IWO.TRANSACTIONAMOUNT, 0)) BALANCE
    from dbo.INSTALLMENT I
    left join (
      select INSTALLMENTID
        ,SUM(AMOUNT) TRANSACTIONAMOUNT
      from dbo.INSTALLMENTPAYMENT
      group by INSTALLMENTID
      ) IP on I.ID = IP.INSTALLMENTID
    left join (
      select INSTALLMENTID
        ,SUM(TRANSACTIONAMOUNT) TRANSACTIONAMOUNT
      from dbo.INSTALLMENTWRITEOFF
      group by INSTALLMENTID
      ) IWO on I.ID = IWO.INSTALLMENTID
    )