USP_SAVE_EDIT_JOURNALENTRIES

create procedure dbo.USP_SAVE_EDIT_JOURNALENTRIES
(
    @GLDISTRIBUTION xml,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin try
    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    update JE set
        GLACCOUNTID = GLACCOUNT.ID,
        COMMENT = DISTRIBUTIONS.REFERENCE,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    from
        dbo.UFN_FINANCIALTRANSACTIONLINEITEM_GETJOURNALENTRIES_FROMITEMLISTXML(@GLDISTRIBUTION) DISTRIBUTIONS
        inner join dbo.JOURNALENTRY JE on JE.ID = DISTRIBUTIONS.ID
        left join dbo.GLACCOUNT on GLACCOUNT.ACCOUNTNUMBER = DISTRIBUTIONS.ACCOUNT
end try

begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch

return 0;