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.