You’re offline. This is a read only version of the page.
76
Hello,
Getting this error using eConnect, I'm pretty sure I'm passing in the Account Index. I cannot repro this on my dev box. But this is happening on the customer site. I believe it's some configuration in GP. Any help would be appreciated.
thanks
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
Share
Report
All responses (
Answers (
