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) / HR & Payroll - Ord...
Microsoft Dynamics GP (Archived)

HR & Payroll - Order EmployeeID numbers without leading zeros

(0) ShareShare
ReportReport
Posted on by Community Member

Greetings,

Currently,  whenever a new GP EmployeeID number is entered, the EmployeeID was entered with leading zeros, such as 000062, 000072, 005121, etc. This was done so that our GP EmployeeID would match the Employee ID in our Time Clock system.

We are using our TEST company to evaluate using PSTL to modify the EmployeeID numbers by removing the leading zeros. The change works very well. An undesired effect is the ordering of the GP EmployeeID  numbers when preforming a Lookup.

With Leading Zeros       Without Leading Zeros      Desired Order

000062                           115210                               62

000071                            5121                                  71

005121                            62                                      5121

115210                            71                                      115210

Is there some way to achieve the desired ordering?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    There is no option available like your desired order. Because, GP lookup works based on current employ id values. It will not consider the older values. Once you changed the employee id by using PSTL, it will replace the old values by your new values. So, there is no place to find the older values.

    Otherwise you have to replace your older values based on desired orders.

    Hope this helps!!!

  • Verified answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,897 on at

    Just my thoughts.... There is no option available readily, but you can achieve it thru little bit of customization. Created a DB trigger to update the User defined 1 or 2 field(if not being used for any other purpose) within Additional Information Window with just the numeric value of the Employee ID on Insert of Employee Table. And then use Advanced Lookup to add User Defined 1 or 2 as additional sort option.

    Update: Sorry, it may not work with just numeric values Coz User Defined fields are again Text field and will produce the same result. But you can update it with Leading Zeros and it may work for you.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Yes. I am agree with Jothikrishnan.

    You can do it by using small SQL trigger or Dex trigger. If you are not using User Defined Field.

    Before using PSTL tool to modify the employee ID, update the old values to user defined field then modify your employee ID and use advance lookup or create a employee smarlist favorite with using user defined field and set as default in lookup.

    Then create a trigger(SQL/Dex) for update the user defined field whenever creating new employee.

    Hope this helps!!!

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,897 on at

    Just one more point to consider...When you write the Insert trigger, make sure it updates  only once...Coz later if you update the employee ID through PSTL tool, it will again trigger both Insert and Delete Trigger(Update in SQL is Combination of Insert and Delete behind the scene), therefore make sure it doesnt impact the User Defined field.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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