Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Specific Smartlist objects are empty and no columns available for selection

Posted on by 540

I have a client on GP 2013 R2 and have been for a while but just recently, there are certain standard objects (e.g. Payables Transactions) that are empty including the default. If we choose to select columns, none are available. This is also happening with some HR objects. It happens for every user regardless of the workstation.

Any ideas?

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Specific Smartlist objects are empty and no columns available for selection

    In order to troubleshoot this issue. Can you run the sql profiler to check what is happening in the back end when selecting this smartlist it will give you some information.

  • Pete72 Profile Picture
    Pete72 540 on at
    RE: Specific Smartlist objects are empty and no columns available for selection

    Hi Soma,

    we checked this and there were no discrepancies. Thanks for the suggestion.

  • soma Profile Picture
    soma 24,406 on at
    RE: Specific Smartlist objects are empty and no columns available for selection

    Have you checked the non-unicode region language of users machines? Sometimes it will occurs due to GP SQL server language is mismatch with users machines region language.

    So, please verify the region and language settings in both working and non-working computers and change it to same language.

    Hope this helps!!!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans