RE: eConnect Error Number = 768 Stored Procedure= taPMDistribution Error Description = Account does not exist for Account Index
Looking at the taPMDistribution procedure, error 768 is produced from this piece of code:
if (@I_vACTNUMST <> '')
begin
select @I_vACTINDX = 0
select @I_vACTINDX = ACTINDX from GL00105 (nolock) where ACTNUMST = @I_vACTNUMST
if (@I_vACTINDX = 0)
begin
select @O_iErrorState = 769
exec @iStatus = taUpdateString
@O_iErrorState,
@oErrString,
@oErrString output,
@O_oErrorState output
end
end
else
begin
if not exists(select 1 from GL00105 (nolock) where ACTINDX = @I_vACTINDX)
begin
select @O_iErrorState = 768
exec @iStatus = taUpdateString
@O_iErrorState,
@oErrString,
@oErrString output,
@O_oErrorState output
end
In this case it's looking for the @I_vACTINDX value in the ACTINDX column of the GL00105 table, if not found, it generates this error message.
The entire code string is here:
Thanks