"An item with the same key has already been added" Error message displays in Management Reporter 2012 FiscalYearProvider to Fiscal Year task
This article provides a solution to an error that occurs when you use Microsoft Management Reporter 2012 with Microsoft Dynamics GP.
Applies to: Microsoft Management Reporter 2012, Microsoft Dynamics GP
Original KB number: 2983920
Symptoms
When you use Microsoft Management Reporter 2012 with Microsoft Dynamics GP, you may receive the following error message during the FiscalYearProvider to Fiscal Year integration task:
An item with the same key has already been added
Cause
There may be duplicate Dex_Row_Id
values within the SY40100 and SY40101 tables.
Resolution
Run both scripts against the company database(s) to check for duplicate Dex_Row_Id
values within the period tables.
select top 1 DEX_ROW_ID from sy40100 group by DEX_ROW_ID having count(*) > '1'
select top 1 DEX_ROW_ID from sy40101 group by DEX_ROW_ID having count(*) > '1'
If a record is returned, contact support for further assistance.
Use the Support Topic: Financial - General Ledger, and the Sub-Topic: Fiscal Periods
To reach the Message Center to open a support incident, call 1-888-477-7877. Provide as many details as you can.
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru