Feature - Add CSV Support to Payroll History Reports

Feature - Add CSV Support to Payroll History Reports

Release Date: 3/10/2016

Added CSV support to Payroll History Reports: Payroll Check History By Paid Period and
Payroll Check History By Check Date

Note: Support was just added on 3/1/16 to the PRHISFIL for the vacation, holiday and sick 
hours so these fields will not be populated in older data.

If the user chooses to generate the CSV file, one record will be generated for every record
printed on the report. The following headings will be used:

Emp# for Employee Number
Name for Employee Name
SS# for Social Security Number
StrtDate for Pay Period Start Date
EndDate for Pay Period End Date
Tp for Transaction Type
Check# for Check Number
CheckDt for Check Date
GrossPay for Gross Pay
FwtGross for Pay subject to Federal withholding taxes - TAXABLE-GROSS-PAY
SSTax for Social Security Tax withheld
Medicare for Medicare Tax withheld
Fwt for Federal withholding taxes
Swt for State withholding taxes
Ost for Other state taxes
Cwt for City withholding taxes
TtlDed for Total Deductions withheld
TtlAllow for Total Allowances
EIC for Earned Income Credit
NetPay for Net Pay
WksWrk for Weeks worked
RegHrs for Regular hours
OvtHrs for Overtime hours
VacHrs for Vacation hours
HolHrs for Holiday hours
SickHrs for Sick hours
SpecHrs for Special hours 


Modified programs: PRHSTSCN, PRHSTRPT
DLM




    • Related Articles

    • AP11S1 Accounts Payable Check History Report

      Check History Report Application Overview The Check History Report accesses the A/P Open Item File for check information. The A/P Open Item File contains information since the last purge date (date for which the Purge A/P Open Item File was last ...

    • AP Check History Report That Includes Voided Check

      Q - Is there a flag that would allow me to view all AP checks including voided checks and the original checks that were voided?. A - Under A/P -> Reports -> Check History Report -> Print, there are three different kinds: Check History Report All ...

    • Feature - Add Desc2 Column to Item Linkage CSV Report

      Release Date: 4/19/2017 In I/M -> Reports -> Item Linkage CSV Report, the Desc2 column is now added to the exported CSV file. See sample screen below. The following columns are supported in the CSV file: Item# - Item number Desc - Item description 1 ...

    • Feature - Added QI (Qty Sold in Invoice History) Data Type to the User Defined CSV Export

      Release date: 10/8/2020 Version: 8.5 & Up Changes have been made to the Reordering Advice User Defined CSV Export programs. You can access this feature from I/M -> Reports -> Reordering Advice Reports -> Maintenance -> User Defined CSV Layout for the ...

    • Feature - Add Check Void User ID to All Check History Summary Report

      Release Date: 02/25/2025 Version: 8.5 & Higher For better auditing, we added a new column "Void-User" to AP -> Report -> Check History Report -> Print -> All Check History Summary. See sample screen below: Note that this column is only available if: ...