Skip to main content

Notifications

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) / Smartlist Designer: Ar...
Microsoft Dynamics GP (Archived)

Smartlist Designer: Archive employee summary

(0) ShareShare
ReportReport
Posted on by Community Member

Hello All, thanks for looking.

I am trying to build a smartlist that will bring up the employee summary of archived employees. Is this possible?

I'd like to mention, im specifically looking for the pay history of archived employees.

The two gp windows i link that i would assume would bring it up is "Archive Payroll Master" through HR and "payroll Employee Summary" from payroll. But this does not bring it up, all archived employees are missing from this table (900 i believe). Where is this data?

Thank you.

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Smartlist Designer: Archive employee summary

    Hi,

    The problem isn't with your SmartList, it's with your data. If the employee summary file has been cleared, I do not think you can bring it back by unarchiving. I unarchived my test employee and received an error message when I tried to reconcile. If your archived employees do not exist in the UPR00900 table, then the summary does not exist in other places like the UPR30300 and UPR30301. You should still have your Year End Wage records in the UPR10101.

    If you think you can retrieve the summary by unarchiving and reconciling, please do it and let me know how you did it. If you can, you can delete the inactive records again, just don't delete the history.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at
    RE: Smartlist Designer: Archive employee summary

    Good point, this is looking to be the case, i am going to look in to that. Thank you for your help.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Smartlist Designer: Archive employee summary

    Archiving an employee shouldn't delete it from the UPR00900. I just Archived one and it's in both tables. Did someone delete 'inactive' records and also delete history for inactive records? That will for sure delete the records from the UPR00900. I've not tried it, but can you in fact unarchive and then reconcile to repopulate the UPR00900 table?

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at
    RE: Smartlist Designer: Archive employee summary

    Here is a picture of what i have. Key is employee id.

    2016_2D00_04_2D00_26-14_5F00_09_5F00_25_2D00_atlasmitest1-_2D00_-Remote-Desktop-Connection-Manager-v2.7.png

    In SQL, i have data in both tables, but the data inside do not match.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Smartlist Designer: Archive employee summary

    Hi,

    I just built a SmartList using those two tables, and it worked just fine. What kind of join are you using and what keys did you create on the link? Make sure the Archived Employee table has data in it.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at
    RE: Smartlist Designer: Archive employee summary

    thanks for your response. a archived employee in UPRA0100 does not show in URP00900. I would imagine this is because they have been archived?

    All active employees are indeed in urp00900.

    If i were to unarchive(HR) a employee and then reconcile in payroll, they will pop back up in URP00900, but we are trying to smarlist this process instead. I just cannot figure out where this data is archived to.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Smartlist Designer: Archive employee summary

    Those two tables should do it. Using SQL Studio Manager, open table UPRA0100 and record the employee ID of one of your archived employees. Then open table URP00900 and see if that employee ID exists in that table. If it does, you may not have your table join set up correctly in SmartList.

    Does the employee ID show up in both tables? I'll give it a try with my sample data.

    Kind regards,

    Leslie

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans