UFN_PAYABLES_HASPAYMENTS

This determines whether an invoice or credit memo has any payments attached.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_PAYABLES_HASPAYMENTS(@ID uniqueidentifier)
returns bit
with execute as caller
as begin
  declare @HASPAYMENTS bit = 0;
  if exists(select * from dbo.FINANCIALTRANSACTIONSCHEDULE as FTS 
              inner join dbo.FINANCIALTRANSACTIONAPPLICATION as FTA on FTA.FINANCIALTRANSACTIONSCHEDULEID = FTS.ID
              where FTS.FINANCIALTRANSACTIONID = @ID and FTA.STATUSCODE = 1)
    set @HASPAYMENTS = 1;
    return @HASPAYMENTS
end