I have a SmartList Builder SmartList deployed in both Production and Development systems. In this example, we’ll be looking for the ‘View’ and ‘Summary Inquiry’ Go To items.
If you’d like to watch a video explaining this, see below or click here.
What we’ve noticed is that in Production, for my custom SmartList Builder Smartlist, I can see the Go To items that I’ve created.
However, in the Development system, even though the SmartList exists, I do not have those same SmartList Builder Go To items displayed as I would expect.
I’m logged in as a PowerUser in Microsoft Dynamics GP, but still don’t see them. Is this a Security issue of some sort?
Fixing SmartList Builder Go To Items
No, this isn’t any kind of security issue in Dynamics GP, SmartList, or SmartList Builder.
The display of Go To items themselves do not have Security Restrictions. Instead, Dynamics GP Security would be applied when the Go To item is selected and security applied to whatever the Dynamics GP window that opens from selecting the Go To.
Assuming that the Go To items were created in Smartlist Builder in development, then they would be imported along with the SmartList itself in production.
Most likely, they were removed in SmartList Builder itself which would eventually then get removed from SmartList.
We can query SQL to check the SmartList Builder Go To table SLB10400.
We can also query the ASIEXP60 which is the SmartList Go To table.
The first query to the SLB10400 table show the SmartList Builder Go To records do exist.
And the second query to the ASIEXP60 joins the SLB10000 table to show that in this case, the SmartList Go To records DO exist and therefore would be displayed by SmartList.
The quickest and easiest first step would be to open the SLB SmartList in SmartList Builder and view the Go To items.
Here we can see the two expected Go To items that were created.
If they did NOT exist, then somehow, they were deleted and would need to be recreated. Or the entire SmartList deleted and then re-imported from an export from Production since that one is correct.
It is also possible, but unlikely, that the ASIEXP60 records were deleted.
The solution in that case would be to re-save the SLB SmartList. Once SmartList is re-opened, SmartList Builder will re-publish the entire SmartList including the Go To items and they would show properly at that point.
If you have any questions, please reach out to us at support@eonesolutions.com.
