USP_INVOICE_SETREMITTOADDRESS

This stored procedure will update the REMITTOADDRESS on the invoice based on the vendor

Parameters

Parameter	Parameter Type	Mode	Description
@INSERTED	UDT_FINANCIALTRANSACTION_VENDOR	IN

Definition

Copy



create procedure dbo.USP_INVOICE_SETREMITTOADDRESS
(
    @INSERTED dbo.UDT_FINANCIALTRANSACTION_VENDOR readonly
)
as
    set nocount on;

    begin try
        update dbo.INVOICE set 
            REMITADDRESSID = A.ID,
            CHANGEDBYID = I.CHANGEAGENTID
            from @INSERTED as I
            left outer join dbo.ADDRESS A on (A.CONSTITUENTID = I.VENDORID) and (A.ISPRIMARY = 1);
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;