Skip to content


Error 687

Dean asked 9 years ago
Getting Error Number = 687  Stored Procedure= taGLTransactionLineInsert  Error Description = Input variable contains a duplicate Journal Entry number in GL
Node Identifier Parameters: taGLTransactionLineInsert

Have rolling GP column for JE number, and it seems to be creating the next GL number, but cannot get import to work. 
Best Answer
Lorren answered 9 years ago

Do you have the same GP Rolling Column mapped to the Header and the Line?  It seems like they are not the same.

One way to validate is to change the Destination to Microsoft Dynamics GP – File and provide a path.  The integration will create an XML file and show you what the Journal Entry value is for the header and the lines.
Dean replied 9 years ago

Thanks Lorren, got this to work. Had the GP Rolling column correct, but needed to bundle my batch column as the same versus sequential numbers. Just happy I got it working 🙂 Thanks for your assistance. 

If you would like to submit an answer or comment, please sign in to the eOne portal.