Dynamics GP - An error occurred executing SQL statements

Other associated errors :
GPS Error:54
SQL Error: 2601 (Microsoft)(ODBC SQL Server Driver)(SQL Server) Cannot insert duplicate key row in object 'dbo.AAG20000' with unique index 'AK2AAG20000'
ODBC Error:23000

Solutions:

1. I had this error occur due to bad inventory lots. Going through the transactions and removing the lots and re-adding different lots allowed this transaction to post even though it still threw all of the errors.
2. Running the script below to fix the AA values

Solution here
http://community.dynamics.com/gp/f/32/t/29394.aspx


Check for orphan AA records
------------------------------------------------------------------

select * from AAG30003 a left outer join AAG30000 b

on a.aaGLHdrID = b.aaGLHdrID

where b.aaGLHdrID is null

select * from AAG30002 a left outer join AAG30000 b

on a.aaGLHdrID = b.aaGLHdrID

where b.aaGLHdrID is null

select * from AAG30001 a left outer join AAG30000 b

on a.aaGLHdrID = b.aaGLHdrID

where b.aaGLHdrID is null

select * from AAG10003 a left outer join AAG10000 b

on a.aaGLWorkHdrID = b.aaGLWorkHdrID

where b.aaGLWorkHdrID is null

select * from AAG10002 a left outer join AAG10000 b

on a.aaGLWorkHdrID = b.aaGLWorkHdrID

where b.aaGLWorkHdrID is null

select * from AAG10001 a left outer join AAG10000 b

on a.aaGLWorkHdrID = b.aaGLWorkHdrID

where b.aaGLWorkHdrID is null