Stored procedure error code 683
Adrian Harris asked 7 years ago
I am attempting to insert a GL journal entry, I created the Journal and distribution , filled in the required fields got error below.
Sql procedure error codes returned:
Error Number = 683 Stored Procedure =taGLTransactionLineInsert Error Description = You
Node Identifier Parmters:taGLTransactionLineInsert
Batchnumber=)8524f2999A4E
JRNENTRY=1
CRDTAAMT=0
DEBITAMT=0
Related Error Code Parameters for Node : taGLTransactionLineInsert
ACTINDS = Note: parameter was not passed in, no value for the parameter will be returned
ACINUMST = Note : This parameter was not passed in, no value for the parameter will be returned
Sql procedure error codes returned:
Error Number = 683 Stored Procedure =taGLTransactionLineInsert Error Description = You
Node Identifier Parmters:taGLTransactionLineInsert
Batchnumber=)8524f2999A4E
JRNENTRY=1
CRDTAAMT=0
DEBITAMT=0
Related Error Code Parameters for Node : taGLTransactionLineInsert
ACTINDS = Note: parameter was not passed in, no value for the parameter will be returned
ACINUMST = Note : This parameter was not passed in, no value for the parameter will be returned
Answers
Patrick Roth Staff answered 7 years ago
Adrian,
You cut the message text off but I can see the error message number and look it up in the taErrorCode table. Message 683 is:
You have not passed an ACTINDX (ACTINDX) or an Account String (ACTNUMST)
This means exactly what it suggests – you didn’t pass eConnect an account number/ or account index to the proc.
And we know that because if you look at the error message it tells you that two params were not passed: ACTINDS and ACINUMST.
You have to pass in your account – it doesn’t “default” for Journal Entries.
The next problem you are going to have is that you are passing in 0 for Debit and Credit amounts. You have to pass in a value for one or the other on each line.
Patrick
eOne
You cut the message text off but I can see the error message number and look it up in the taErrorCode table. Message 683 is:
You have not passed an ACTINDX (ACTINDX) or an Account String (ACTNUMST)
This means exactly what it suggests – you didn’t pass eConnect an account number/ or account index to the proc.
And we know that because if you look at the error message it tells you that two params were not passed: ACTINDS and ACINUMST.
You have to pass in your account – it doesn’t “default” for Journal Entries.
The next problem you are going to have is that you are passing in 0 for Debit and Credit amounts. You have to pass in a value for one or the other on each line.
Patrick
eOne