Check history reporting in Sage 100 v2019.

Question

I'm converting some old Crystal reports from Sage 100 v2017 to v2019. The reports from v2017 use the tables: 
 PR_22PerpetChkHistoryHeader and PR_23PerptHistoryDetail 
 These tables don't exist in v2019. What table(s) should I use in their place? I tried PR_CheckHistoryReportWRK but get no results. 
 -Eric

Kevin M · Accepted Answer

The File Layouts and Program Information list these details. 
 
 https://help-sage100.na.sage.com/2019/FLOR/Content/Old_File_Names_to_New_File_Names_Listing/PayrollFileMapping.htm

Kent Mackall · Answer

Greetings, 
 The information in those legacy PR tables was moved to PR_PayrollHistoryHeader and PR_PayrollHistoryDetail for Payroll 2.0. 
 For more information, go to the Information Center in Sage 100 and click on the Resource link. Then click the File Layouts and Program Information link. Click on the Cross Reference Information topic. Select Old File Names to New File Names Mappings, then Select Payroll. Here you will see the Payroll Schema mappings for the old to new file names. 
 Thank you, Kent

Kent Mackall · Answer

Greetings, 
 
 For 1) See the Following help topic: https://help-sage100.na.sage.com/2020/index.htm#Subsystems/PR/Concept/Security_for_PII.htm?Highlight=Payroll PII 
 For 2) you are correct. The Amount data from the legacy PR_23 table records is mapped to PayAmt in the PR_PayrollHistoryDetail table during conversion. 
 Thank you, Kent

Sage 100

Check history reporting in Sage 100 v2019.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING