Sage 100

in v2018 payroll considering the PII encrypted data, what is the best way to export a 401k report to a csv file? Our developer wrote a script to do it and it works great in our office installs, but when we try it at a client's site (we're tried it 2 different client locations, Sage 100 Standard for both) we get an error 'Set module failed. The Payroll modules cannot be used due to missing or out-of-sync\metering data. The system may be able to repair the data.\do you want to proceed with the repair effort?' The script is failing right away on this line: retVal = oSS.nSetProgram(oSS.nLookupTask(""PR_Employee_UI"")). I created a case with Sage June 13th and have gotten any solutions or suggestions from them about it yet. Our hypothesis why it works in our lab is we have unlimited PR reseller keys that might not look at sy_metering? We don't have any 2018 unlimited clients to test this theory on and for sure are NOT going to upgrade anyone else to Sage 2018 payroll until we get this solved.

Use the following steps if PII fields are desired in a Custom Crystal Report: Import Crystal Report into Sage 100 using run Sage 100 Report Manager Select the option ""Do you want to include a PII worktable with this custom report?"" when importing the Crystal Report The PR_EmployeePIIWrk table will be added to the report and must be properly linked to the existing tables in report The desired PII fields must be pulled from the PR_EmployeePIIWrk table Note: PII fields can only be displayed on Crystal Reports run within Sage 100 [Via](https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=88325&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=27813&cmd=displayKC&dialogID=1101082&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true)

This may be more relevant as it shows what appears to be a [scripting ](https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=89390&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=27840&cmd=displayKC&dialogID=1101724&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true)example

Thanks @WayneSchulz - I'll forward this document on to our programmer