Sage 100 Link has no employee ID validation when populating Sage HRMS (Allows for invalid employee ID in HRMS)

Although a rare situation, the Sage 100 link allows for a client who is Needs Review with Sage HRMS and wants to populate the employee data from Sage 100 will allow them to have a severe data issue from the start. Sage HRMS knows that it can't have special characters or blanks. The link should follow these same rules.The way the link should work, it should auto renumber the employee ID from Sage 100 into an acceptable method for Sage HRMS. The options should be as follow: --Start from 1 to 999999999 --Allow the renumber to start from the defined starting point 1000, 10000, 100000 -- There should be an option to keep the number but remove spaces. --It should take into consideration if it is for one company or many. --And allow the renumber to be unique for each company code or by the enterprise