I'm trying to create a custom crystal report that shows Employee Number, Full Name, Gross wages, Pre-Tax Deductions, Post-Tax Deductions, Gross wages (excluding Pre-Tax Deductions).
I believe I need to use UPEMPL, UPCHKH, and UPCHKD to get the Employee Number, Full Name, and Gross Wages. I can sum the check detail on Category=4 (Deductions) to get all deductions but how do I determine if it is a pre-tax or post-tax deduction?
Any help would be appreciated.
EDIT: We are using Sage HRMS v10.7045 / Sage 300. We will be applying the quarterly update in the next day or two.