Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Smart List only returning 95 rows for 1 user GP 2013 SP2

Posted on by Microsoft Employee

The lists used to work but now, regardless of the maximum number of rows set, it is only returning 95 rows. This is all smartlists. Has anyone seen this behavior before?

Thanks!

Categories:
  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PA+ - Smart List only returning 95 rows for 1 user GP 2013 SP2

    Ok. It's the Sonic Wall Global VPN per this post. community.dynamics.com/.../236001.aspx

    The users have verified that running it in the background without actually making a connection resolved both issues.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PA+ - Smart List only returning 95 rows for 1 user

    More info:

    We got Function Sequence errors in the Dexsql.log and another user is having issues entering dates in Smart lists. They come out a 00/00/0000 regardless of what she puts (this is on a different workstation). Even without a date filter, the list limits itself. With no restrictions at all the list will run as many rows as it needs to. We confirmed that the language settings and Language is US English and the short date format is M/d/yyyy (would that be correct?). Thanks!

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,860 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,398 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans