An Item with the same key has already been added

Issue

Users are receiving the error “An unexpected error occurred: An item with the same key has already been added. Would you like to view this error details? An item with the same key has already been added.” when creating a new layout using the Financial Genie Report or Financial Report Designer reports.

An unexpected error occurred: An item with the same key has already been added. Would you like to view this error details?

An item with the same key has already been added.

Symptoms

When users are creating or generating a new layout using BI Tools within Excel, users are receiving the above mentioned error.

When users click on BI Tools, and then click on “Quick Generate”

Select the required layout

The following error will appear, click on yes.

Then click on OK.

Resolution

There are duplicate keys added on your "Sheet 1." 

Please make sure that there are no keys added or accounts added that duplicate anything else.

• Related Articles

• The Sage Intelligence Report Designer Add-In is not responding

  Products Sage 300 2016 Description When trying to add a New Layout in Sage Intelligence Report Designer reports, the below error appears. DESCRIPTION Cause The Visual Basic for Applications (VBA) components / .NET Programmability are not installed. ...

• Creating a Report Shortcut in Intelligence Reporting

  An LNK file allows a report to be run from a shortcut without needing to use the Report Manager Interface. LNK files need to be created using the Report Manager Interface and then associated with the Alchemex.exe program under the windows operating ...

• Using Variables in Other Report Properties

  Variables (System and Pass Through) variables can also be used in certain properties on a report to dynamically affect them when a report is run. Some scenarios where this might be useful are listed below: Example 1 You are specifying an output file ...

• Sharing Report Shortcuts using Intelligence Reporting

  Problem When you create a report shortcut, it creates and points to a file within the AppData directory of the user that created the shortcut, which in turn points to the BICore.exe on the machine. When another user tries to run the report shortcut, ...

• Publishing reports to the Report Viewer external menu

  The option to allow or prevent access is found under the advanced properties of a report in the Report Manger. To get to it: 1. Open your Report Manager and select the report you want to work with. 2. Select the Show Advanced checkbox at the bottom ...