Sage 50 US Intelligence Reporting V2020 - Employee SSN

Question

I have several custom reports created that pull in employee SSN. After installing 2020, the values returned for employee SSN are scrambled. I am assuming this data is now encrypted... but not sure. Tech support is no help. None of the agents even have intelligence reporting on their computers. Anyone know if this data is now encrypted and if so, is there a way for us to get at this data?

mbartnik · Accepted Answer

Hello Mark, 
 the Personal Identifiable Information is available in the List forms that can be exported to Excel. This is one method that is supported by Sage to share this information with external people. I haven't found a tool to decrypt the SSN or other PII information. 
 This is not the best method of getting at this data, especially with a live reporting tool, but you could reference the external data table that is generated with the Employee list sent to excel.

Dave-N-Darlene · Answer

Hi Mark, 
 You are correct, as of 2020, the SSN is encrypted. The good news is is that the 'field' named SSN is encrypted but no others. 
 So the handy workaround is to place the SSN in another field, like custom field 1 and make a coding update to your report to pull the SSN from CF1. 
 I can do this for you if you do not know how to do it yourself. 
 Happy New Year!

Sage 50 US

Sage 50 US Intelligence Reporting V2020 - Employee SSN

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING