Hi,
We have the following message with GP when we try to post JE via Smarconnect
7738 - taGLTransactionLineInsert - Input variable contains a duplicate Sequence Line Number (SQNCLINE) .
Does someone already see that?
Thanks
Richard
*This post is locked for comments
I don't think it is a bug. I think that 0 is a reserved value for SQNCLINE. You can supply 0 for all rows and eConnect will automatically allocate the sequence numbers for you. If you send in your own sequence numbers, then the minimum allowed value is 1.
There is a bug in the taGLTransactionLineInsert for eConnect. How sad after two years later I hit the exact same error. After decrypting the SQL stored procedure I discovered that Microsoft put logic in the sequence numbering that causes the sequence zero (your first line record) to automatically get reset to 500. This results in a duplicate sequence number when your integration exceeds 499 records.
Microsoft's logic:
if ( @I_vSQNCLINE = 0 )
begin
select @SQNCLINE = isnull(max(SQNCLINE),0) + 500 from GL10001 (nolock) where JRNENTRY = @I_vJRNENTRY
end
else
begin
select @SQNCLINE = @I_vSQNCLINE
end
Thanks Shyam for you answer.
But do you know if we could have a limit with the number of lines that i can uploaded? Because the message we got also toll me that it looks like we have a duplicate with line 500. And i don't understand why especially line 500...
Regards,
Richard
SmartConnect ensures that all data created in GP is valid by applying all the business rules contained in GP with the use of eConnect.
As the error message rightly describe, the issues seems to be because of bad data. You might need to revisit the data and see the values passed to element "SQNCLINE" (Sequence line). If there are multiple lines for same Journal entry number, you need to pass different Sequence line number.
You can refer XML node for taGLTransactionLineInsert from msdn.microsoft.com/.../jj193354.aspx
It could also be because as it is not required field, if you havent passed any value, by default it might be going as zero and as I said if there are multiple lines for a single entry, the same error will popup.
Cheers,
Shyam.
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156