Notifications
Announcements
No record found.
Can someone please remind me how to remove all the duplicate SmartList entries. Every single one is duplicated and if I add new favorite it appears twice. GP 2010.
*This post is locked for comments
Richard, do you mean that you are gettin duplicate entries within a smartlist? I am having trouble with that also.
Barb, I mean the entire folder structure is doubled. So under Inventory-Items for every Smartlist there is a double. When you run them they are the same Samrtlist.
I had a similar situation with some Mfg smartlists a couple of years ago. It was only a dozen or 2 so I just manually edited the tables. I believe it was the ASIEXP81 table. If all are duplicated, I would probably contact Microsoft. It is an incident. but probably the quickest way to a solution.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
Did you resolve this? We are having the same problem, but only on one workstation.
Hi Richard,
What you are seeing indicates that there are "old" records in the table still that should have been removed by a previous update. When you look at the table, you will see two "master" records for each SmartList instead of just one. Generally one has a name and one has a number. You can use the following script to see it.
select * from DYNAMICS..ASIEXP81 where ASI_Favorite_Save_Level=0 and ASI_Favorite_Dict_ID=0 order by ASI_Favorite_Type
With the results from this, the valid records for 2010 would be the ones with the 280xx numbers in the ASI_Favorite_Name column. The others are invalid.
You can compare it to a new install of GP 2010 as well to see how they match up. After you figure out which ones are "invalid", you can certainly remove them. Just be sure you have a valid backup of the database before doing so.
This should take care of the duplicates.
Does this happen on all Smartlist object or just BBF transactions?
This is not the results of something returned by SmartList, this is the list of SmartList itself.
This is held in the ASIEXP81. If you query this table do you see duplicate records?
Yes they are duplicated in that table. I will remove the duplicates. Thanks.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
