UFN_BILLINGITEM_GETLATESTCREDITDATEFORBILLINGITEM

Get latest receivable credit date which is using the specified billing item

Return

Return Type
date

Parameters

Parameter	Parameter Type	Mode	Description
@BILLINGITEMID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BILLINGITEM_GETLATESTCREDITDATEFORBILLINGITEM
            (
                @BILLINGITEMID uniqueidentifier=null
            )
            returns date
            as begin
                -- do work here and return a value

                declare @retval date;

                select @retval = max(dbo.FINANCIALTRANSACTION.[DATE])
                from dbo.FINANCIALTRANSACTION 
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM
                        on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                    inner join dbo.RECEIVABLECREDITLINEITEM
                        on FINANCIALTRANSACTIONLINEITEM.ID = RECEIVABLECREDITLINEITEM.ID
                where dbo.RECEIVABLECREDITLINEITEM.BILLINGITEMID = @BILLINGITEMID

                return @retval;
            end