Payroll Data Missing in Microsoft Query Sage Intelligence 100

Question

I am pulling from the table used in the PR_EarningsReport but not all fields are being populated in my query. For example, I can get Employee Number but not First and Last Name?

David Speck · Accepted Answer

If on version 2018+, certain information considered Personally Identifiable Information (PII) is encrypted and can't be viewed via ODBC by querying the table directly. 
 See these KB articles. 
 https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=88325 
 https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=101302 
 However, I'm not sure how this would be accomplished with sage intelligence.

Sage 100

Payroll Data Missing in Microsoft Query Sage Intelligence 100

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING