Sage 100

I think I am sounding like a broken record. Payroll v2018. You cannot link to payroll data files through ODBC. (They are encrypted). If your client has Crystal Reports that pull payroll data, they will not work in V2018. There is supposed to be a BOI work around, but I don't understand how to do this. Has anyone solved this issue?

Wasn't that a security setting issue?

I believe @NicoleRonchetti posted a work-around to this a while ago... If memory serves there are special tables to use (within a Custom Report) instead of what you might expect.

https://90minds-com.socialcast.com/messages/37563069

As long as you add the report to the Payroll Menu, it adds an unencrypted file linked in that you can pull the data from. Also you can do other versions of standard reports.

Sage KB link - https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=88325&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=7092&cmd=displayKC&dialogID=277875&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

Add the PII work table to the report to pull the PII protected data. Import into the custom reports menu. Run from the custom reports menu. The data won't show up when tested from inside cyrstal reports using refresh, but will show up when running from the custom folder.

Has anyone tried to build a shadow table to store an unencrypted copy of payroll data? Define a UDT with the employee key and the columns you want to use outside of Sage. Create a script for the employee master table PostWrite and PostDelete to maintain the table. This would be similar to the Steve Malgren AR_Customer shadow table from years ago.

Thank you for everyone's help. I now know how to work around this issue. Could not figure this out just using the knowledge base, so I am really happy I am a 90 Mind!