Where does Sage HRMS post the employee tax withholdings
The system stores taxes in UPEMPT and stores tax fields (marital status, exemptions, etc.) in UPEMTF, and it codes the fields by tax.
So the two fields you need to note are PARMSEQ and PARMVAL. The PARMSEQ is a numerical value that increments with each tax or person and corresponds with the fields on the screen (same order). In Employee Payroll detail for USFIT, Tax Info shows seven parameters, and the database stores seven PARMSEQ values per employee.
The PARMVAL is the value in the field. Exemptions map directly (1=1, 2=2, etc.), while fields like marital status follow the dropdown order, which varies by tax.
Example:
To add USFIT exemptions from a Crystal Report, create a formula field using the following.
- Set TAXID=USFIT, PARMSEQ =2 as conditions of the formula field and then use the value of PARMVAL
- If TAXID="USFIT" and PARMSEQ="2" then PARMVAL
- Solution ID
- 224924850073308
- Last Modified Date
- Tue Apr 14 17:19:17 UTC 2026
- Views
- 0