web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

CLOSED: Error 457: Key Already Associated (Assign Tax, Task 170)

(0) ShareShare
ReportReport
Posted on by 90

RMS v 2.0.0127

3 lanes total, error occurs on all 3 lanes (including the db based lane)

Start SO Mgr> Wizards> Task 170: Assign Items Sales Tax> Check Depts to assign tax to> Finish> Error Presents:

"Run-time error '457': This key is already associated with an element of this collection"

 Click OK on error - Manager shuts down

 Any help/ideas are greatly appreciated.

Thank you, Jocelyn

*This post is locked for comments

I have the same question (0)
  • Jocelyn Profile Picture
    90 on at

    Hi - I was just able to log on to the customer's comp and noted the following duplicate records under both Sales Tax and Item tax. I am not sure how exactly they were able to do this - seeing as the codes on each must be unique - but they did. Example:

    Database> Sales Tax had the following two Sales Taxes:

    • Code 001 - Desc. Sales Tax - Rate = 8.75%
    • Code 001 - Desc. Sales Tax - Rate = 0.00%

    Database> Item Tax had the following two Item Taxes:

    • Code 001 - Desc. Sales Tax - 1st = Sales Tax
    • Code 001 - Desc. Sales Tax - 1st = Sales Tax

    Now - because the taxes were never codes to unique Descriptions - I don't know which one, or both were assigned to the Item Tax. Maybe that is where the redundancy kicked in. But - in short - I wanted to post back here for others that run into the same issue. Once I deleted the duplicates, I was able to immediately run the Wizard Task 170 without any issues. Hope this helps if you hit the same snaffu!

    Jocelyn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans