USP_GLACCOUNTMAPPINGERROR_ACKNOWLEDGE

Executes the "Unmapped Transaction Message: Review" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



CREATE procedure dbo.USP_GLACCOUNTMAPPINGERROR_ACKNOWLEDGE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    declare @PDACCOUNTSYSTEMID uniqueidentifier;
    declare @ERRORMESSAGE nvarchar(max);
    select
        @PDACCOUNTSYSTEMID = FT.PDACCOUNTSYSTEMID
        ,@ERRORMESSAGE = ME.ERRORMESSAGE
    from dbo.GLACCOUNTMAPPINGERROR ME
    left join dbo.SALESORDER SO on SO.ID = ME.TRANSACTIONID
    inner join dbo.FINANCIALTRANSACTION FT on FT.ID = ME.TRANSACTIONID or FT.ID = SO.REVENUEID
    where ME.ID = @ID;

    update dbo.GLACCOUNTMAPPINGERROR set
        ADDRESSED = 1
        ,CHANGEDBYID = @CHANGEAGENTID
        ,DATECHANGED = GETDATE()
    from dbo.GLACCOUNTMAPPINGERROR ME
    left join dbo.SALESORDER SO on SO.ID = ME.TRANSACTIONID
    inner join dbo.FINANCIALTRANSACTION FT on FT.ID = ME.TRANSACTIONID or FT.ID = SO.REVENUEID
    where FT.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
        and ME.ERRORMESSAGE = @ERRORMESSAGE
        and ME.DELETED = 0

    return 0;

end