Sign Up Now!Log In
kretek 3/21/2018 3:53:44 PM

Violation of PRIMARY KEY constraint 'PKPA01901'.

Violation of PRIMARY KEY constraint 'PKPA01901'. Cannot insert duplicate key in object 'dbo.PA01901'. 


that is the whole econnect error. I've read a couple comments on this and i understand its a concurrency issue. i am using the econnect method GetNextPOPReceiptNumber in our code.


What i am trying to find is where that next po receipt number is stored in the Dynamics SQL tables so i can run a custom method to check the next receipt.



Version: GP 2015
Section: .NET Development, Dynamics GP, eConnect