web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / HRP_BEN2_System_Prefer...
Microsoft Dynamics GP (Archived)

HRP_BEN2_System_Preferences

(0) ShareShare
ReportReport
Posted on by Jim Lines 4

Greetings,

I think I'm losing it... I'm trying to find the SQL table name for HRP_BEN2_System_Preferences.  I can't find any info online, my GP table reference, or clearly in the Support Debugging tool.  I'm looking for the tables that holds the radio button values from the Benefits Preferences below.  

2016_2D00_08_2D00_24_5F00_11_2D00_07_2D00_55.jpg

Any help is appreciated.  Thanks. 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    NHayden Profile Picture
    NHayden 250 on at

    The values for these radio buttons are stored in DYNAMICS..SUSPREF.  There is a column called IINDEX_I that stores a value representing the option, and a POINTS_I column that stores the value.  The first option, "Post Estimated Return Date to the To Do list" is stored in IINDEX_I 202.  The second option is IINDEX_I 203.  The option for "Medical Preferences" is 204, and "General Preferences" is 5001.  Some of these values may not exist if the values haven't been changed from the default value of "Never" on the window. 

  • Jim Lines Profile Picture
    Jim Lines 4 on at

    Nathan,

    Thanks so much!  I couldn't even begin to guess WHY you know this! LOL.  This is exactly what I needed.  

    Thanks!

  • Jim Lines Profile Picture
    Jim Lines 4 on at

    Nathan,

    There seems to be only one entry per Index.  How would I go about finding the related company database?

    Jim

  • NHayden Profile Picture
    NHayden 250 on at

    Jim,

    I'm not sure how to answer that.  If I change the values in one company, they are set like that when I log into another company.  It doesn't appear that GP is storing different values for different companies but is using the values globally for all companies.  Sorry I can't provide any additional insight, but Microsoft may be able to tell you more.  

    Nathan

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans