Client is getting this error on an Adjustment transaction (assuming it could be any inventory transaction):
Violation of PRIMARY KEY constraint 'PKAAG20000'. Cannot insert duplicate key in object 'dbo.AAG20000'
This seems to be a common eConnect error in test companies where the Analytical Account set up is incomplete or inaccurate. Here are some articles on the error:
https://community.dynamics.com/gp/f/32/t/39074
http://msgroups.net/greatplains/primary-key-violation-on-aag20000-table-after-mig/593519
This error will require the GP partner to perform some maintenance on the GP database.
A partner recently resolved this error by running a script (not sure of the details on that script) and then had to remedy this situation with the below solution:
"The Dynamics..AA00102 table was missing an entry for the test company next number for the AAG20000 table.
Inventory test transaction worked after inserting a record there… "
Comments