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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Employee address not s...
Microsoft Dynamics GP (Archived)

Employee address not saving - employee maintenance

(0) ShareShare
ReportReport
Posted on by Baycare Health Systems 439

Hello,

We have come across an issue where by we are not able to save data for a new record entered in employee maintenance.

We can enter in the address for the new employee, select save, close out of the card and go back in and the data entered is missing - the name and id will display fine.  What is weird is that we can type the employee number in the field and bring up the employee, enter the data in and save it - close the record and type in the employee number and  it will show the address entered but as soon as we try and use the search and select the employee record the address is missing.

We are also unable to enter in a new employee record as it will display the employee # of the above employee except all the data is blank.  I am not sure what this issue is and how to resolve it.

Thanks

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Employee address not saving - employee maintenance

    Was it always doing this or did this just start?

    1) Try doing this logged into GP as 'sa'. There may be a table permission issue

    2) Run GRANT.SQL

    3) Run SQL Profiler for the GP user try to do this and see if there are any anomalies.

    4) Has anyone added any triggers to the UPR00102 or UPR00100 table?

  • Baycare Health Systems Profile Picture
    Baycare Health Systems 439 on at
    Re: Employee address not saving - employee maintenance

    This happened once before but we were able to simply delete the record and the user was able to enter the entire employee record.  This time this did not solve the problem.

    I have tried doing this as sa but I encounter the same problem.  No triggers have been added as far as I know.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Employee address not saving - employee maintenance

    Please try running the SQL Profiler when doing this and see what is going on is SQL. You can send me the trace and I will take a look at it.

  • Community Member Profile Picture
    Community Member on at
    Re: Employee address not saving - employee maintenance

    We are having a similar issue at a client's and they have added FastPath and i believe some triggers to review information when it changes at the UPR00100.  Can you elaborate on if the Grant SQL script would help if a trigger has been added? If not, how the trigger can impact the GP table?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Employee address not saving - employee maintenance

    GRANT.SQL will set access rights to all objects in the company database to all users in the DYNGRP. Triggers are attached to tables so it will.

  • Community Member Profile Picture
    Community Member on at
    Re: Employee address not saving - employee maintenance

    We have run the grant scripts and still having a problem.  We will be working with Microsoft via a case to research, but can anyone confirm what corrected / caused this issue for the other customer?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Employee address not saving - employee maintenance

    Have you tried running SQL Profiler while adding the address? Something is preventing the address from being commited to the database. Does the same thing happen when logged in as 'sa'? Are there any third-party products involved?

  • Community Member Profile Picture
    Community Member on at
    Re: Employee address not saving - employee maintenance

    Was there resolution to this issue?  We are having something like this as well at a client.

  • Community Member Profile Picture
    Community Member on at
    Re: Employee address not saving - employee maintenance

    We never found out what was causing this but we would notice that the primary address was not in the addess table, even though employee ID seemed fine.  User would log out and log back in and it would take.  Please let us know if you find the trigger.

  • Sherlene Sorenson Profile Picture
    Sherlene Sorenson 967 on at
    Re: Employee address not saving - employee maintenance

    I have a client with a similar issue.  Please update us if there was ever a resolution found for this.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans