eConnect error related to Analytical Accounting

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…  "

 

Have more questions? Submit a request

Comments