DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
NaomiP 9/7/2007 2:04:00 PM

Primary key error when inserting a line into GL10001

From a recent email:

Have you ever inserted data into the gl10001 table?  i can't enter multiple rows for each distribution because i keep getting violation of primary key error on the jrnentry field.  i even tried entering a unique value for that field just so i could insert and then tried to update them all to the same and i get the same error.  do you know a way around this?

Answer:

Dynamics GP doesn't use referential integrity, but just for good form enter a line into the GL10000 table first, then enter lines into the GL10001. Be sure that you increment the SQNCLINE field for each line.

 

Version: Unknown or N/A
Section: Dynamics GP
This thread has been marked as 'Closed' and archived