We now receive the following message when running this smart list:
select T1.DECPLQTY, count(*) frorr (select * frorr svReceivingLine with (NOLOCK)) T1 group by T1.DECPLQTY
This list was working previously 0 any ideas?
*This post is locked for comments
Thanks,
Excellent explanation
Excellent Answer Georgia! That did the trick!
We had a client report a similar issue and discovered that it is related to the new eOne version of SmartList Builder. If a user accidentally modified the canned GP version of the Receivings Line Item SmartList in the eOne version of SmartList Builder, it may cause uses to receive the above error or not get any data when they open the SmartList.
When a user modifies one of the canned SmartLists via the new version of Smart List Builder the following happens:
To see this, go to the Customization Status window (Microsoft Dynamics GP button > Tools > Customize > Customization Status) and temporarily disable SmartList Builder. Then go back into SmartList (Microsoft Dynamics GP button > SmartList) and you will see there are 2 SmartLists with the same name of Receivings Line Items. The top folder with that name is the modified version of the SmartList and the bottom folder is the canned version. If you click on the top folder you will get the error or no data. If you click on the bottom folder, the data displays correctly.
I would check the SmartList Favorites in each folder to make sure they are identical. If there are any favorites in the top folder that are not in the bottom folder, take screen shots of the columns and search selections so that you will be able to recreate the favorites later.
Close out of GP and then sign in again so that SmartList Builder is enabled again.
Then go into SmartList Builder (Microsoft Dynamics GP button > Tools > SmartList Builder > SmartList Builder). Select Existing in the SmartList Type, then do a LookUp and you will see that the modified Receivings Line Items SmartList has an asterisk after it (Receivings Line Items*) -- the asterisk indicates it has been modified. So you can select that and then delete it. This will put the canned version back into GP so the user will be using the canned Receivings Line Items SmartList instead of a modified version.
Then you may need to go add back the favorites if any are missing.
Note - there are no restrictions or calculations setup in this smart list.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (