i'm assuming the mascrw.exe didn't convert table names like it did for AP and AR.

in a report, in database manager you can point the report to a new table.  In theory if the fields names were the same then it should work.

There are some very dramatic changes in the crystal report format in the change from legacy to the business frameworks model so you have to recreate from scratch.

We were able to change the database location to point to the new tables and map the fields (as needed).  Then link in the PII table (we found that has to be before the Employee file in linking).  Remember when adding to the Payroll Custom Reports menu to check the "Create the PII file" message.

You then MUST have payroll reports on the payroll custom reports menu for them to work and provide data.  Payroll reports can no longer be run off of other module Custom Reports menu's (or from straight crystal reports) if employee data (found in the PII table) is required (and that is all the reports we have come across so far).

Another item of note:  the Payroll Perpetual History has been replaced with just Payroll History data files, but there are 3 of them now (Payroll History Detail , Payroll History Header & Payroll History Tax Detail.  So if you have reports build from the old payroll perpetual history that includes tax detail you will have much more work because you can only link / map 1 to 1 old to new tables.

Greetings,

Here is the product help documentation for the Sage 100 Report Manager about including the PII worktable that I have pasted below. There is also a help topic titled "Security for Personally Identifiable Information" that provides an overview on how PII data is handled in Sage 100

Use Report Manager to manage all forms and reports. Select a form or report to customize using the SAP Crystal Reports Designer.

The Report Manager window lists all modules that have forms or reports in a tree view. Expand the module to select the available forms, reports, and custom reports. All forms, reports, and custom reports are listed in alphabetical order.

You can also add and delete custom reports. When you click Add Report to Menu, the Menu Wizard opens and guides you through the process.

Thanks,
Kent

There is an Anytime Learning course on Sage U that illustrates how to write reports with PII