Microsoft Edge Try Microsoft Edge A fast and secure browser that's designed for Windows 10 Get started

This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft
Dynamics 365 Community
  • Microsoft 365
  • Azure
  • Office 365
  • Dynamics 365
  • SQL
  • Windows 10
      • Windows Server
      • Enterprise Mobility + Security
      • Power BI
      • Teams
      • Visual Studio
      • Surface for Business
      • AI
      • Internet of Things
      • Azure Cognitive Services
      • Quantum
      • Research
      • Docs
      • TechNet
      • Developer Network
      • Windows Dev Center
      • Windows IT Pro Center
      • FastTrack
      • Partner Network
      • Solution Providers
      • Partner Center
      • Cloud Hosting
      • Education
      • Financial services
      • Government
      • Health
      • Manufacturing & resources
      • Retail
      • Security
      • Licensing
      • AppSource
      • Azure Marketplace
      • Events
    • View all
    Sign in
    • Home
      • Sales
      • Customer Service
      • Field Service
      • Talent
      • Finance and Operations
      • Retail
      • Project Service Automation
      • Marketing
      • Business Central
      • General
      • Microsoft Dynamics CRM
      • Microsoft Dynamics AX
      • Microsoft Dynamics NAV
      • Microsoft Dynamics GP
      • Microsoft Dynamics SL
      • Other Products
    GP Forum Ideas
    • Learning Resources
    • Documentation
    • GP Blogs
    • Community News
    • Get Started
    • Introduce Yourself
      • Earn Badges
      • View Badges
      • Compete on Leaderboards
      • View Leaderboards
    • Become an Expert
    • Request a New Blog
    • Provide Feedback
    User Groups

    • Sign In/Sign Up
    • Home
    • Forum
    • Blogs
    • Videos
    • Experts
    • Support
    • Communities
      • Microsoft Dynamics AX
      • Microsoft Dynamics CRM
      • Microsoft Dynamics GP
      • Microsoft Dynamics NAV
      • Microsoft Dynamics SL
      • Other Products
      • Partner Community
      • Envision

    Microsoft Dynamics GP 2013 Service Pack 2 does not seem to play NICE with Business Portal Human Resource Self Service Suite 6.0

    • Sign In
    • Home
    • Share
      • Twitter
      • LinkedIn
      • Facebook
      • Email
      • Print
    • RSS
    5 Nov 2013 12:09 PM

    We all know what happens when table changes are made with service packs! :-)

    Well, the table changes we made in GP 2013 Service Pack 2 around Payroll Direct Deposit did not make Business Portal Human Resource Self Service function correctly.

    As we approach the year end season and many customers will be installing the US payroll year end update, which will include GP 2013 service pack 2, we may see more run into issues.

    To know you are running into this issue here are a few indicators after service pack 2 is applied:

         1. When the employee clicks on the Pay link and selects Direct Deposit, there is a Server error '/' in Application error.
         2. When an employee clicks on the Pay link and views a pay stub, at the bottom there is an error: Invalid column name INDEX1.
         3. When I submit an employee profile change, it is not processed and updating Microsoft Dynamics GP as you would expect.
         4. When you approve an timecard in HRMSS, you may see an error such as - Invalid column name ‘INDEX1’ ---> System.Data.SqlClient.SqlException: Invalid column name ‘INDEX1’.

    Basically, if you use BP HRMSS and you installed GP 2013 service pack 2 (or a later patch), you need to install the BP Hotfix that will correct any issues related to this table change.

     

    Here is the LINK to download the fix.

     

    Thanks, let the fun begin!

    Terry Heley

    Tags: BP 5.1 Dynamics GP Dynamics GP Blogs Dynamics GP Human Resources & Payroll Dynamics GP Human Resources &amp Dynamics GP Human Resources & Payroll GP 2013 GP Blogs hotfix Microsoft Dynamics GP update Upgrades

    Meet the Author

    Terry R Heley picture
    Terry Heley
    Works for Microsoft in Fargo
    Blog

    About Dynamics GP Support and Services Blog

    Welcome to the Dynamics GP Support and Services Blog. This new blog is designed to provide you the insights, knowledge and challenges that our support engineers tackle every day.

    Microsoft Dynamics GP

    Get help on your Microsoft Dynamics GP solution from qualified experts in the forums, read blogs and how-to articles, and watch videos.
    RSS

    Recommended Content

    Microsoft Dynamics GP Business Portal Human Resource Self Service Suite 2014 W-4 has released!
    by Terry R Heley on 6 Feb 2014
    • 4 comments
    Human Resource & Payroll Timecard Entry NEW to GP 2013 R2!
    by Terry R Heley on 12 Jun 2014
    • 9 comments
    Most popular voted features by YOU for Human Resource and Payroll added to GP 2013 Service Pack 2!!
    by Terry R Heley on 8 Oct 2013
    • 0 comments
    Service Pack 2 for Microsoft Dynamics GP 2013 is now available!
    by Terry R Heley on 29 Aug 2013
    • 3 comments
    Benefit Self Service in Microsoft Dynamics GP 2015, the product that makes your Benefit Open Enrollment process stress-free!
    by Terry R Heley on 20 Jan 2015
    • 3 comments
    View More

    Top Tags

    Dynamics Dynamics GP Dynamics GP 2010 Dynamics GP Blogs GP GP 2010 GP 2010 R2 GP 2013 GP 2013 R2 GP 2015 GP Blogs GP2010 Great Plains Microsoft Dynamics Microsoft Dynamics GP Microsoft Dynamics GP 2010 payroll update Whats New YE year end Year end close Year end update year-end Year-End Close

    What's new

    • Surface Book 2
    • Surface Pro
    • Xbox One X
    • Xbox One S
    • VR & mixed reality
    • Windows 10 apps
    • Office apps

    Store & Support

    • Account profile
    • Download Center
    • Sales & support
    • Returns
    • Order tracking
    • Store locations
    • Support
    • Buy online, pick up in store

    Education

    • Microsoft in education
    • Office for students
    • Office 365 for schools
    • Deals for students & parents
    • Microsoft Azure in education

    Enterprise

    • Microsoft Azure
    • Enterprise
    • Data platform
    • Find a solutions provider
    • Microsoft partner resources
    • Microsoft AppSource
    • Manufacturing & resources
    • Financial services

    Developer

    • Microsoft Visual Studio
    • Windows Dev Center
    • Developer Network
    • TechNet
    • Microsoft Virtual Academy
    • Microsoft developer program
    • Channel 9
    • Office Dev Center

    Company

    • Careers
    • About Microsoft
    • Company news
    • Privacy at Microsoft
    • Investors
    • Diversity and inclusion
    • Accessibility
    • Security
    English (United States)
    • Contact Us
    • Privacy & Cookies
    • Terms of Use
    • Trademarks
    • © Microsoft 2018