Employee Master File

Question

We just updated our Sage 100 to the 2019 Advanced version. We also use Sage payroll and downloaded the latest version. In previous versions, there was an ODBC database file named PR1_EmployeeMaster. I don't see that file is available in the 2019 version. Is there a different file that contains the same information? I looked at the PR_Employee file, but it is blank. Any ideas?

David Speck · Accepted Answer

PR1_EmployeeMaster is replaced with PR_Employee. 
 You can refer to this page for cross reference of PR's old file names to new table names. 
 http://help-sage100.na.sage.com/2019/FLOR/#Old_File_Names_to_New_File_Names_Listing/Old_File_Names_to_New_File_Names_Mappings_Overview.htm%3FTocPath%3DCross%2520Reference%2520Information%7COld%2520File%2520Names%2520to%2520New%2520File%2520Names%2520Mappings%7C_____0 
 Regarding PR_Employee being blank, either you have enabled ODBC Security and the user you are authenticating with does not have a role assigned with access to the tables on the ODBC Security tab and/or the data you are after is now considered PII (Personally Identifiable Information) and Sage is now encrypting the PII data so you can not just query it via ODBC. 
 If you must query the data, you will have to added a Custom Report to the PR menu and then link in the PII table, refer to this KB for more details. 
 https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=101302

socasue · Answer

There is also an Anytime Learning topic on Sage U that shows how to add the PII data to your crystal reports

Sage 100

Employee Master File

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING