Error: An item with the same key has already been added

Applies to:

• Velixo Classic
• Velixo NX
• Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica

TABLE OF CONTENTS

• Overview
• Cause
• Resolution

Overview

When refreshing a workbook containing Velixo functions, the following message is displayed for some functions:

Text of Message

Error! An item with the same key has already been added.

Cause

For performance reasons, Velixo caches certain data returned by the functions in your workbook (so that you do not have to retrieve identical data from your ERP over and over again).

Sometimes, the cached data may be out-of-date and cause an issue when attempting to access it.  In this case, it is necessary to re-retrieve the data from the ERP

Resolution

Perform a Full Refresh of your Velixo functions:

  This will not only retrieve the latest data from the ERP, but it will also update the cached data.