Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SmartList Issue

(0) ShareShare
ReportReport
Posted on by 455

Background information: 

  • Inventory Control - user category #2 is my commodity code.
  • Item #'s contain either a dash and a plus sign or a dash, plus sign, and parenthesis

I created a basic SmartList from the Item Quantities SmartList where I search for any item where the commodity code is blank. I have 2 items showing up on this SmartList that shouldn't - they do have a commodity code assigned. I suspect part of the reason is due to the way the SmartList displays the items with special characters.

For the first item # 4931T123-(5Y)+C, the SmartList displays the item number without the parenthesis 4931T123-5Y+C so when I double click the item, it cannot be found in the Item Quantities screen.   The second item , MS111-1+C, there is a space in front of the plus sign on the SmartList MS111-1 +C so it also cannot be found in the Item Quantities screen when I double click on it.

Has anyone else seen this strange behavior? Any thoughts on how to resolve? 

*This post is locked for comments

  • Susan Lentz Profile Picture
    Susan Lentz 455 on at
    Re: Re: SmartList Issue

     Victoria - thank you for the tip. Thta was the problem. Bad data in IV00102. What threw me off was the item #s were so close - just the space and the parenthesis missing. All fixed. Thanks everyone!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: SmartList Issue

    Susan,

    How were the items (and specifically item numbers) populated into GP?  And what version and service pack of GP are you on?  I just did some testing with GP 9.0 and am not seeing any issues with either the parenthesis not showing up or extra spaces in SmartList.  So I am wondering if you look at your data in the SQL table directly (IV00102 is the item quantity master) if it will show up strangely, like maybe with extra characters or not exactly how you would expect?

  • Susan Lentz Profile Picture
    Susan Lentz 455 on at
    Re: Re: SmartList Issue

     Richard - I started with a standard GP SmartList and just added the search criteria where commody code is = to blank.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: SmartList Issue

    Are you using a standard SmartList provided by Microsoft?  Or one created by your team using SmartList Builder?  Or a Favorite.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans