Currently, if Multicurrency Revaluation transactions span multiple months, the following error will occur when attempting to run the Reconcile to GL tool: Violation of PRIMARY KEY constraint ‘PK##XXXXX.’ Cannot insert duplicate key in object ‘dbo.##XXXXX’. The duplicate key value is (RMAPYXXXXXX, XXXXXXX , XXXXX ) This error message happens on temp tables due to a duplicate record being created based on current primary keys. The primary keys on the temp table need to be changed to accommodate revaluation transactions that span multiple months. The excel spreadsheet will print, however the problem records will not be added on the RM Side so the revaluation transactions will be unmatched. It would be nice for Microsoft Dynamics GP to allow users to successfully process the Reconcile to GL Tool without error and with appropriate records generated on the report when revaluation transactions span more than one month. Thanks

Needs Votes
Ideas Administrator

Thank you for the feedback. We will consider this for a future release. 

Jodi Christiansen
PM, Microsoft