UFN_CREDIT_GETSPLITCREDITAMOUNT_BULK

CREATE function dbo.UFN_CREDIT_GETSPLITCREDITAMOUNT_BULK()
returns table
as return
    select
        CREDITSPLIT.SOURCELINEITEMID,
        case
            when sum(CREDITSPLIT.TRANSACTIONAMOUNT) > SOURCESPLIT.TRANSACTIONAMOUNT  -- When fully refunding a discounted item, the refund li's value will be the item's full value; adding the original discount li will overstate the credit amount.

                then SOURCESPLIT.TRANSACTIONAMOUNT
            else sum(CREDITSPLIT.TRANSACTIONAMOUNT)
        end CREDITTOTAL
    from dbo.FINANCIALTRANSACTIONLINEITEM CREDITSPLIT
    inner join dbo.CREDITITEM_EXT on CREDITITEM_EXT.ID = CREDITSPLIT.ID
    inner join dbo.FINANCIALTRANSACTIONLINEITEM SOURCESPLIT on SOURCESPLIT.ID = CREDITSPLIT.SOURCELINEITEMID
    group by CREDITSPLIT.SOURCELINEITEMID, SOURCESPLIT.TRANSACTIONAMOUNT;