Smartlist Navigation Pane
aciccote asked 9 years ago
Users are reporting strange results when running smartlists from the Account Transaction folder. I noticed we have a Smartlist ID '.12' in the SLB10000 table with a SmartList Name of 'Account Transactions' which does not show up in the list of SmartLists when within SmartList Builder, but all the reports under Account Transactions folder in SmartList are behaving badly.
If we disable SmartList Builder from the Customization Status window in GP, we see Account Transactions twice on the Navigation Pane. One works fine the other does not. The '.12' entry also appears in the SLB10100, SLB10200, SLB10400, SLB10600, SLB10700 and SLB10900 Tables.
Think there is any harm in deleting the '.12' rows in these tables? The one in SLB10000 has the highest Dex_Row_ID so I know it is the most recent.
We are running Dynamics GP 2013 R2
If we disable SmartList Builder from the Customization Status window in GP, we see Account Transactions twice on the Navigation Pane. One works fine the other does not. The '.12' entry also appears in the SLB10100, SLB10200, SLB10400, SLB10600, SLB10700 and SLB10900 Tables.
Think there is any harm in deleting the '.12' rows in these tables? The one in SLB10000 has the highest Dex_Row_ID so I know it is the most recent.
We are running Dynamics GP 2013 R2
Answers
Patrick Roth Staff answered 8 years ago
<p>aciccote, </p>
<p>It appears that you’ve used SLB to duplicate an existing GP "Account Transaction" SmartList. You can do that by selecting the smartlist and choosing to "modify" it. For GP ones, that would have SLB duplicate the smartlist and then open it for editing. There isn’t any real indication that this has occurred but we know it did because of the ".12" name and also if you disable SLB then you see 2 of them (because SLB hides the original GP one but since you disabled it then it didn’t).</p>
<p>To remove the duplicated SLB version, just go back into SmartList and choose the account transaction smartlist. Choose to Modify it as normal but then Delete it. When you do this, SLB will delete the records and then show you the original one in SmartList again. You don’t have to manually try to delete the records (but should work too). </p>
<p>patrick</p>
<p>It appears that you’ve used SLB to duplicate an existing GP "Account Transaction" SmartList. You can do that by selecting the smartlist and choosing to "modify" it. For GP ones, that would have SLB duplicate the smartlist and then open it for editing. There isn’t any real indication that this has occurred but we know it did because of the ".12" name and also if you disable SLB then you see 2 of them (because SLB hides the original GP one but since you disabled it then it didn’t).</p>
<p>To remove the duplicated SLB version, just go back into SmartList and choose the account transaction smartlist. Choose to Modify it as normal but then Delete it. When you do this, SLB will delete the records and then show you the original one in SmartList again. You don’t have to manually try to delete the records (but should work too). </p>
<p>patrick</p>
aciccote,
it appears that you’ve used SLB to duplicate an existing GP “Account Transaction” SmartList.
You can do that by selecting the smartlist and choosing to “modify” it.
For GP ones, that would have SLB duplicate the smartlist and then open it for editing. There isn’t any real indication that this has occurred but we know it did because of the “.12” name and also if you disable SLB then you see 2 of them (because SLB hides the original GP one but since you disabled it then it didn’t).
To remove it, just go back into SmartList and choose the account transaction smartlist. Choose to Modify it as normal but then Delete it.
When you do this, SLB will delete the records and then show you the original one in SmartList again. You don’t have to manually try to delete the records (but should work too).
patrick
Well, we did end up doing the deletes in SQL and they did work, but I'm sure this will happen again and if there is a way to fix it from the app itself, I prefer doing it that way.
aciccote,
well, you could do it from the UI as I suggested
To remove it, just go back into SmartList and choose the account transaction smartlist. Choose to Modify it as normal but then Delete it.